[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'))