APPS.HR_JP_DATA_MIGRATION_PKG dependencies on PAY_ELEMENT_TYPES_F

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

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

Line 55: c_yea_dep_exm_elm pay_element_types_f.element_name%type := 'YEA_DEP_EXM_INFO';

51: --
52: g_qualify_ini_ass_id number;
53: g_migrate_ini_ass_id number;
54: --
55: c_yea_dep_exm_elm pay_element_types_f.element_name%type := 'YEA_DEP_EXM_INFO';
56: c_sec_sal_iv pay_input_values_f.name%type := 'SECOND_SAL_SUBMIT_FLAG';
57: --
58: g_ass_info t_ass_hi_smr_rec;
59: --

Line 202: INDEX(PET PAY_ELEMENT_TYPES_F_PK)

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

Line 206: pay_element_types_f pet,

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

Line 223: INDEX(PET PAY_ELEMENT_TYPES_F_PK)

219:
220: CURSOR csr_element_link_id IS
221: select /*+ ORDERED
222: INDEX(PIV PAY_INPUT_VALUES_F_PK)
223: INDEX(PET PAY_ELEMENT_TYPES_F_PK)
224: INDEX(PEL PAY_ELEMENT_LINKS_F_N7) */
225: pel.rowid row_id,
226: pel.element_link_id element_link_id,
227: pel.costable_type costable_type,

Line 236: pay_element_types_f pet,

232: piv.max_value max_value,
233: piv.min_value min_value,
234: piv.warning_or_error warning_or_error
235: from pay_input_values_f piv,
236: pay_element_types_f pet,
237: pay_element_links_f pel
238: where piv.input_value_id = p_parameter_value
239: and pet.element_type_id = piv.element_type_id
240: and piv.effective_start_date