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

85:
86: if l_element_type_id_from is not null then
87: -- copy run result
88:
89: insert into pay_run_results (
90: RUN_RESULT_ID,
91: ELEMENT_TYPE_ID,
92: ASSIGNMENT_ACTION_ID,
93: ENTRY_TYPE,

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

93: ENTRY_TYPE,
94: SOURCE_ID,
95: SOURCE_TYPE,
96: STATUS)
97: select /*+ INDEX(PRR_FROM PAY_RUN_RESULTS_N1) */
98: pay_run_results_s.nextval,
99: l_element_type_id_to,
100: prr_from.assignment_action_id,
101: prr_from.entry_type,

Line 98: pay_run_results_s.nextval,

94: SOURCE_ID,
95: SOURCE_TYPE,
96: STATUS)
97: select /*+ INDEX(PRR_FROM PAY_RUN_RESULTS_N1) */
98: pay_run_results_s.nextval,
99: l_element_type_id_to,
100: prr_from.assignment_action_id,
101: prr_from.entry_type,
102: prr_from.source_id,

Line 105: from pay_run_results prr_from

101: prr_from.entry_type,
102: prr_from.source_id,
103: prr_from.source_type,
104: prr_from.status
105: from pay_run_results prr_from
106: where prr_from.element_type_id = l_element_type_id_from
107: and not exists(
108: select /*+ INDEX(PRR_TO PAY_RUN_RESULTS_N50) */
109: NULL

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

104: prr_from.status
105: from pay_run_results prr_from
106: where prr_from.element_type_id = l_element_type_id_from
107: and not exists(
108: select /*+ INDEX(PRR_TO PAY_RUN_RESULTS_N50) */
109: NULL
110: from pay_run_results prr_to
111: where prr_to.assignment_action_id = prr_from.assignment_action_id
112: and prr_to.element_type_id = l_element_type_id_to);

Line 110: from pay_run_results prr_to

106: where prr_from.element_type_id = l_element_type_id_from
107: and not exists(
108: select /*+ INDEX(PRR_TO PAY_RUN_RESULTS_N50) */
109: NULL
110: from pay_run_results prr_to
111: where prr_to.assignment_action_id = prr_from.assignment_action_id
112: and prr_to.element_type_id = l_element_type_id_to);
113:
114: hr_utility.trace('Successefully created run_result');

Line 125: INDEX(FROM_ELE_PRR PAY_RUN_RESULTS_N1)

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

Line 127: INDEX(TO_ELE_PRR PAY_RUN_RESULTS_N50)

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

Line 132: from pay_run_results from_ele_prr,

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

Line 134: pay_run_results to_ele_prr

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

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

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) */
153: rec_related_iv.iv_id_to,
154: to_ele_prr.run_result_id,
155: NULL
156: from pay_run_results to_ele_prr

Line 156: from pay_run_results to_ele_prr

152: select /*+ INDEX(TO_ELE_PRR PAY_RUN_RESULTS_N1) */
153: rec_related_iv.iv_id_to,
154: to_ele_prr.run_result_id,
155: NULL
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

Line 188: INDEX(PRR PAY_RUN_RESULTS_N1) */

184: CURSOR csr_run_result_id IS
185: select /*+ ORDERED
186: INDEX(PIV PAY_INPUT_VALUES_F_PK)
187: INDEX(PET PAY_ELEMENT_TYPES_F_PK)
188: INDEX(PRR PAY_RUN_RESULTS_N1) */
189: prr.run_result_id run_result_id
190: from pay_input_values_f piv,
191: pay_element_types_f pet,
192: pay_run_results prr

Line 192: pay_run_results prr

188: INDEX(PRR PAY_RUN_RESULTS_N1) */
189: prr.run_result_id run_result_id
190: from pay_input_values_f piv,
191: pay_element_types_f pet,
192: pay_run_results prr
193: where piv.input_value_id = p_parameter_value
194: and pet.element_type_id = piv.element_type_id
195: and piv.effective_start_date
196: between pet.effective_start_date and pet.effective_end_date