204: p_element_entry_id in number
205: ) is
206: select 'Y'
207: from pay_assignment_actions asgt_act, 208: pay_run_results rr 209: where asgt_act.assignment_action_id = rr.assignment_action_id
210: and rr.source_id = p_element_entry_id
211: and rr.source_type in ('E','I')
212: and (asgt_act.assignment_action_id = p_assignment_action_id