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_ELEMENT_ENTRY_VALUES_F

Line 187: -- p_mode is ADD_NEW_IV then insert pay_link_input_value and pay_element_entry_values_f

183: end if;
184: END;
185:
186: --------------------------------------------------------------------------------
187: -- p_mode is ADD_NEW_IV then insert pay_link_input_value and pay_element_entry_values_f
188: --
189: PROCEDURE add_new_input_value(
190: p_mode IN VARCHAR2,
191: p_parameter_name IN VARCHAR2,

Line 255: and not exists(select /+ INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) /

251: pee.rowid row_id,
252: pee.element_entry_id element_entry_id
253: from pay_element_entries_f pee
254: where pee.element_link_id = p_element_link_id
255: and not exists(select /*+ INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */
256: NULL
257: from pay_element_entry_values_f peev
258: where peev.element_entry_id = pee.element_entry_id
259: and peev.input_value_id = p_input_value_id

Line 257: from pay_element_entry_values_f peev

253: from pay_element_entries_f pee
254: where pee.element_link_id = p_element_link_id
255: and not exists(select /*+ INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */
256: NULL
257: from pay_element_entry_values_f peev
258: where peev.element_entry_id = pee.element_entry_id
259: and peev.input_value_id = p_input_value_id
260: and peev.effective_start_date = pee.effective_start_date
261: and peev.effective_end_date = pee.effective_end_date);

Line 320: insert into pay_element_entry_values_f(

316: and input_value_id = l_input_value_id_to);
317: hr_utility.trace('Successefully created link_input_value '|| to_char(rec_element_link.element_link_id));
318:
319: for rec_element_entry in csr_element_entry_id(rec_element_link.element_link_id,l_input_value_id_to) loop
320: insert into pay_element_entry_values_f(
321: ELEMENT_ENTRY_VALUE_ID,
322: EFFECTIVE_START_DATE,
323: EFFECTIVE_END_DATE,
324: INPUT_VALUE_ID,

Line 871: l_am_eev pay_element_entry_values_f.screen_entry_value%type;

867: is
868: --
869: l_proc varchar2(80) := c_package||'val_mig_smr_assact';
870: --
871: l_am_eev pay_element_entry_values_f.screen_entry_value%type;
872: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
873: l_ee_esd date;
874: l_ee_upd_id number;
875: l_ft_ee_esd date;

Line 872: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;

868: --
869: l_proc varchar2(80) := c_package||'val_mig_smr_assact';
870: --
871: l_am_eev pay_element_entry_values_f.screen_entry_value%type;
872: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
873: l_ee_esd date;
874: l_ee_upd_id number;
875: l_ft_ee_esd date;
876: l_am_date date;

Line 1149: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;

1145: is
1146: --
1147: l_proc varchar2(80) := c_package||'mig_smr_assact';
1148: --
1149: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1150: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1151: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1152: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1153: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;

Line 1150: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;

1146: --
1147: l_proc varchar2(80) := c_package||'mig_smr_assact';
1148: --
1149: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1150: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1151: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1152: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1153: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1154: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;

Line 1151: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;

1147: l_proc varchar2(80) := c_package||'mig_smr_assact';
1148: --
1149: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1150: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1151: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1152: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1153: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1154: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1155: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;

Line 1152: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;

1148: --
1149: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1150: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1151: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1152: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1153: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1154: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1155: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1156: l_exp_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;

Line 1153: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;

1149: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1150: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1151: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1152: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1153: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1154: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1155: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1156: l_exp_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1157: --

Line 1154: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;

1150: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1151: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1152: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1153: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1154: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1155: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1156: l_exp_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1157: --
1158: l_ovn number;

Line 1155: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;

1151: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1152: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1153: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1154: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1155: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1156: l_exp_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1157: --
1158: l_ovn number;
1159: l_esd date;

Line 1156: l_exp_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;

1152: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1153: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1154: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1155: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1156: l_exp_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1157: --
1158: l_ovn number;
1159: l_esd date;
1160: l_eed date;

Line 1170: INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */

1166: select /*+ ORDERED
1167: USE_NL(PEL, PEE, PEEV)
1168: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)
1169: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
1170: INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */
1171: pee.element_entry_id,
1172: pee.effective_start_date,
1173: pee.effective_end_date,
1174: pee.object_version_number,

Line 1179: pay_element_entry_values_f peev

1175: peev.input_value_id,
1176: peev.screen_entry_value
1177: from pay_element_links_f pel,
1178: pay_element_entries_f pee,
1179: pay_element_entry_values_f peev
1180: where pel.element_type_id = c_com_hi_smr_elm_id
1181: and pel.business_group_id + 0 = p_business_group_id
1182: and p_session_date
1183: between pel.effective_start_date and pel.effective_end_date

Line 2396: INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */

2392: select /*+ ORDERED
2393: USE_NL(PLIV, PEE, PEEV)
2394: INDEX(PLIV PAY_LINK_INPUT_VALUES_F_N2)
2395: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
2396: INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */
2397: pee.element_entry_id,
2398: pee.object_version_number,
2399: peev.screen_entry_value sec_sal
2400: from pay_link_input_values_f pliv,

Line 2402: pay_element_entry_values_f peev

2398: pee.object_version_number,
2399: peev.screen_entry_value sec_sal
2400: from pay_link_input_values_f pliv,
2401: pay_element_entries_f pee,
2402: pay_element_entry_values_f peev
2403: where pliv.input_value_id = c_sec_sal_iv_id
2404: and p_session_date
2405: between pliv.effective_start_date and pliv.effective_end_date
2406: and pee.element_link_id = pliv.element_link_id