普华永道 咨询资料 交流借调预警.pdfVIP

SELECT语句：

SELECTppv.full_name,ppv.employee_number,pac.segment2

intoL_PERSON_NAME,L_EMPLOYEE_NUMBER,L_EMPLOYEE_TODATE

FROMper_people_fppv,

per_analysis_criteriapac,

per_special_info_types_vpsit,

per_person_analysesppa

WHEREpac.segment2=to_char(SYSDATE,DD-MON-YYYY,NLS_DATE_LANGUAGE=

english)

ANDpac.id_flex_num=psit.id_flex_num

ANDpsit.NAME=交流与借调

ANDpac.analysis_criteria_id=ppa.analysis_criteria_id

ANDppa.person_id=ppv.person_id

ANDNVL(ppv.EFFECTIVE_END_DATE,TRUNC(SYSDATE))=TRUNC(SYSDATE)

ANDNVL(