DBA Data[Home] [Help]

APPS.PAYRPENP dependencies on PAY_ASSIGNMENT_ACTIONS

Line 169: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

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

Line 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'