APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PAY_RUN_RESULTS

Line 610: INDEX(PRR PAY_RUN_RESULTS_N50) */

606: NO_MERGE(BG)
607: USE_NL(PPA PAA PRR)
608: INDEX(PPA PAY_PAYROLL_ACTIONS_FK1)
609: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N50)
610: INDEX(PRR PAY_RUN_RESULTS_N50) */
611: null
612: from per_business_groups_perf bg,
613: pay_payroll_actions ppa,
614: pay_assignment_actions paa,

Line 615: pay_run_results prr

611: null
612: from per_business_groups_perf bg,
613: pay_payroll_actions ppa,
614: pay_assignment_actions paa,
615: pay_run_results prr
616: where bg.legislation_code = p_legislation_code
617: and ppa.business_group_id = bg.business_group_id
618: and paa.payroll_action_id = ppa.payroll_action_id
619: and prr.assignment_action_id = paa.assignment_action_id);

Line 660: from pay_run_results prr

656: where pel.element_type_id = p_element_type_id
657: and pee.element_link_id = pel.element_link_id)
658: or exists(
659: select null
660: from pay_run_results prr
661: where prr.element_type_id = p_element_type_id);
662: begin
663: hr_utility.set_location('Entering: ' || c_proc, 10);
664: --

Line 697: pay_run_results prr

693: where pee.assignment_id = p_assignment_id)
694: or exists(
695: select null
696: from pay_assignment_actions paa,
697: pay_run_results prr
698: where paa.assignment_id = p_assignment_id
699: and prr.assignment_action_id = paa.assignment_action_id);
700: begin
701: hr_utility.set_location('Entering: ' || c_proc, 10);

Line 745: INDEX(PRR PAY_RUN_RESULTS_N50) */

741: or exists(
742: -- Removed Hint on PAA as per Bug# 4674234.
743: select /*+ ORDERED
744: USE_NL(PRR)
745: INDEX(PRR PAY_RUN_RESULTS_N50) */
746: null
747: from pay_assignment_actions paa,
748: pay_run_results prr
749: where paa.assignment_id = p_assignment_id

Line 748: pay_run_results prr

744: USE_NL(PRR)
745: INDEX(PRR PAY_RUN_RESULTS_N50) */
746: null
747: from pay_assignment_actions paa,
748: pay_run_results prr
749: where paa.assignment_id = p_assignment_id
750: and prr.assignment_action_id = paa.assignment_action_id
751: and prr.element_type_id = p_element_type_id);
752: begin

Line 928: -- INDEX(PRR PAY_RUN_RESULTS_N50)

924: -- RESULT_VALUE)
925: -- select /*+ ORDERED
926: -- USE_NL(PRR PPA PIV)
927: -- INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N1)
928: -- INDEX(PRR PAY_RUN_RESULTS_N50)
929: -- INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
930: -- INDEX(PIV PAY_INPUT_VALUES_F_N50) */
931: -- piv.input_value_id,
932: -- prr.run_result_id,

Line 935: -- pay_run_results prr,

931: -- piv.input_value_id,
932: -- prr.run_result_id,
933: -- null
934: -- from pay_assignment_actions paa,
935: -- pay_run_results prr,
936: -- pay_payroll_actions ppa,
937: -- pay_input_values_f piv
938: -- where paa.assignment_id = p_assignment_id
939: -- and prr.assignment_action_id = paa.assignment_action_id

Line 965: INDEX(PRR PAY_RUN_RESULTS_N50)

961: INPUT_VALUE_ID,
962: RUN_RESULT_ID,
963: RESULT_VALUE)
964: select /*+ INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
965: INDEX(PRR PAY_RUN_RESULTS_N50)
966: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
967: INDEX(PIV PAY_INPUT_VALUES_F_N50) */
968: piv.input_value_id,
969: prr.run_result_id,

Line 972: pay_run_results prr,

968: piv.input_value_id,
969: prr.run_result_id,
970: null
971: from pay_assignment_actions paa,
972: pay_run_results prr,
973: pay_payroll_actions ppa,
974: pay_input_values_f piv
975: where paa.assignment_id = p_assignment_id
976: and prr.assignment_action_id = paa.assignment_action_id