普华永道 咨询资料 员工退休到龄预警.pdfVIP

SELECT语句：

SELECTppv.full_name,ppv.employee_number,

DECODE(ppv.sex,M,男,F,女),ppv.attribute4,

ROUND(MONTHS_BETWEEN(SYSDATE,ppv.date_of_birth)/12-0.5),

ppv.date_of_birth,houv.NAME,hpf.NAME

INTO

L_PERSON_NAME,L_EMPLOYEE_NUMBER,L_EMPLOYEE_SEX,L_EMPLOYEE_

SF,

L_EMPLOYEE_AGE,L_EMPLOYEE_BIRTH,L_EMPLOYEE_ORGNAME,L_EMPLO

YEE_POSNAME

FROMper_people_fppv,

per_assignments_fpaf,

hr_organization_units_vhouv,

hr_positions_fhpf

WHEREpaf.primary_flag=Y

ANDDECODE(ppv.attribute4,

工人,ADD_