DBA Data[Home] [Help]

APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PER_WORK_INCIDENTS

Line 1443: FROM per_work_incidents pwi

1439: AND pdf.effective_end_date;
1440:
1441: CURSOR c_work_incident_info (cp_incident_id NUMBER) IS
1442: SELECT pwi.inc_information1 risk_type
1443: FROM per_work_incidents pwi
1444: WHERE pwi.person_id = p_person_id
1445: AND pwi.incident_id = cp_incident_id;
1446:
1447: ld_effective_date DATE;