APPS.PAY_NL_ANNUAL_SI_FILE dependencies on PAY_ACTION_CONTEXTS

Line 282: ,pay_action_contexts pact

278: ,pact.context_value context_value
279: , decode(context_value,'ZFW',0,'ZW',1,
280: 'WEWE',2,'WEWA',3,'WAOD',4,'WAOB',5,6) seq
281: FROM ff_contexts ff
282: ,pay_action_contexts pact
283: WHERE ff.context_name = p_context_name
284: AND pact.context_id = ff.context_id
285: AND pact.assignment_action_id=p_assignment_action_id
286: ORDER BY decode(context_value,'ZFW',0,'ZW',1,

Line 290: l_context_value pay_action_contexts.context_value%TYPE;

286: ORDER BY decode(context_value,'ZFW',0,'ZW',1,
287: 'WEWE',2,'WEWA',3,'WAOD',4,'WAOB',5,6);
288:
289: l_context_id NUMBER;
290: l_context_value pay_action_contexts.context_value%TYPE;
291: l_seq VARCHAR2(60);
292: l_sum_of_balances number;
293: l_balance_value number;
294: l_defined_balance_id number;