APPS.HR_JP_DATA_MIGRATION_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 12: c_com_hi_smr_elm pay_element_types_f.element_name%type := 'COM_HI_SMR_INFO';

8: c_skip_warning varchar2(10) := 'FALSE';
9: --
10: c_mig_smr_sd date := to_date('2007/04/01','YYYY/MM/DD');
11: --
12: c_com_hi_smr_elm pay_element_types_f.element_name%type := 'COM_HI_SMR_INFO';
13: c_am_iv pay_input_values_f.name%type := 'APPLY_MTH';
14: c_mr_iv pay_input_values_f.name%type := 'REVISED_MR';
15: c_mr_o_iv pay_input_values_f.name%type := 'PRIOR_MR';
16: c_smr_iv pay_input_values_f.name%type := 'REVISED_SMR';

Line 187: INDEX(PET PAY_ELEMENT_TYPES_F_PK)

183:
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,

Line 191: pay_element_types_f pet,

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
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

Line 208: INDEX(PET PAY_ELEMENT_TYPES_F_PK)

204:
205: CURSOR csr_element_link_id IS
206: select /*+ ORDERED
207: INDEX(PIV PAY_INPUT_VALUES_F_PK)
208: INDEX(PET PAY_ELEMENT_TYPES_F_PK)
209: INDEX(PEL PAY_ELEMENT_LINKS_F_N7) */
210: pel.rowid row_id,
211: pel.element_link_id element_link_id,
212: pel.costable_type costable_type,

Line 221: pay_element_types_f pet,

217: piv.max_value max_value,
218: piv.min_value min_value,
219: piv.warning_or_error warning_or_error
220: from pay_input_values_f piv,
221: pay_element_types_f pet,
222: pay_element_links_f pel
223: where piv.input_value_id = p_parameter_value
224: and pet.element_type_id = piv.element_type_id
225: and piv.effective_start_date