DBA Data[Home] [Help]

APPS.HR_CONTACT_RELATIONSHIPS dependencies on FND_SESSIONS

Line 886: , fnd_sessions f

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

Line 939: fnd_sessions fnd,

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

Line 981: fnd_sessions fnd,

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