DBA Data[Home] [Help]

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;