DBA Data[Home] [Help]

APPS.HR_CONTACT_RELATIONSHIPS dependencies on PER_ASSIGNMENTS_F

Line 884: , per_assignments_f paf

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

Line 940: per_assignments_f asg,

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