DBA Data[Home] [Help]

APPS.PER_MEA_BUS dependencies on PER_DISABILITIES_F

Line 884: FROM per_disabilities_f pdf

880: -- Declare cursor
881: --
882: CURSOR c_disability_id IS
883: SELECT disability_id
884: FROM per_disabilities_f pdf
885: WHERE pdf.disability_id = p_disability_id
886: AND pdf.person_id = p_person_id
887: AND pdf.incident_id = p_incident_id
888: AND p_effective_date BETWEEN pdf.effective_start_date

Line 988: FROM per_disabilities_f pdf

984: -- Declare cursor
985: --
986: CURSOR c_disability_id IS
987: SELECT disability_id
988: FROM per_disabilities_f pdf
989: WHERE pdf.disability_id = p_disability_id
990: AND pdf.person_id = p_person_id
991: AND p_effective_date BETWEEN pdf.effective_start_date
992: AND pdf.effective_end_date;