APPS.PAY_GB_RTI_FPS dependencies on PAY_RUN_RESULTS

Line 1473: pay_run_results prr,

1469: CURSOR csr_cat_NI_Details
1470: IS
1471: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
1472: FROM pay_assignment_actions paa ,
1473: pay_run_results prr,
1474: pay_run_result_values prrv,
1475: pay_element_types_f petf ,
1476: pay_input_values_f pivf
1477: WHERE paa.source_action_id = p_last_asg_action_id

Line 1491: pay_run_results prr,

1487: CURSOR csr_cat_NI
1488: IS
1489: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
1490: FROM pay_assignment_actions paa ,
1491: pay_run_results prr,
1492: pay_run_result_values prrv,
1493: pay_element_types_f petf ,
1494: pay_input_values_f pivf
1495: WHERE paa.source_action_id = p_last_asg_action_id

Line 2286: pay_run_results prr,

2282: CURSOR csr_cat_NI_Details
2283: IS
2284: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
2285: FROM pay_assignment_actions paa ,
2286: pay_run_results prr,
2287: pay_run_result_values prrv,
2288: pay_element_types_f petf ,
2289: pay_input_values_f pivf
2290: WHERE paa.source_action_id = p_last_asg_action_id

Line 2304: pay_run_results prr,

2300: CURSOR csr_cat_NI
2301: IS
2302: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
2303: FROM pay_assignment_actions paa ,
2304: pay_run_results prr,
2305: pay_run_result_values prrv,
2306: pay_element_types_f petf ,
2307: pay_input_values_f pivf
2308: WHERE paa.source_action_id = p_last_asg_action_id

Line 3098: pay_run_results prr,

3094: CURSOR csr_cat_NI_Details
3095: IS
3096: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
3097: FROM pay_assignment_actions paa ,
3098: pay_run_results prr,
3099: pay_run_result_values prrv,
3100: pay_element_types_f petf ,
3101: pay_input_values_f pivf
3102: WHERE paa.source_action_id = p_last_asg_action_id

Line 3114: pay_run_results prr,

3110: CURSOR csr_cat_NI
3111: IS
3112: SELECT MAX(DECODE(name,'Periods',result_value,NULL))
3113: FROM pay_assignment_actions paa ,
3114: pay_run_results prr,
3115: pay_run_result_values prrv,
3116: pay_element_types_f petf ,
3117: pay_input_values_f pivf
3118: WHERE paa.source_action_id = p_last_asg_action_id

Line 3820: FROM pay_run_results prr

3816:
3817:
3818: CURSOR csr_max_run_result(p_assignment_action_id number,p_element_id number) IS
3819: SELECT max(prr.RUN_RESULT_ID)
3820: FROM pay_run_results prr
3821: WHERE prr.ASSIGNMENT_ACTION_ID = p_assignment_action_id
3822: AND prr.ELEMENT_TYPE_ID = p_element_id
3823: AND prr.status in ('P','PA');
3824:

Line 4014: FROM pay_run_results prr ,

4010: CURSOR csr_tax_paye_result(p_action_id NUMBER) -- kvinayku
4011: IS
4012: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
4013: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
4014: FROM pay_run_results prr ,
4015: pay_run_result_values prrv ,
4016: pay_input_values_f pivf
4017: WHERE prr.assignment_action_id = p_action_id
4018: AND prr.ELEMENT_TYPE_ID = g_paye_element_id

Line 4276: FROM pay_run_results prr ,

4272: CURSOR csr_tax_paye_result(p_action_id NUMBER) -- kvinayku
4273: IS
4274: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
4275: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
4276: FROM pay_run_results prr ,
4277: pay_run_result_values prrv ,
4278: pay_input_values_f pivf
4279: WHERE prr.assignment_action_id = p_action_id
4280: AND prr.ELEMENT_TYPE_ID = g_paye_element_id

Line 4493: FROM pay_run_results prr ,

4489: CURSOR csr_tax_paye_result(p_action_id NUMBER)
4490: IS
4491: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
4492: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
4493: FROM pay_run_results prr ,
4494: pay_run_result_values prrv ,
4495: pay_input_values_f pivf
4496: WHERE prr.assignment_action_id = p_action_id
4497: AND prr.ELEMENT_TYPE_ID = g_paye_element_id

Line 5159: FROM pay_run_results prr ,

5155: CURSOR csr_tax_paye_result(p_action_id NUMBER)
5156: IS
5157: SELECT MAX(DECODE(name,'Tax Code',prrv.result_value,NULL)),
5158: MAX(DECODE(name,'Tax Basis',DECODE(prrv.result_value,'N','Y',NULL),NULL))
5159: FROM pay_run_results prr ,
5160: pay_run_result_values prrv ,
5161: pay_input_values_f pivf
5162: WHERE prr.assignment_action_id = p_action_id
5163: AND prr.ELEMENT_TYPE_ID = g_paye_element_id