DBA Data[Home] [Help]

APPS.PAY_IN_FF_PKG dependencies on PER_CONTACT_RELATIONSHIPS

Line 878: , per_contact_relationships pcr

874: , ppf.sex sex
875: , ppf.marital_status marital_status
876: FROM per_people_f ppf
877: , per_assignments_f paf
878: , per_contact_relationships pcr
879: WHERE paf.assignment_id = p_assignment_id
880: AND paf.person_id = ppf.person_id
881: AND pcr.person_id = ppf.person_id
882: AND pcr.contact_type IN ('JP_FT','F',DECODE(ppf.marital_status,'M','S'))