APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 927: -- insert into pay_run_result_values(

923: --
924: -- Bug.4360429
925: -- No "null" result values need to be created when sparse matrix is enabled.
926: --
927: -- insert into pay_run_result_values(
928: -- INPUT_VALUE_ID,
929: -- RUN_RESULT_ID,
930: -- RESULT_VALUE)
931: -- select /*+ ORDERED

Line 955: -- from pay_run_result_values prrv

951: -- between piv.effective_start_date and piv.effective_end_date
952: -- and not exists(
953: -- /* If required, add hint in the following sql. */
954: -- select null
955: -- from pay_run_result_values prrv
956: -- where prrv.run_result_id = prr.run_result_id
957: -- and prrv.input_value_id = piv.input_value_id);
958: -- --
959: -- hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values (RR_SPARSE)');

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

955: -- from pay_run_result_values prrv
956: -- where prrv.run_result_id = prr.run_result_id
957: -- and prrv.input_value_id = piv.input_value_id);
958: -- --
959: -- hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values (RR_SPARSE)');
960: --
961: -- When not RR_SPARSE, create "null" result values for all appropriate run results.
962: --
963: else

Line 966: insert into pay_run_result_values(

962: --
963: else
964: /* Removed ORDERED and USE_NL hints to
965: fix Bug 5232799 */
966: insert into pay_run_result_values(
967: INPUT_VALUE_ID,
968: RUN_RESULT_ID,
969: RESULT_VALUE)
970: select /*+ INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)

Line 991: from pay_run_result_values prrv

987: between piv.effective_start_date and piv.effective_end_date
988: and not exists(
989: /* If required, add hint in the following sql. */
990: select null
991: from pay_run_result_values prrv
992: where prrv.run_result_id = prr.run_result_id
993: and prrv.input_value_id = piv.input_value_id);
994: --
995: hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values');

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

991: from pay_run_result_values prrv
992: where prrv.run_result_id = prr.run_result_id
993: and prrv.input_value_id = piv.input_value_id);
994: --
995: hr_utility.trace(sql%rowcount || ' rows inserted into pay_run_result_values');
996: end if;
997: end if;
998: --
999: hr_utility.set_location('Leaving: ' || c_proc, 100);