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 441: INDEX(prr PAY_RUN_RESULTS_N50)

437: ) is
438: select /*+ ORDERED use_nl(PAA,PPA,PPF)
439: INDEX (paa PAY_ASSIGNMENT_ACTIONS_N51)
440: INDEX(ppa PAY_PAYROLL_ACTIONS_PK)
441: INDEX(prr PAY_RUN_RESULTS_N50)
442: INDEX(pcc PAY_ELEMENT_CLASSIFICATION_UK2) */
443: distinct
444: pec.classification_name,
445: pet.processing_priority,

Line 461: pay_run_results prr,

457: pet.element_information10,
458: pet.element_information12
459: from pay_assignment_actions paa,
460: pay_payroll_actions ppa,
461: pay_run_results prr,
462: pay_element_types_f pet,
463: pay_element_classifications pec,
464: pay_element_types_f_tl petl
465: where prr.assignment_action_id = paa.assignment_action_id

Line 1636: from pay_run_results prr,

1632: sum(decode(piv.name, 'Pay Value', prrv.result_value)),
1633: sum(decode(piv.name, 'Hours', prrv.result_value)),
1634: nvl(sum(decode(piv.name, 'Multiple', prrv.result_value)),1),
1635: sum(decode(piv.name, 'Rate', prrv.result_value))
1636: from pay_run_results prr,
1637: pay_run_result_values prrv,
1638: pay_input_values_f piv,
1639: pay_entry_process_details pepd
1640: where piv.input_value_id = prrv.input_value_id

Line 2073: FROM pay_run_results prr

2069: /* Added for Bug#11897283 */
2070: AND EXISTS
2071: (
2072: SELECT 1
2073: FROM pay_run_results prr
2074: WHERE prr.assignment_action_id = paa_run.assignment_action_id
2075: AND prr.element_type_id = cp_element_type_id);
2076:
2077:

Line 2265: pay_run_results prr,

2261: pet.element_information12,
2262: pet.processing_priority
2263: from pay_assignment_actions paa,
2264: pay_payroll_actions ppa,
2265: pay_run_results prr,
2266: pay_element_types_f pet,
2267: pay_element_classifications pec,
2268: pay_element_types_f_tl petl
2269: where paa.assignment_id = cp_assignment_id

Line 2316: pay_run_results prr,

2312: from pay_action_interlocks pai,
2313: pay_assignment_actions paa,
2314: pay_payroll_actions ppa,
2315: pay_all_payrolls_f ppf,
2316: pay_run_results prr,
2317: pay_element_types_f pet,
2318: pay_element_classifications pec,
2319: pay_element_types_f_tl petl
2320: where paa.assignment_id = cp_assignment_id

Line 3431: PAY_RUN_RESULTS PRR,

3427: pet.element_information12
3428: from PAY_ASSIGNMENT_ACTIONS PAA,
3429: PAY_PAYROLL_ACTIONS PPA,
3430: PAY_PAYROLLS_F PPF,
3431: PAY_RUN_RESULTS PRR,
3432: PAY_ELEMENT_TYPES_F PET ,
3433: PAY_ELEMENT_CLASSIFICATIONS PEC,
3434: PAY_ELEMENT_TYPES_F_TL PETL
3435: /*changing the order for bug 5549032

Line 3436: pay_run_results prr,

3432: PAY_ELEMENT_TYPES_F PET ,
3433: PAY_ELEMENT_CLASSIFICATIONS PEC,
3434: PAY_ELEMENT_TYPES_F_TL PETL
3435: /*changing the order for bug 5549032
3436: pay_run_results prr,
3437: pay_element_types_f pet ,
3438: pay_element_classifications pec,
3439: pay_assignment_actions paa,
3440: pay_payroll_actions ppa,

Line 4818: (SELECT 1 FROM pay_run_results prr

4814:
4815: AND NVL(ppa.date_earned, ppa.effective_date) BETWEEN peef.effective_start_date AND peef.effective_end_date
4816: /*Start -- 14319807*/
4817: AND EXISTS
4818: (SELECT 1 FROM pay_run_results prr
4819: WHERE
4820: prr.assignment_action_id = paa.assignment_action_id
4821: AND prr.element_entry_id = peef.element_entry_id
4822: )

Line 4833: FROM pay_run_results prr,

4829: ,cp_element_entry_id IN NUMBER
4830: ,cp_pymt_eff_date in date -- Bug# 16318258
4831: ) IS
4832: SELECT to_number(prrv.result_value), pivf.NAME
4833: FROM pay_run_results prr,
4834: pay_run_result_values prrv,
4835: pay_input_values_f pivf
4836: WHERE prr.assignment_action_id = cp_run_assignment_action_id
4837: AND prr.element_entry_id = cp_element_entry_id

Line 4851: from pay_run_results PRR,

4847: CURSOR get_run_results_hours (cp_element_entry_id IN NUMBER
4848: ,cp_pymt_eff_date in date -- Bug# 16318258
4849: ) is
4850: select PRRV.RESULT_VALUE as original_input_value
4851: from pay_run_results PRR,
4852: pay_run_result_values PRRV,
4853: pay_input_values_f PIVF,
4854: pay_entry_process_details PEPD
4855: WHERE PEPD.ELEMENT_ENTRY_ID = cp_element_entry_id

Line 4875: FROM pay_run_results prr,

4871: ,cp_element_entry_id IN NUMBER
4872: ,cp_pymt_eff_date in date -- Bug# 16318258
4873: ) IS
4874: SELECT to_number(prrv.result_value)
4875: FROM pay_run_results prr,
4876: pay_run_result_values prrv,
4877: pay_input_values_f pivf
4878: WHERE prr.assignment_action_id = cp_run_assignment_action_id
4879: AND prr.element_entry_id = cp_element_entry_id

Line 5427: FROM pay_run_results prr,

5423: ,cp_pymt_eff_date in date -- Bug# 16318258
5424: ) IS
5425: --bug 7373188
5426: SELECT to_number(prrv.result_value), pivf.NAME
5427: FROM pay_run_results prr,
5428: pay_run_result_values prrv,
5429: pay_input_values_f pivf
5430: WHERE prr.element_entry_id = cp_element_entry_id
5431: --bug 7373188

Line 5448: FROM pay_run_results prr,

5444: ,cp_pymt_eff_date in date -- Bug# 16318258
5445: ) IS
5446: --bug 7373188
5447: SELECT to_number(prrv.result_value)
5448: FROM pay_run_results prr,
5449: pay_run_result_values prrv,
5450: pay_input_values_f pivf
5451: WHERE prr.element_entry_id = cp_element_entry_id
5452: --bug 7373188

Line 6028: FROM pay_run_results prr,

6024: ,cp_pymt_eff_date in date -- Bug# 16318258
6025: ) IS
6026: --bug 7373188
6027: SELECT to_number(prrv.result_value), pivf.NAME
6028: FROM pay_run_results prr,
6029: pay_run_result_values prrv,
6030: pay_input_values_f pivf
6031: WHERE prr.element_entry_id = cp_element_entry_id
6032: --bug 7373188

Line 6049: FROM pay_run_results prr,

6045: ,cp_pymt_eff_date in date -- Bug# 16318258
6046: ) IS
6047: --bug 7373188
6048: SELECT to_number(prrv.result_value)
6049: FROM pay_run_results prr,
6050: pay_run_result_values prrv,
6051: pay_input_values_f pivf
6052: WHERE prr.element_entry_id = cp_element_entry_id
6053: --bug 7373188