APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PAY_ACTION_CONTEXTS

Line 1517: ,pay_action_contexts pact

1513: ,pact.context_value context_value
1514: , decode(context_value,'ZVW',0,'ZW',1,
1515: 'WEWE',2,'WEWA',3,'WAOD',4,'WAOB',5,6) seq
1516: FROM ff_contexts ff
1517: ,pay_action_contexts pact
1518: WHERE ff.context_name = p_context_name
1519: AND pact.context_id = ff.context_id
1520: AND pact.assignment_action_id=p_assignment_action_id
1521: ORDER BY decode(context_value,'ZVW',0,'ZW',1,

Line 1665: l_context_value pay_action_contexts.context_value%TYPE;

1661: l_org_struct_ver_id NUMBER;
1662: l_legal_min_payment VARCHAR2(240);
1663: l_si_def_bal_id NUMBER;
1664: l_context_id NUMBER;
1665: l_context_value pay_action_contexts.context_value%TYPE;
1666: l_seq VARCHAR2(60);
1667: l_si_days NUMBER;
1668: l_WAO VARCHAR2(30);
1669: l_WW VARCHAR2(30);

Line 2417: ,pay_action_contexts pac

2413: ,p_context_name VARCHAR2) IS
2414: SELECT pac.context_id context_id
2415: ,pac.context_value value
2416: FROM ff_contexts ff
2417: ,pay_action_contexts pac
2418: WHERE ff.context_name = p_context_name
2419: AND pac.context_id = ff.context_id
2420: AND pac.assignment_Action_id = p_assig_action_id;
2421: --

Line 3801: ,pay_action_contexts pac

3797: ,p_context_name VARCHAR2) IS
3798: SELECT pac.context_id context_id
3799: ,pac.context_value value
3800: FROM ff_contexts ff
3801: ,pay_action_contexts pac
3802: WHERE ff.context_name = p_context_name
3803: AND pac.context_id = ff.context_id
3804: AND pac.assignment_Action_id = p_run_assign_action_id;
3805: --

Line 3930: l_si_type pay_action_contexts.context_value%TYPE;

3926: l_dummy NUMBER;
3927: l_archive_flag VARCHAR2(10);
3928: l_payable NUMBER;
3929: l_sum_payable NUMBER;
3930: l_si_type pay_action_contexts.context_value%TYPE;
3931: l_si_type_name pay_run_result_values.result_value%TYPE;
3932: l_def_bal_id NUMBER;
3933:
3934: l_standard_rate_run NUMBER;

Line 4549: ,pay_action_contexts pac

4545: ,p_context_name VARCHAR2) IS
4546: SELECT pac.context_id context_id
4547: ,pac.context_value value
4548: FROM ff_contexts ff
4549: ,pay_action_contexts pac
4550: WHERE ff.context_name = p_context_name
4551: AND pac.context_id = ff.context_id
4552: AND pac.assignment_Action_id = p_run_assign_action_id;
4553: