eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_RTI_FPS dependencies on PAY_RUN_RESULT_VALUES

Line 1474: pay_run_result_values prrv,

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
1478: AND paa.assignment_action_id = prr.assignment_action_id

Line 1492: pay_run_result_values prrv,

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
1496: AND paa.assignment_action_id = prr.assignment_action_id

Line 2287: pay_run_result_values prrv,

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
2291: AND paa.assignment_action_id = prr.assignment_action_id

Line 2305: pay_run_result_values prrv,

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
2309: AND paa.assignment_action_id = prr.assignment_action_id

Line 3099: pay_run_result_values prrv,

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
3103: AND paa.assignment_action_id = prr.assignment_action_id

Line 3115: pay_run_result_values prrv,

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
3119: AND paa.assignment_action_id = prr.assignment_action_id

Line 3830: pay_run_result_values rrv

3826: CURSOR csr_run_result(p_run_result_id number,p_element_type_id number) IS
3827: SELECT max(decode(name,'Tax Code',result_value,NULL)) tax_code,
3828: MAX(DECODE(name,'Tax Basis',DECODE(result_value,'N','Y',NULL),NULL)) tax_basis
3829: FROM pay_input_values_f v,
3830: pay_run_result_values rrv
3831: WHERE rrv.run_result_id = p_run_result_id
3832: AND v.input_value_id = rrv.input_value_id
3833: AND v.element_type_id = p_element_type_id;
3834:

Line 4015: pay_run_result_values prrv ,

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
4019: AND prrv.run_result_id = prr.run_result_id

Line 4277: pay_run_result_values prrv ,

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
4281: AND prrv.run_result_id = prr.run_result_id

Line 4494: pay_run_result_values prrv ,

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
4498: AND prrv.run_result_id = prr.run_result_id

Line 5160: pay_run_result_values prrv ,

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
5164: AND prrv.run_result_id = prr.run_result_id