APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on FF_CONTEXTS

Line 1516: FROM ff_contexts ff

1512: SELECT ff.context_id context_id
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

Line 2416: FROM ff_contexts ff

2412: CURSOR csr_get_si_types(p_assig_action_id NUMBER
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;

Line 2424: FROM ff_contexts ff

2420: AND pac.assignment_Action_id = p_assig_action_id;
2421: --
2422: CURSOR csr_get_context_id(p_context_name VARCHAR2) IS
2423: SELECT ff.context_id context_id
2424: FROM ff_contexts ff
2425: WHERE ff.context_name = p_context_name;
2426: --
2427: --
2428: --

Line 3800: FROM ff_contexts ff

3796: CURSOR csr_get_context_id(p_run_assign_action_id VARCHAR2
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;

Line 4548: FROM ff_contexts ff

4544: CURSOR csr_get_context_id(p_run_assign_action_id VARCHAR2
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;