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_DYNSQL dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 122: from pay_element_entry_values_f eev

118: -- Setup entry values cursor.
119: cursor get_entry_values (p_update_ee_id in number,
120: p_date in date) is
121: select input_value_id, screen_entry_value
122: from pay_element_entry_values_f eev
123: where eev.element_entry_id = p_update_ee_id
124: and p_date between eev.effective_start_date
125: and eev.effective_end_date;
126: --

Line 137: from pay_element_entry_values_f eev

133: select eev.element_entry_value_id,
134: eev.input_value_id,
135: eev.element_entry_id,
136: eev.screen_entry_value
137: from pay_element_entry_values_f eev
138: where eev.element_entry_id = p_update_ee_id
139: and (p_date - 1) between
140: eev.effective_start_date and eev.effective_end_date;
141: --

Line 154: from pay_element_entry_values_f

150: cursor entry_value_exists(p_update_ee_id in number,
151: p_input_value_id in number,
152: p_effective_end_date in date) is
153: select effective_end_date,screen_entry_value
154: from pay_element_entry_values_f
155: where element_entry_id = p_update_ee_id
156: and input_value_id = p_input_value_id
157: and effective_start_date = p_effective_date
158: and effective_end_date = p_effective_end_date;

Line 174: screen_value pay_element_entry_values_f.screen_entry_value%type;

170: -- Bugfix 2827092
171: --value_set_id pay_input_values_f.value_set_id%type;
172: uom pay_input_values_f.uom%type;
173: input_curr pay_element_types_f.input_currency_code%type;
174: screen_value pay_element_entry_values_f.screen_entry_value%type;
175: db_value pay_element_entry_values_f.screen_entry_value%type;
176: old_value pay_element_entry_values_f.screen_entry_value%type;
177: scr_upd_value pay_element_entry_values_f.screen_entry_value%type;
178: entry_val_list char60_table;

Line 175: db_value pay_element_entry_values_f.screen_entry_value%type;

171: --value_set_id pay_input_values_f.value_set_id%type;
172: uom pay_input_values_f.uom%type;
173: input_curr pay_element_types_f.input_currency_code%type;
174: screen_value pay_element_entry_values_f.screen_entry_value%type;
175: db_value pay_element_entry_values_f.screen_entry_value%type;
176: old_value pay_element_entry_values_f.screen_entry_value%type;
177: scr_upd_value pay_element_entry_values_f.screen_entry_value%type;
178: entry_val_list char60_table;
179: l_all_entry_values_null varchar2(30);

Line 176: old_value pay_element_entry_values_f.screen_entry_value%type;

172: uom pay_input_values_f.uom%type;
173: input_curr pay_element_types_f.input_currency_code%type;
174: screen_value pay_element_entry_values_f.screen_entry_value%type;
175: db_value pay_element_entry_values_f.screen_entry_value%type;
176: old_value pay_element_entry_values_f.screen_entry_value%type;
177: scr_upd_value pay_element_entry_values_f.screen_entry_value%type;
178: entry_val_list char60_table;
179: l_all_entry_values_null varchar2(30);
180: l_effective_end_date date; -- bug 6655722

Line 177: scr_upd_value pay_element_entry_values_f.screen_entry_value%type;

173: input_curr pay_element_types_f.input_currency_code%type;
174: screen_value pay_element_entry_values_f.screen_entry_value%type;
175: db_value pay_element_entry_values_f.screen_entry_value%type;
176: old_value pay_element_entry_values_f.screen_entry_value%type;
177: scr_upd_value pay_element_entry_values_f.screen_entry_value%type;
178: entry_val_list char60_table;
179: l_all_entry_values_null varchar2(30);
180: l_effective_end_date date; -- bug 6655722
181: l_screen_entry_value pay_element_entrY_values_f.screen_entry_value%type;

Line 181: l_screen_entry_value pay_element_entrY_values_f.screen_entry_value%type;

177: scr_upd_value pay_element_entry_values_f.screen_entry_value%type;
178: entry_val_list char60_table;
179: l_all_entry_values_null varchar2(30);
180: l_effective_end_date date; -- bug 6655722
181: l_screen_entry_value pay_element_entrY_values_f.screen_entry_value%type;
182: ovn number(9);
183: begin
184: -- Select details about the element entry we are to update.
185: -- If p_element_entry_id is not null, the entry is restricted

Line 618: -- Check if a record exists in PAY_ELEMENT_ENTRY_VALUES_F with the same effective_start_date

614: */
615:
616:
617: -- Bug 7194700
618: -- Check if a record exists in PAY_ELEMENT_ENTRY_VALUES_F with the same effective_start_date
619: -- and effective_end_date. Proceed with the Update and Insert DMLs only if no such
620: -- record is there.
621: --
622:

Line 634: delete from pay_element_entry_values_f eev

630:
631: hr_utility.set_location(c_indent,60);
632:
633: /* bug 6655772
634: delete from pay_element_entry_values_f eev
635: where eev.element_entry_id = update_ee_id
636: and eev.effective_start_date > val_date;
637: */
638: --

Line 642: update pay_element_entry_values_f eev

638: --
639: -- Fix the end date of the entry values.
640: -- Note : using val_date.
641: hr_utility.set_location(c_indent,70);
642: update pay_element_entry_values_f eev
643: set eev.effective_end_date = (p_effective_date - 1)
644: where eev.element_entry_id = update_ee_id
645: and val_date between
646: eev.effective_start_date and eev.effective_end_date;

Line 685: update pay_element_entry_values_f eev

