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 934: -- INDEX(PRR PAY_RUN_RESULTS_N50)

930: -- RESULT_VALUE)
931: -- select /*+ ORDERED
932: -- USE_NL(PRR PPA PIV)
933: -- INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N1)
934: -- INDEX(PRR PAY_RUN_RESULTS_N50)
935: -- INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
936: -- INDEX(PIV PAY_INPUT_VALUES_F_N50) */
937: -- piv.input_value_id,
938: -- prr.run_result_id,

Line 941: -- pay_run_results prr,

937: -- piv.input_value_id,
938: -- prr.run_result_id,
939: -- null
940: -- from pay_assignment_actions paa,
941: -- pay_run_results prr,
942: -- pay_payroll_actions ppa,
943: -- pay_input_values_f piv
944: -- where paa.assignment_id = p_assignment_id
945: -- and prr.assignment_action_id = paa.assignment_action_id

Line 971: INDEX(PRR PAY_RUN_RESULTS_N50)

967: INPUT_VALUE_ID,
968: RUN_RESULT_ID,
969: RESULT_VALUE)
970: select /*+ INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
971: INDEX(PRR PAY_RUN_RESULTS_N50)
972: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
973: INDEX(PIV PAY_INPUT_VALUES_F_N50) */
974: piv.input_value_id,
975: prr.run_result_id,

Line 978: pay_run_results prr,

974: piv.input_value_id,
975: prr.run_result_id,
976: null
977: from pay_assignment_actions paa,
978: pay_run_results prr,
979: pay_payroll_actions ppa,
980: pay_input_values_f piv
981: where paa.assignment_id = p_assignment_id
982: and prr.assignment_action_id = paa.assignment_action_id