APPS.HR_JP_DATA_MIGRATION_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 50: -- p_mode is ELE_RR_COPY_TO then copy record pay_run_results and pay_run_result_values

46: --
47: g_qualify_hi_smr_ass_tbl t_ass_hi_smr_tbl;
48: --
49: --------------------------------------------------------------------------------
50: -- p_mode is ELE_RR_COPY_TO then copy record pay_run_results and pay_run_result_values
51: -- from existing element to new element
52:
53: PROCEDURE element_run_result_copy(
54: p_mode IN VARCHAR2,

Line 120: insert into pay_run_result_values (

116: -- get related input values
117: for rec_related_iv in csr_related_iv
118: loop
119: if rec_related_iv.iv_mode = 'IV_COPY_TO' then
120: insert into pay_run_result_values (
121: INPUT_VALUE_ID,
122: RUN_RESULT_ID,
123: RESULT_VALUE)
124: select /*+ ORDERED

Line 126: INDEX(PRRV_FROM PAY_RUN_RESULT_VALUES_PK)

122: RUN_RESULT_ID,
123: RESULT_VALUE)
124: select /*+ ORDERED
125: INDEX(FROM_ELE_PRR PAY_RUN_RESULTS_N1)
126: INDEX(PRRV_FROM PAY_RUN_RESULT_VALUES_PK)
127: INDEX(TO_ELE_PRR PAY_RUN_RESULTS_N50)
128: USE_NL(prrv_from to_ele_prr) */
129: rec_related_iv.iv_id_to,
130: to_ele_prr.run_result_id,

Line 133: pay_run_result_values prrv_from,

129: rec_related_iv.iv_id_to,
130: to_ele_prr.run_result_id,
131: prrv_from.result_value
132: from pay_run_results from_ele_prr,
133: pay_run_result_values prrv_from,
134: pay_run_results to_ele_prr
135: where from_ele_prr.element_type_id = l_element_type_id_from
136: and prrv_from.run_result_id = from_ele_prr.run_result_id
137: and prrv_from.input_value_id = rec_related_iv.iv_id_from

Line 142: from pay_run_result_values prrv_to

138: and to_ele_prr.assignment_action_id = from_ele_prr.assignment_action_id
139: and to_ele_prr.element_type_id = l_element_type_id_to
140: and not exists(
141: select NULL
142: from pay_run_result_values prrv_to
143: where prrv_to.run_result_id = to_ele_prr.run_result_id
144: and prrv_to.input_value_id = rec_related_iv.iv_id_to);
145:
146: end if;

Line 148: insert into pay_run_result_values (

144: and prrv_to.input_value_id = rec_related_iv.iv_id_to);
145:
146: end if;
147: if rec_related_iv.iv_mode = 'ADD_NEW_IV' then
148: insert into pay_run_result_values (
149: INPUT_VALUE_ID,
150: RUN_RESULT_ID,
151: RESULT_VALUE)
152: select /*+ INDEX(TO_ELE_PRR PAY_RUN_RESULTS_N1) */

Line 160: from pay_run_result_values prrv_to

156: from pay_run_results to_ele_prr
157: where to_ele_prr.element_type_id = l_element_type_id_to
158: and not exists(
159: select NULL
160: from pay_run_result_values prrv_to
161: where prrv_to.run_result_id = to_ele_prr.run_result_id
162: and prrv_to.input_value_id = rec_related_iv.iv_id_to);
163:
164: end if;

Line 199: select /*+ INDEX(PRRV PAY_RUN_RESULT_VALUES_PK) */

195: and piv.effective_start_date
196: between pet.effective_start_date and pet.effective_end_date
197: and prr.element_type_id = pet.element_type_id
198: and not exists(
199: select /*+ INDEX(PRRV PAY_RUN_RESULT_VALUES_PK) */
200: NULL
201: from pay_run_result_values prrv
202: where prrv.run_result_id=prr.run_result_id
203: and prrv.input_value_id=l_input_value_id_to);

Line 201: from pay_run_result_values prrv

197: and prr.element_type_id = pet.element_type_id
198: and not exists(
199: select /*+ INDEX(PRRV PAY_RUN_RESULT_VALUES_PK) */
200: NULL
201: from pay_run_result_values prrv
202: where prrv.run_result_id=prr.run_result_id
203: and prrv.input_value_id=l_input_value_id_to);
204:
205: CURSOR csr_element_link_id IS

Line 337: insert into pay_run_result_values (

333:
334: -- find run_result_id of parent element
335: for rec_run_result_id in csr_run_result_id
336: loop
337: insert into pay_run_result_values (
338: INPUT_VALUE_ID,
339: RUN_RESULT_ID,
340: RESULT_VALUE)
341: values(l_input_value_id_to,