员工退休到龄预警.doc

SELECT 语句:
SELECT , ,
DECODE (, 'M', '男', 'F', '女'),,
ROUND (MONTHS_BETWEEN (SYSDATE, ) / 12 - ),
,,
INTO &L_PERSON_NAME,&L_EMPLOYEE_NUMBER,&L_EMPLOYEE_SEX,&L_EMPLOYEE_SF,
&L_EMPLOYEE_AGE,&L_EMPLOYEE_BIRTH,&NAME,&L_EMPLOYEE_POSNAME
FROM per_people_f ppv,
per_assignments_f paf,
anization_units_v houv,
hr_positions_f hpf
WHERE = 'Y'
AND DECODE (,
'工人', ADD_MONTHS (, 600),
'干部', DECODE (,
'M', ADD_MONTHS (, 720),
'F', ADD_MONTHS (, 660)
)
) <= ADD_MONTHS (TRUNC (SYSDATE), 2)
AND =
AND anization_id = anization_id
AND =
AND NVL (, TRUNC (SYSDATE)) >= TRUNC (SYSDATE)
AND NVL (, TRUNC (SYSDATE)) <= TRUNC (SYSDATE)
AND NVL (, TRUNC (SYSDATE)) >= TRUNC (SYSDATE)
AND N