eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_JP_DATA_MIGRATION_PKG dependencies on PAY_RUN_RESULTS

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 104: insert into pay_run_results (

100:
101: if l_element_type_id_from is not null then
102: -- copy run result
103:
104: insert into pay_run_results (
105: RUN_RESULT_ID,
106: ELEMENT_TYPE_ID,
107: ASSIGNMENT_ACTION_ID,
108: ENTRY_TYPE,

Line 112: select /+ INDEX(PRR_FROM PAY_RUN_RESULTS_N1) /

108: ENTRY_TYPE,
109: SOURCE_ID,
110: SOURCE_TYPE,
111: STATUS)
112: select /*+ INDEX(PRR_FROM PAY_RUN_RESULTS_N1) */
113: pay_run_results_s.nextval,
114: l_element_type_id_to,
115: prr_from.assignment_action_id,
116: prr_from.entry_type,

Line 113: pay_run_results_s.nextval,

109: SOURCE_ID,
110: SOURCE_TYPE,
111: STATUS)
112: select /*+ INDEX(PRR_FROM PAY_RUN_RESULTS_N1) */
113: pay_run_results_s.nextval,
114: l_element_type_id_to,
115: prr_from.assignment_action_id,
116: prr_from.entry_type,
117: prr_from.source_id,

Line 120: from pay_run_results prr_from

116: prr_from.entry_type,
117: prr_from.source_id,
118: prr_from.source_type,
119: prr_from.status
120: from pay_run_results prr_from
121: where prr_from.element_type_id = l_element_type_id_from
122: and not exists(
123: select /*+ INDEX(PRR_TO PAY_RUN_RESULTS_N50) */
124: NULL

Line 123: select /+ INDEX(PRR_TO PAY_RUN_RESULTS_N50) /

119: prr_from.status
120: from pay_run_results prr_from
121: where prr_from.element_type_id = l_element_type_id_from
122: and not exists(
123: select /*+ INDEX(PRR_TO PAY_RUN_RESULTS_N50) */
124: NULL
125: from pay_run_results prr_to
126: where prr_to.assignment_action_id = prr_from.assignment_action_id
127: and prr_to.element_type_id = l_element_type_id_to);

Line 125: from pay_run_results prr_to

121: where prr_from.element_type_id = l_element_type_id_from
122: and not exists(
123: select /*+ INDEX(PRR_TO PAY_RUN_RESULTS_N50) */
124: NULL
125: from pay_run_results prr_to
126: where prr_to.assignment_action_id = prr_from.assignment_action_id
127: and prr_to.element_type_id = l_element_type_id_to);
128:
129: hr_utility.trace('Successefully created run_result');

Line 140: INDEX(FROM_ELE_PRR PAY_RUN_RESULTS_N1)

136: INPUT_VALUE_ID,
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,

Line 142: INDEX(TO_ELE_PRR PAY_RUN_RESULTS_N50)

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,
146: prrv_from.result_value

Line 147: from pay_run_results from_ele_prr,

143: USE_NL(prrv_from to_ele_prr) */
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

Line 149: pay_run_results to_ele_prr

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
153: and to_ele_prr.assignment_action_id = from_ele_prr.assignment_action_id

Line 167: select /+ INDEX(TO_ELE_PRR PAY_RUN_RESULTS_N1) /

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) */
168: rec_related_iv.iv_id_to,
169: to_ele_prr.run_result_id,
170: NULL
171: from pay_run_results to_ele_prr

Line 171: from pay_run_results to_ele_prr

167: select /*+ INDEX(TO_ELE_PRR PAY_RUN_RESULTS_N1) */
168: rec_related_iv.iv_id_to,
169: to_ele_prr.run_result_id,
170: NULL
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

Line 203: INDEX(PRR PAY_RUN_RESULTS_N1) */

199: CURSOR csr_run_result_id IS
200: select /*+ ORDERED
201: INDEX(PIV PAY_INPUT_VALUES_F_PK)
202: INDEX(PET PAY_ELEMENT_TYPES_F_PK)
203: INDEX(PRR PAY_RUN_RESULTS_N1) */
204: prr.run_result_id run_result_id
205: from pay_input_values_f piv,
206: pay_element_types_f pet,
207: pay_run_results prr

Line 207: pay_run_results prr

203: INDEX(PRR PAY_RUN_RESULTS_N1) */
204: prr.run_result_id run_result_id
205: from pay_input_values_f piv,
206: pay_element_types_f pet,
207: pay_run_results prr
208: where piv.input_value_id = p_parameter_value
209: and pet.element_type_id = piv.element_type_id
210: and piv.effective_start_date
211: between pet.effective_start_date and pet.effective_end_date