681: --
682: ELSIF (l_screen_entry_value is null
683: or l_screen_entry_value <> entry_val_list(p_input_value_id)) THEN -- bug 7314920
684: --
685: update pay_element_entry_values_f eev
686: set screen_entry_value = decode(trim(entry_val_list(p_input_value_id)), NULL, NULL, entry_val_list(p_input_value_id)) -- bug 7340357
687: where eev.element_entry_id = update_ee_id
688: and input_value_id = p_input_value_id
689: and p_effective_date between eev.effective_start_date and eev.effective_end_date;

Line 710: from pay_element_entry_values_f eev

706: eev.input_value_id,
707: eev.element_entry_id,
708: decode(eev.input_value_id, p_input_value_id,
709: db_value, eev.screen_entry_value)
710: from pay_element_entry_values_f eev
711: where eev.element_entry_id = update_ee_id
712: and (p_effective_date - 1) between
713: eev.effective_start_date and eev.effective_end_date;
714: */

Line 849: delete from pay_element_entry_values_f eev

845: where pee.element_entry_id = stop_ee_id
846: and p_date_earned between
847: pee.effective_start_date and pee.effective_end_date;
848: --
849: delete from pay_element_entry_values_f eev
850: where eev.element_entry_id = stop_ee_id
851: and eev.effective_start_date > p_date_earned;
852: --
853: update pay_element_entry_values_f eev

Line 853: update pay_element_entry_values_f eev

849: delete from pay_element_entry_values_f eev
850: where eev.element_entry_id = stop_ee_id
851: and eev.effective_start_date > p_date_earned;
852: --
853: update pay_element_entry_values_f eev
854: set eev.effective_end_date = p_date_earned
855: where eev.element_entry_id = stop_ee_id
856: and p_date_earned between
857: eev.effective_start_date and eev.effective_end_date;

Line 2731: from pay_element_entry_values_f ev3,

2727: select 'Y'
2728: from dual
2729: where (NOT EXISTS
2730: (select null
2731: from pay_element_entry_values_f ev3,
2732: pay_input_values_f iv3
2733: where TRANSLATE(UPPER(iv3.name), ' ', '_') =
2734: (select TRANSLATE(UPPER(hrl1.meaning), ' ', '_')
2735: from hr_lookups hrl1

Line 2748: from pay_element_entry_values_f ev4,

2744: or (iv3.effective_start_date < l_start_date
2745: and iv3.effective_end_date > l_start_date )))
2746: OR EXISTS
2747: (select null
2748: from pay_element_entry_values_f ev4,
2749: pay_input_values_f iv4
2750: where TRANSLATE(UPPER(iv4.name), ' ', '_') =
2751: (select TRANSLATE(UPPER(hrl2.meaning), ' ', '_')
2752: from hr_lookups hrl2

Line 3029: pay_element_entry_values_f p_pev,

3025: pay_asg.effective_start_date and pay_asg.effective_end_date
3026: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
3027: and exists (select null from
3028: pay_element_entries_f p_pee,
3029: pay_element_entry_values_f p_pev,
3030: pay_element_entry_values_f p_pev2,
3031: pay_input_values_f p_piv,
3032: pay_input_values_f p_piv2
3033: where p_pee.assignment_id = pay_asg.assignment_id

Line 3030: pay_element_entry_values_f p_pev2,

3026: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
3027: and exists (select null from
3028: pay_element_entries_f p_pee,
3029: pay_element_entry_values_f p_pev,
3030: pay_element_entry_values_f p_pev2,
3031: pay_input_values_f p_piv,
3032: pay_input_values_f p_piv2
3033: where p_pee.assignment_id = pay_asg.assignment_id
3034: and pay_pac.effective_date between p_pee.effective_start_date

Line 3089: pay_element_entry_values_f pay_pev,

3085: and exists
3086: (select null
3087: from pay_element_entries_f pay_pee,
3088: pay_element_types_f pay_pet,
3089: pay_element_entry_values_f pay_pev,
3090: pay_element_entry_values_f pay_pev2,
3091: pay_input_values_f pay_piv,
3092: pay_input_values_f pay_piv2
3093: where pay_pee.assignment_id = pay_asg.assignment_id

Line 3090: pay_element_entry_values_f pay_pev2,

3086: (select null
3087: from pay_element_entries_f pay_pee,
3088: pay_element_types_f pay_pet,
3089: pay_element_entry_values_f pay_pev,
3090: pay_element_entry_values_f pay_pev2,
3091: pay_input_values_f pay_piv,
3092: pay_input_values_f pay_piv2
3093: where pay_pee.assignment_id = pay_asg.assignment_id
3094: and pay_pee.element_type_id = pay_pet.element_type_id

Line 3139: pay_element_entry_values_f pay_pev,

3135: and exists
3136: (select null
3137: from pay_element_entries_f pay_pee,
3138: pay_element_types_f pay_pet,
3139: pay_element_entry_values_f pay_pev,
3140: pay_element_entry_values_f pay_pev2,
3141: pay_input_values_f pay_piv,
3142: pay_input_values_f pay_piv2
3143: where pay_pee.assignment_id = pay_asg.assignment_id

Line 3140: pay_element_entry_values_f pay_pev2,

3136: (select null
3137: from pay_element_entries_f pay_pee,
3138: pay_element_types_f pay_pet,
3139: pay_element_entry_values_f pay_pev,
3140: pay_element_entry_values_f pay_pev2,
3141: pay_input_values_f pay_piv,
3142: pay_input_values_f pay_piv2
3143: where pay_pee.assignment_id = pay_asg.assignment_id
3144: and pay_pee.element_type_id = pay_pet.element_type_id