APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PER_DISABILITIES_F
Line 1360: FROM per_disabilities_f pdf
1356: pdf.dis_information3 disability_type,
1357: pdf.dis_information4 consequence,
1358: pdf.dis_information5 disability_control,
1359: pdf.incident_id 1360: FROM per_disabilities_f pdf 1361: WHERE pdf.person_id = p_person_id
1362: AND pdf.registration_id = cp_registration_id
1363: AND p_effective_date BETWEEN pdf.effective_start_date
1364: AND pdf.effective_end_date;