DBA Data[Home] [Help]

APPS.PAY_IN_FF_PKG dependencies on PER_CONTACT_RELATIONSHIPS

Line 872: , per_contact_relationships pcr

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
875: AND pcr.person_id = ppf.person_id
876: AND pcr.contact_type IN ('JP_FT','F',DECODE(ppf.marital_status,'M','S'))