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_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 1984: pay_run_result_values prrv,

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

Line 2002: pay_run_result_values prrv,

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

Line 2765: pay_run_result_values prrv,

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

Line 2783: pay_run_result_values prrv,

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

Line 3566: pay_run_result_values prrv,

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

Line 3582: pay_run_result_values prrv,

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

Line 4244: pay_run_result_values prrv,

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

Line 4259: pay_run_result_values prrv,

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

Line 4402: pay_run_result_values rrv

4398: CURSOR csr_run_result(p_run_result_id number,p_element_type_id number) IS
4399: SELECT max(decode(name,'Tax Code',result_value,NULL)) tax_code,
4400: MAX(DECODE(name,'Tax Basis',DECODE(result_value,'N','Y',NULL),NULL)) tax_basis
4401: FROM pay_input_values_f v,
4402: pay_run_result_values rrv
4403: WHERE rrv.run_result_id = p_run_result_id
4404: AND v.input_value_id = rrv.input_value_id
4405: AND v.element_type_id = p_element_type_id;
4406:

Line 4591: pay_run_result_values prrv ,

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

Line 4864: pay_run_result_values prrv ,

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

Line 5092: pay_run_result_values prrv ,

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

Line 5774: pay_run_result_values prrv ,

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