DBA Data[Home] [Help]

APPS.HR_CONTACT_RELATIONSHIPS dependencies on PER_ASSIGNMENTS_F

Line 886: , per_assignments_f paf

882: --
883: Cursor check_garnishor(l_contact_id NUMBER,l_contact_relationship_id NUMBER)
884: is select '1'
885: from pay_personal_payment_methods_f ppm
886: , per_assignments_f paf
887: , per_contact_relationships pcr
888: , fnd_sessions f
889: where ppm.payee_type = 'P'
890: and ppm.payee_id = l_contact_id

Line 942: per_assignments_f asg,

938: cursor cur_ben is
939: select 'Y'
940: from
941: fnd_sessions fnd,
942: per_assignments_f asg,
943: pay_element_entries_f ent,
944: ben_beneficiaries_f ben
945: where ben.source_id = p_contact_id
946: and ben.source_type = 'P'