DBA Data[Home] [Help]

APPS.PAY_IN_FF_PKG dependencies on PER_PEOPLE_F

Line 870: FROM per_people_f ppf

866: IS
867: SELECT DISTINCT(DECODE(pcr.contact_type,'JP_FT','Father','F','Father','S','Spouse')) relation_type
868: , ppf.sex sex
869: , ppf.marital_status marital_status
870: FROM per_people_f ppf
871: , per_assignments_f paf
872: , per_contact_relationships pcr
873: WHERE paf.assignment_id = p_assignment_id
874: AND paf.person_id = ppf.person_id