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_INPUT_VALUES_F

Line 13: c_am_iv pay_input_values_f.name%type := 'APPLY_MTH';

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';
17: c_smr_o_iv pay_input_values_f.name%type := 'PRIOR_SMR';

Line 14: c_mr_iv pay_input_values_f.name%type := 'REVISED_MR';

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';
17: c_smr_o_iv pay_input_values_f.name%type := 'PRIOR_SMR';
18: c_at_iv pay_input_values_f.name%type := 'APPLY_TYPE';

Line 15: c_mr_o_iv pay_input_values_f.name%type := 'PRIOR_MR';

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';
17: c_smr_o_iv pay_input_values_f.name%type := 'PRIOR_SMR';
18: c_at_iv pay_input_values_f.name%type := 'APPLY_TYPE';
19: --

Line 16: c_smr_iv pay_input_values_f.name%type := 'REVISED_SMR';

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';
17: c_smr_o_iv pay_input_values_f.name%type := 'PRIOR_SMR';
18: c_at_iv pay_input_values_f.name%type := 'APPLY_TYPE';
19: --
20: c_com_hi_smr_elm_id number;

Line 17: c_smr_o_iv pay_input_values_f.name%type := 'PRIOR_SMR';

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';
17: c_smr_o_iv pay_input_values_f.name%type := 'PRIOR_SMR';
18: c_at_iv pay_input_values_f.name%type := 'APPLY_TYPE';
19: --
20: c_com_hi_smr_elm_id number;
21: c_am_iv_id number;

Line 18: c_at_iv pay_input_values_f.name%type := 'APPLY_TYPE';

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';
17: c_smr_o_iv pay_input_values_f.name%type := 'PRIOR_SMR';
18: c_at_iv pay_input_values_f.name%type := 'APPLY_TYPE';
19: --
20: c_com_hi_smr_elm_id number;
21: c_am_iv_id number;
22: c_mr_iv_id number;

Line 186: INDEX(PIV PAY_INPUT_VALUES_F_PK)

182: l_total_upd_actions NUMBER := 0;
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,

Line 190: from pay_input_values_f piv,

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
193: where piv.input_value_id = p_parameter_value
194: and pet.element_type_id = piv.element_type_id

Line 207: INDEX(PIV PAY_INPUT_VALUES_F_PK)

203: and prrv.input_value_id=l_input_value_id_to);
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,

Line 220: from pay_input_values_f piv,

216: piv.default_value default_value,
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