APPS.HR_JP_DATA_MIGRATION_PKG dependencies on PAY_RUN_RESULT_VALUES

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

61: --
62: g_qualify_dep_ass_tbl t_ass_dep_tbl;
63: --
64: --------------------------------------------------------------------------------
65: -- p_mode is ELE_RR_COPY_TO then copy record pay_run_results and pay_run_result_values
66: -- from existing element to new element
67:
68: PROCEDURE element_run_result_copy(
69: p_mode IN VARCHAR2,

Line 135: insert into pay_run_result_values (

131: -- get related input values
132: for rec_related_iv in csr_related_iv
133: loop
134: if rec_related_iv.iv_mode = 'IV_COPY_TO' then
135: insert into pay_run_result_values (
136: INPUT_VALUE_ID,
137: RUN_RESULT_ID,
138: RESULT_VALUE)
139: select /*+ ORDERED

Line 141: INDEX(PRRV_FROM PAY_RUN_RESULT_VALUES_PK)

137: RUN_RESULT_ID,
138: RESULT_VALUE)
139: select /*+ ORDERED
140: INDEX(FROM_ELE_PRR PAY_RUN_RESULTS_N1)
141: INDEX(PRRV_FROM PAY_RUN_RESULT_VALUES_PK)
142: INDEX(TO_ELE_PRR PAY_RUN_RESULTS_N50)
143: USE_NL(prrv_from to_ele_prr) */
144: rec_related_iv.iv_id_to,
145: to_ele_prr.run_result_id,

Line 148: pay_run_result_values prrv_from,

144: rec_related_iv.iv_id_to,
145: to_ele_prr.run_result_id,
146: prrv_from.result_value
147: from pay_run_results from_ele_prr,
148: pay_run_result_values prrv_from,
149: pay_run_results to_ele_prr
150: where from_ele_prr.element_type_id = l_element_type_id_from
151: and prrv_from.run_result_id = from_ele_prr.run_result_id
152: and prrv_from.input_value_id = rec_related_iv.iv_id_from

Line 157: from pay_run_result_values prrv_to

153: and to_ele_prr.assignment_action_id = from_ele_prr.assignment_action_id
154: and to_ele_prr.element_type_id = l_element_type_id_to
155: and not exists(
156: select NULL
157: from pay_run_result_values prrv_to
158: where prrv_to.run_result_id = to_ele_prr.run_result_id
159: and prrv_to.input_value_id = rec_related_iv.iv_id_to);
160:
161: end if;

Line 163: insert into pay_run_result_values (

159: and prrv_to.input_value_id = rec_related_iv.iv_id_to);
160:
161: end if;
162: if rec_related_iv.iv_mode = 'ADD_NEW_IV' then
163: insert into pay_run_result_values (
164: INPUT_VALUE_ID,
165: RUN_RESULT_ID,
166: RESULT_VALUE)
167: select /*+ INDEX(TO_ELE_PRR PAY_RUN_RESULTS_N1) */

Line 175: from pay_run_result_values prrv_to

171: from pay_run_results to_ele_prr
172: where to_ele_prr.element_type_id = l_element_type_id_to
173: and not exists(
174: select NULL
175: from pay_run_result_values prrv_to
176: where prrv_to.run_result_id = to_ele_prr.run_result_id
177: and prrv_to.input_value_id = rec_related_iv.iv_id_to);
178:
179: end if;

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

210: and piv.effective_start_date
211: between pet.effective_start_date and pet.effective_end_date
212: and prr.element_type_id = pet.element_type_id
213: and not exists(
214: select /*+ INDEX(PRRV PAY_RUN_RESULT_VALUES_PK) */
215: NULL
216: from pay_run_result_values prrv
217: where prrv.run_result_id=prr.run_result_id
218: and prrv.input_value_id=l_input_value_id_to);

Line 216: from pay_run_result_values prrv

212: and prr.element_type_id = pet.element_type_id
213: and not exists(
214: select /*+ INDEX(PRRV PAY_RUN_RESULT_VALUES_PK) */
215: NULL
216: from pay_run_result_values prrv
217: where prrv.run_result_id=prr.run_result_id
218: and prrv.input_value_id=l_input_value_id_to);
219:
220: CURSOR csr_element_link_id IS

Line 352: insert into pay_run_result_values (

348:
349: -- find run_result_id of parent element
350: for rec_run_result_id in csr_run_result_id
351: loop
352: insert into pay_run_result_values (
353: INPUT_VALUE_ID,
354: RUN_RESULT_ID,
355: RESULT_VALUE)
356: values(l_input_value_id_to,