DBA Data[Home] [Help]

APPS.HR_CONTACT_RELATIONSHIPS dependencies on FND_SESSIONS

Line 888: , fnd_sessions f

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
891: and ppm.assignment_id = paf.assignment_id
892: and paf.person_id = pcr.person_id

Line 941: fnd_sessions fnd,

937: --
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

Line 983: fnd_sessions fnd,

979: PROCEDURE check_dependent (p_contact_relationship_id NUMBER) is
980: cursor cur_dep is
981: select 'Y'
982: from
983: fnd_sessions fnd,
984: ben_covered_dependents_f dep
985: where dep.contact_relationship_id = p_contact_relationship_id
986: and fnd.session_id = userenv('sessionid')
987: and (fnd.effective_date between dep.effective_start_date