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 172: -- p_mode is ADD_NEW_IV then insert pay_link_input_value and pay_element_entry_values_f

168: end if;
169: END;
170:
171: --------------------------------------------------------------------------------
172: -- p_mode is ADD_NEW_IV then insert pay_link_input_value and pay_element_entry_values_f
173: --
174: PROCEDURE add_new_input_value(
175: p_mode IN VARCHAR2,
176: p_parameter_name IN VARCHAR2,

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

236: pee.rowid row_id,
237: pee.element_entry_id element_entry_id
238: from pay_element_entries_f pee
239: where pee.element_link_id = p_element_link_id
240: and not exists(select /*+ INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */
241: NULL
242: from pay_element_entry_values_f peev
243: where peev.element_entry_id = pee.element_entry_id
244: and peev.input_value_id = p_input_value_id

Line 242: from pay_element_entry_values_f peev

238: from pay_element_entries_f pee
239: where pee.element_link_id = p_element_link_id
240: and not exists(select /*+ INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */
241: NULL
242: from pay_element_entry_values_f peev
243: where peev.element_entry_id = pee.element_entry_id
244: and peev.input_value_id = p_input_value_id
245: and peev.effective_start_date = pee.effective_start_date
246: and peev.effective_end_date = pee.effective_end_date);

Line 305: insert into pay_element_entry_values_f(

301: and input_value_id = l_input_value_id_to);
302: hr_utility.trace('Successefully created link_input_value '|| to_char(rec_element_link.element_link_id));
303:
304: for rec_element_entry in csr_element_entry_id(rec_element_link.element_link_id,l_input_value_id_to) loop
305: insert into pay_element_entry_values_f(
306: ELEMENT_ENTRY_VALUE_ID,
307: EFFECTIVE_START_DATE,
308: EFFECTIVE_END_DATE,
309: INPUT_VALUE_ID,

Line 796: l_am_eev pay_element_entry_values_f.screen_entry_value%type;

792: is
793: --
794: l_proc varchar2(80) := c_package||'val_mig_smr_assact';
795: --
796: l_am_eev pay_element_entry_values_f.screen_entry_value%type;
797: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
798: l_ee_esd date;
799: l_ee_upd_id number;
800: l_ft_ee_esd date;

Line 797: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;

793: --
794: l_proc varchar2(80) := c_package||'val_mig_smr_assact';
795: --
796: l_am_eev pay_element_entry_values_f.screen_entry_value%type;
797: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
798: l_ee_esd date;
799: l_ee_upd_id number;
800: l_ft_ee_esd date;
801: l_am_date date;

Line 1074: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;

1070: is
1071: --
1072: l_proc varchar2(80) := c_package||'mig_smr_assact';
1073: --
1074: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1075: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1076: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1077: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1078: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;

Line 1075: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;

1071: --
1072: l_proc varchar2(80) := c_package||'mig_smr_assact';
1073: --
1074: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1075: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1076: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1077: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1078: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1079: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;

Line 1076: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;

1072: l_proc varchar2(80) := c_package||'mig_smr_assact';
1073: --
1074: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1075: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1076: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1077: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1078: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1079: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1080: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;

Line 1077: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;

1073: --
1074: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1075: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1076: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1077: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1078: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1079: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1080: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1081: l_exp_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;

Line 1078: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;

1074: l_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1075: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1076: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1077: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1078: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1079: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1080: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1081: l_exp_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1082: --

Line 1079: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;

1075: l_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1076: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1077: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1078: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1079: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1080: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1081: l_exp_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1082: --
1083: l_ovn number;

Line 1080: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;

1076: l_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1077: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1078: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1079: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1080: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1081: l_exp_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1082: --
1083: l_ovn number;
1084: l_esd date;

Line 1081: l_exp_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;

1077: l_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1078: l_exp_mr_eev pay_element_entry_values_f.screen_entry_value%type;
1079: l_exp_smr_eev pay_element_entry_values_f.screen_entry_value%type;
1080: l_exp_mr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1081: l_exp_smr_o_eev pay_element_entry_values_f.screen_entry_value%type;
1082: --
1083: l_ovn number;
1084: l_esd date;
1085: l_eed date;

Line 1095: INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */

1091: select /*+ ORDERED
1092: USE_NL(PEL, PEE, PEEV)
1093: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)
1094: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
1095: INDEX(PEEV PAY_ELEMENT_ENTRY_VALUES_F_N50) */
1096: pee.element_entry_id,
1097: pee.effective_start_date,
1098: pee.effective_end_date,
1099: pee.object_version_number,

Line 1104: pay_element_entry_values_f peev

1100: peev.input_value_id,
1101: peev.screen_entry_value
1102: from pay_element_links_f pel,
1103: pay_element_entries_f pee,
1104: pay_element_entry_values_f peev
1105: where pel.element_type_id = c_com_hi_smr_elm_id
1106: and pel.business_group_id + 0 = p_business_group_id
1107: and p_session_date
1108: between pel.effective_start_date and pel.effective_end_date