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