DBA Data[Home] [Help]

APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PER_DISABILITIES_F

Line 1435: FROM per_disabilities_f pdf

1431: pdf.dis_information3 disability_type,
1432: pdf.dis_information4 consequence,
1433: DECODE(pdf.dis_information5,'6','7','7','8','8','9',pdf.dis_information5) disability_control,
1434: pdf.incident_id
1435: FROM per_disabilities_f pdf
1436: WHERE pdf.person_id = p_person_id
1437: AND pdf.registration_id = cp_registration_id
1438: AND p_effective_date BETWEEN pdf.effective_start_date
1439: AND pdf.effective_end_date;