DBA Data[Home] [Help]

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