165: FUNCTION missing_assignment_action( p_assignment_id IN NUMBER,
166: p_time_period_id IN NUMBER )
167: RETURN VARCHAR2 IS
168:
169: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
170:
171: CURSOR c_get_assignment_action_id IS
172: select assignment_action_id -- Bug 3372714: Single query is broken into two queries to reduce the cost.
173: from pay_assignment_actions act
169: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
170:
171: CURSOR c_get_assignment_action_id IS
172: select assignment_action_id -- Bug 3372714: Single query is broken into two queries to reduce the cost.
173: from pay_assignment_actions act
174: where act.assignment_id = p_assignment_id
175: and act.action_status in ('C', 'S')
176: and exists
177: (select 'x'