APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 921: -- insert into pay_run_result_values(

917: --
918: -- Bug.4360429
919: -- No "null" result values need to be created when sparse matrix is enabled.
920: --
921: -- insert into pay_run_result_values(
922: -- INPUT_VALUE_ID,
923: -- RUN_RESULT_ID,
924: -- RESULT_VALUE)
925: -- select /*+ ORDERED

Line 949: -- from pay_run_result_values prrv

945: -- between piv.effective_start_date and piv.effective_end_date
946: -- and not exists(
947: -- /* If required, add hint in the following sql. */
948: -- select null
949: -- from pay_run_result_values prrv
950: -- where prrv.run_result_id = prr.run_result_id
951: -- and prrv.input_value_id = piv.input_value_id);
952: -- --
953: -- hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values (RR_SPARSE)');

Line 953: -- hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values (RR_SPARSE)');

949: -- from pay_run_result_values prrv
950: -- where prrv.run_result_id = prr.run_result_id
951: -- and prrv.input_value_id = piv.input_value_id);
952: -- --
953: -- hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values (RR_SPARSE)');
954: --
955: -- When not RR_SPARSE, create "null" result values for all appropriate run results.
956: --
957: else

Line 960: insert into pay_run_result_values(

956: --
957: else
958: /* Removed ORDERED and USE_NL hints to
959: fix Bug 5232799 */
960: insert into pay_run_result_values(
961: INPUT_VALUE_ID,
962: RUN_RESULT_ID,
963: RESULT_VALUE)
964: select /*+ INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)

Line 985: from pay_run_result_values prrv

981: between piv.effective_start_date and piv.effective_end_date
982: and not exists(
983: /* If required, add hint in the following sql. */
984: select null
985: from pay_run_result_values prrv
986: where prrv.run_result_id = prr.run_result_id
987: and prrv.input_value_id = piv.input_value_id);
988: --
989: hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values');

Line 989: hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values');

985: from pay_run_result_values prrv
986: where prrv.run_result_id = prr.run_result_id
987: and prrv.input_value_id = piv.input_value_id);
988: --
989: hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values');
990: end if;
991: end if;
992: --
993: hr_utility.set_location('Leaving: ' || c_proc, 100);