普华永道 咨询资料 HR-P-0002Setup.pdfVIP

HR-P-0002试用期结束预警

安装说明

1.预警定义界面及sql

其中Select语句定义如下：

SELECTPPV.PERSON_ID,PPV.FULL_NAME,PPV.EMPLOYEE_NUMBER,HR_PV.NAME

PS_NAME,HOUV.NAME,PAV.date_probation_end,PAV.PROBATION_PERIOD,FLV.MEANI

NG

INTO

L_PERSON_ID,L_PERSON_NAME,L_EMPLOYEE_NUMBER,L_POSITION_NAME,

L_ORGANIZATION_NAME,L_PROBATION_END_DATE,L_PROBATION_PERIOD,

L_PROBATION_UNIT

FROMPER_PEOPLE_FPPV,PER_ASSIGNMENTS_FPAV,HR_POSITIONS_F

HR_PV,HR_ORGANIZATION_UNITS_VHOUV,

FND_LOOKUP_VALUES_