APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 1983: pay_run_results prr,

1979: CURSOR csr_cat_NI_Details
1980: IS
1981: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
1982: FROM pay_assignment_actions paa ,
1983: pay_run_results prr,
1984: pay_run_result_values prrv,
1985: pay_element_types_f petf ,
1986: pay_input_values_f pivf
1987: WHERE paa.source_action_id = p_last_asg_action_id

Line 2001: pay_run_results prr,

1997: CURSOR csr_cat_NI
1998: IS
1999: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
2000: FROM pay_assignment_actions paa ,
2001: pay_run_results prr,
2002: pay_run_result_values prrv,
2003: pay_element_types_f petf ,
2004: pay_input_values_f pivf
2005: WHERE paa.source_action_id = p_last_asg_action_id

Line 2764: pay_run_results prr,

2760: CURSOR csr_cat_NI_Details
2761: IS
2762: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
2763: FROM pay_assignment_actions paa ,
2764: pay_run_results prr,
2765: pay_run_result_values prrv,
2766: pay_element_types_f petf ,
2767: pay_input_values_f pivf
2768: WHERE paa.source_action_id = p_last_asg_action_id

Line 2782: pay_run_results prr,

2778: CURSOR csr_cat_NI
2779: IS
2780: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
2781: FROM pay_assignment_actions paa ,
2782: pay_run_results prr,
2783: pay_run_result_values prrv,
2784: pay_element_types_f petf ,
2785: pay_input_values_f pivf
2786: WHERE paa.source_action_id = p_last_asg_action_id

Line 3565: pay_run_results prr,

3561: CURSOR csr_cat_NI_Details
3562: IS
3563: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
3564: FROM pay_assignment_actions paa ,
3565: pay_run_results prr,
3566: pay_run_result_values prrv,
3567: pay_element_types_f petf ,
3568: pay_input_values_f pivf
3569: WHERE paa.source_action_id = p_last_asg_action_id

Line 3581: pay_run_results prr,

3577: CURSOR csr_cat_NI
3578: IS
3579: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
3580: FROM pay_assignment_actions paa ,
3581: pay_run_results prr,
3582: pay_run_result_values prrv,
3583: pay_element_types_f petf ,
3584: pay_input_values_f pivf
3585: WHERE paa.source_action_id = p_last_asg_action_id

Line 4243: pay_run_results prr,

4239: CURSOR csr_cat_NI_Details
4240: IS
4241: SELECT MAX(DECODE(name,'Category',result_value,NULL))
4242: FROM pay_assignment_actions paa ,
4243: pay_run_results prr,
4244: pay_run_result_values prrv,
4245: pay_element_types_f petf ,
4246: pay_input_values_f pivf
4247: WHERE paa.source_action_id = f_asg_act_id

Line 4258: pay_run_results prr,

4254: CURSOR csr_cat_NI
4255: IS
4256: SELECT MAX(DECODE(name,'Category',result_value,NULL))
4257: FROM pay_assignment_actions paa ,
4258: pay_run_results prr,
4259: pay_run_result_values prrv,
4260: pay_element_types_f petf ,
4261: pay_input_values_f pivf
4262: WHERE paa.source_action_id = f_asg_act_id

Line 4392: FROM pay_run_results prr

4388:
4389:
4390: CURSOR csr_max_run_result(p_assignment_action_id number,p_element_id number) IS
4391: SELECT max(prr.RUN_RESULT_ID)
4392: FROM pay_run_results prr
4393: WHERE prr.ASSIGNMENT_ACTION_ID = p_assignment_action_id
4394: AND prr.ELEMENT_TYPE_ID = p_element_id
4395: AND prr.status in ('P','PA');
4396:

Line 4590: FROM pay_run_results prr ,

4586: CURSOR csr_tax_paye_result(p_action_id NUMBER) -- kvinayku
4587: IS
4588: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
4589: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
4590: FROM pay_run_results prr ,
4591: pay_run_result_values prrv ,
4592: pay_input_values_f pivf
4593: WHERE prr.assignment_action_id = p_action_id
4594: AND prr.ELEMENT_TYPE_ID = g_paye_element_id

Line 4863: FROM pay_run_results prr ,

4859: CURSOR csr_tax_paye_result(p_action_id NUMBER) -- kvinayku
4860: IS
4861: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
4862: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
4863: FROM pay_run_results prr ,
4864: pay_run_result_values prrv ,
4865: pay_input_values_f pivf
4866: WHERE prr.assignment_action_id = p_action_id
4867: AND prr.ELEMENT_TYPE_ID = g_paye_element_id

Line 5091: FROM pay_run_results prr ,

5087: CURSOR csr_tax_paye_result(p_action_id NUMBER)
5088: IS
5089: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
5090: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
5091: FROM pay_run_results prr ,
5092: pay_run_result_values prrv ,
5093: pay_input_values_f pivf
5094: WHERE prr.assignment_action_id = p_action_id
5095: AND prr.ELEMENT_TYPE_ID = g_paye_element_id

Line 5773: FROM pay_run_results prr ,

5769: CURSOR csr_tax_paye_result(p_action_id NUMBER)
5770: IS
5771: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
5772: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
5773: FROM pay_run_results prr ,
5774: pay_run_result_values prrv ,
5775: pay_input_values_f pivf
5776: WHERE prr.assignment_action_id = p_action_id
5777: AND prr.ELEMENT_TYPE_ID = g_paye_element_id