APPS.HR_CONTACT_RELATIONSHIPS dependencies on BEN_COVERED_DEPENDENTS_F
Line 984: ben_covered_dependents_f dep
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
988: and dep.effective_end_date