DBA Data[Home] [Help]

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