[Home] [Help]
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