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_AC_ACTION_ARCH dependencies on PAY_RUN_RESULTS

Line 352: INDEX(prr PAY_RUN_RESULTS_N50)

348: ) is
349: select /*+ ORDERED use_nl(PAA,PPA,PPF)
350: INDEX (paa PAY_ASSIGNMENT_ACTIONS_N51)
351: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
352: INDEX(prr PAY_RUN_RESULTS_N50)
353: INDEX(pcc PAY_ELEMENT_CLASSIFICATION_UK2) */
354: distinct
355: pec.classification_name,
356: pet.processing_priority,

Line 372: pay_run_results prr,

368: pet.element_information10,
369: pet.element_information12
370: from pay_assignment_actions paa,
371: pay_payroll_actions ppa,
372: pay_run_results prr,
373: pay_element_types_f pet,
374: pay_element_classifications pec,
375: pay_element_types_f_tl petl
376: where prr.assignment_action_id = paa.assignment_action_id

Line 1327: from pay_run_results prr,

1323: sum(decode(piv.name, 'Pay Value', prrv.result_value)),
1324: sum(decode(piv.name, 'Hours', prrv.result_value)),
1325: nvl(sum(decode(piv.name, 'Multiple', prrv.result_value)),1),
1326: sum(decode(piv.name, 'Rate', prrv.result_value))
1327: from pay_run_results prr,
1328: pay_run_result_values prrv,
1329: pay_input_values_f piv,
1330: pay_entry_process_details pepd
1331: where piv.input_value_id = prrv.input_value_id

Line 1908: pay_run_results prr,

1904: pet.element_information12,
1905: pet.processing_priority
1906: from pay_assignment_actions paa,
1907: pay_payroll_actions ppa,
1908: pay_run_results prr,
1909: pay_element_types_f pet,
1910: pay_element_classifications pec,
1911: pay_element_types_f_tl petl
1912: where paa.assignment_id = cp_assignment_id

Line 1959: pay_run_results prr,

1955: from pay_action_interlocks pai,
1956: pay_assignment_actions paa,
1957: pay_payroll_actions ppa,
1958: pay_all_payrolls_f ppf,
1959: pay_run_results prr,
1960: pay_element_types_f pet,
1961: pay_element_classifications pec,
1962: pay_element_types_f_tl petl
1963: where paa.assignment_id = cp_assignment_id

Line 2936: PAY_RUN_RESULTS PRR,

2932: pet.element_information12
2933: from PAY_ASSIGNMENT_ACTIONS PAA,
2934: PAY_PAYROLL_ACTIONS PPA,
2935: PAY_PAYROLLS_F PPF,
2936: PAY_RUN_RESULTS PRR,
2937: PAY_ELEMENT_TYPES_F PET ,
2938: PAY_ELEMENT_CLASSIFICATIONS PEC,
2939: PAY_ELEMENT_TYPES_F_TL PETL
2940: /*changing the order for bug 5549032

Line 2941: pay_run_results prr,

2937: PAY_ELEMENT_TYPES_F PET ,
2938: PAY_ELEMENT_CLASSIFICATIONS PEC,
2939: PAY_ELEMENT_TYPES_F_TL PETL
2940: /*changing the order for bug 5549032
2941: pay_run_results prr,
2942: pay_element_types_f pet ,
2943: pay_element_classifications pec,
2944: pay_assignment_actions paa,
2945: pay_payroll_actions ppa,

Line 4320: FROM pay_run_results prr,

4316:
4317:
4318: CURSOR get_run_results ( cp_element_entry_id in number ) IS
4319: SELECT to_number(prrv.result_value), pivf.NAME
4320: FROM pay_run_results prr,
4321: pay_run_result_values prrv,
4322: pay_input_values_f pivf
4323: WHERE prr.element_entry_id = cp_element_entry_id
4324: AND prrv.run_result_id = prr.run_result_id

Line 4333: FROM pay_run_results prr,

4329: -- Introducing This Cussor in case Hours and Pay Values Both zero
4330: --
4331: CURSOR get_run_results_rate( cp_element_entry_id in number ) IS
4332: SELECT to_number(prrv.result_value)
4333: FROM pay_run_results prr,
4334: pay_run_result_values prrv,
4335: pay_input_values_f pivf
4336: WHERE prr.element_entry_id = cp_element_entry_id
4337: AND prrv.run_result_id = prr.run_result_id

Line 4814: FROM pay_run_results prr,

4810: --CURSOR get_run_results ( cp_element_entry_id in number ) IS
4811: CURSOR get_run_results ( cp_run_action_id in number ,cp_element_entry_id in number ) IS
4812: --bug 7373188
4813: SELECT to_number(prrv.result_value), pivf.NAME
4814: FROM pay_run_results prr,
4815: pay_run_result_values prrv,
4816: pay_input_values_f pivf
4817: WHERE prr.element_entry_id = cp_element_entry_id
4818: --bug 7373188

Line 4832: FROM pay_run_results prr,

4828: --CURSOR get_run_results_rate( cp_element_entry_id in number ) IS
4829: CURSOR get_run_results_rate( cp_run_action_id in number , cp_element_entry_id in number ) IS
4830: --bug 7373188
4831: SELECT to_number(prrv.result_value)
4832: FROM pay_run_results prr,
4833: pay_run_result_values prrv,
4834: pay_input_values_f pivf
4835: WHERE prr.element_entry_id = cp_element_entry_id
4836: --bug 7373188