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 117: from pay_element_entry_values_f eev

113: -- Setup entry values cursor.
114: cursor get_entry_values (p_update_ee_id in number,
115: p_date in date) is
116: select input_value_id, screen_entry_value
117: from pay_element_entry_values_f eev
118: where eev.element_entry_id = p_update_ee_id
119: and p_date between eev.effective_start_date
120: and eev.effective_end_date;
121: --

Line 132: from pay_element_entry_values_f eev

128: select eev.element_entry_value_id,
129: eev.input_value_id,
130: eev.element_entry_id,
131: eev.screen_entry_value
132: from pay_element_entry_values_f eev
133: where eev.element_entry_id = p_update_ee_id
134: and (p_date - 1) between
135: eev.effective_start_date and eev.effective_end_date;
136: --

Line 149: from pay_element_entry_values_f

145: cursor entry_value_exists(p_update_ee_id in number,
146: p_input_value_id in number,
147: p_effective_end_date in date) is
148: select effective_end_date,screen_entry_value
149: from pay_element_entry_values_f
150: where element_entry_id = p_update_ee_id
151: and input_value_id = p_input_value_id
152: and effective_start_date = p_effective_date
153: and effective_end_date = p_effective_end_date;

Line 169: screen_value pay_element_entry_values_f.screen_entry_value%type;

165: -- Bugfix 2827092
166: --value_set_id pay_input_values_f.value_set_id%type;
167: uom pay_input_values_f.uom%type;
168: input_curr pay_element_types_f.input_currency_code%type;
169: screen_value pay_element_entry_values_f.screen_entry_value%type;
170: db_value pay_element_entry_values_f.screen_entry_value%type;
171: old_value pay_element_entry_values_f.screen_entry_value%type;
172: scr_upd_value pay_element_entry_values_f.screen_entry_value%type;
173: entry_val_list char60_table;

Line 170: db_value pay_element_entry_values_f.screen_entry_value%type;

166: --value_set_id pay_input_values_f.value_set_id%type;
167: uom pay_input_values_f.uom%type;
168: input_curr pay_element_types_f.input_currency_code%type;
169: screen_value pay_element_entry_values_f.screen_entry_value%type;
170: db_value pay_element_entry_values_f.screen_entry_value%type;
171: old_value pay_element_entry_values_f.screen_entry_value%type;
172: scr_upd_value pay_element_entry_values_f.screen_entry_value%type;
173: entry_val_list char60_table;
174: l_all_entry_values_null varchar2(30);

Line 171: old_value pay_element_entry_values_f.screen_entry_value%type;

167: uom pay_input_values_f.uom%type;
168: input_curr pay_element_types_f.input_currency_code%type;
169: screen_value pay_element_entry_values_f.screen_entry_value%type;
170: db_value pay_element_entry_values_f.screen_entry_value%type;
171: old_value pay_element_entry_values_f.screen_entry_value%type;
172: scr_upd_value pay_element_entry_values_f.screen_entry_value%type;
173: entry_val_list char60_table;
174: l_all_entry_values_null varchar2(30);
175: l_effective_end_date date; -- bug 6655722

Line 172: scr_upd_value pay_element_entry_values_f.screen_entry_value%type;

168: input_curr pay_element_types_f.input_currency_code%type;
169: screen_value pay_element_entry_values_f.screen_entry_value%type;
170: db_value pay_element_entry_values_f.screen_entry_value%type;
171: old_value pay_element_entry_values_f.screen_entry_value%type;
172: scr_upd_value pay_element_entry_values_f.screen_entry_value%type;
173: entry_val_list char60_table;
174: l_all_entry_values_null varchar2(30);
175: l_effective_end_date date; -- bug 6655722
176: l_screen_entry_value pay_element_entrY_values_f.screen_entry_value%type;

Line 176: l_screen_entry_value pay_element_entrY_values_f.screen_entry_value%type;

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

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

609: */
610:
611:
612: -- Bug 7194700
613: -- Check if a record exists in PAY_ELEMENT_ENTRY_VALUES_F with the same effective_start_date
614: -- and effective_end_date. Proceed with the Update and Insert DMLs only if no such
615: -- record is there.
616: --
617:

Line 629: delete from pay_element_entry_values_f eev

625:
626: hr_utility.set_location(c_indent,60);
627:
628: /* bug 6655772
629: delete from pay_element_entry_values_f eev
630: where eev.element_entry_id = update_ee_id
631: and eev.effective_start_date > val_date;
632: */
633: --

Line 637: update pay_element_entry_values_f eev

633: --
634: -- Fix the end date of the entry values.
635: -- Note : using val_date.
636: hr_utility.set_location(c_indent,70);
637: update pay_element_entry_values_f eev
638: set eev.effective_end_date = (p_effective_date - 1)
639: where eev.element_entry_id = update_ee_id
640: and val_date between
641: eev.effective_start_date and eev.effective_end_date;

Line 680: update pay_element_entry_values_f eev

676: --
677: ELSIF (l_screen_entry_value is null
678: or l_screen_entry_value <> entry_val_list(p_input_value_id)) THEN -- bug 7314920
679: --
680: update pay_element_entry_values_f eev
681: set screen_entry_value = entry_val_list(p_input_value_id) -- bug 7340357
682: where eev.element_entry_id = update_ee_id
683: and input_value_id = p_input_value_id
684: and p_effective_date between eev.effective_start_date and eev.effective_end_date;

Line 705: from pay_element_entry_values_f eev

701: eev.input_value_id,
702: eev.element_entry_id,
703: decode(eev.input_value_id, p_input_value_id,
704: db_value, eev.screen_entry_value)
705: from pay_element_entry_values_f eev
706: where eev.element_entry_id = update_ee_id
707: and (p_effective_date - 1) between
708: eev.effective_start_date and eev.effective_end_date;
709: */

Line 844: delete from pay_element_entry_values_f eev

840: where pee.element_entry_id = stop_ee_id
841: and p_date_earned between
842: pee.effective_start_date and pee.effective_end_date;
843: --
844: delete from pay_element_entry_values_f eev
845: where eev.element_entry_id = stop_ee_id
846: and eev.effective_start_date > p_date_earned;
847: --
848: update pay_element_entry_values_f eev

Line 848: update pay_element_entry_values_f eev

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

Line 2673: from pay_element_entry_values_f ev3,

2669: select 'Y'
2670: from dual
2671: where (NOT EXISTS
2672: (select null
2673: from pay_element_entry_values_f ev3,
2674: pay_input_values_f iv3
2675: where TRANSLATE(UPPER(iv3.name), ' ', '_') =
2676: (select TRANSLATE(UPPER(hrl1.meaning), ' ', '_')
2677: from hr_lookups hrl1

Line 2690: from pay_element_entry_values_f ev4,

2686: or (iv3.effective_start_date < l_start_date
2687: and iv3.effective_end_date > l_start_date )))
2688: OR EXISTS
2689: (select null
2690: from pay_element_entry_values_f ev4,
2691: pay_input_values_f iv4
2692: where TRANSLATE(UPPER(iv4.name), ' ', '_') =
2693: (select TRANSLATE(UPPER(hrl2.meaning), ' ', '_')
2694: from hr_lookups hrl2

Line 2951: pay_element_entry_values_f p_pev,

2947: pay_asg.effective_start_date and pay_asg.effective_end_date
2948: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
2949: and exists (select null from
2950: pay_element_entries_f p_pee,
2951: pay_element_entry_values_f p_pev,
2952: pay_element_entry_values_f p_pev2,
2953: pay_input_values_f p_piv,
2954: pay_input_values_f p_piv2
2955: where p_pee.assignment_id = pay_asg.assignment_id

Line 2952: pay_element_entry_values_f p_pev2,

2948: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
2949: and exists (select null from
2950: pay_element_entries_f p_pee,
2951: pay_element_entry_values_f p_pev,
2952: pay_element_entry_values_f p_pev2,
2953: pay_input_values_f p_piv,
2954: pay_input_values_f p_piv2
2955: where p_pee.assignment_id = pay_asg.assignment_id
2956: and pay_pac.effective_date between p_pee.effective_start_date

Line 3011: pay_element_entry_values_f pay_pev,

3007: and exists
3008: (select null
3009: from pay_element_entries_f pay_pee,
3010: pay_element_types_f pay_pet,
3011: pay_element_entry_values_f pay_pev,
3012: pay_element_entry_values_f pay_pev2,
3013: pay_input_values_f pay_piv,
3014: pay_input_values_f pay_piv2
3015: where pay_pee.assignment_id = pay_asg.assignment_id

Line 3012: pay_element_entry_values_f pay_pev2,

3008: (select null
3009: from pay_element_entries_f pay_pee,
3010: pay_element_types_f pay_pet,
3011: pay_element_entry_values_f pay_pev,
3012: pay_element_entry_values_f pay_pev2,
3013: pay_input_values_f pay_piv,
3014: pay_input_values_f pay_piv2
3015: where pay_pee.assignment_id = pay_asg.assignment_id
3016: and pay_pee.element_type_id = pay_pet.element_type_id

Line 3061: pay_element_entry_values_f pay_pev,

3057: and exists
3058: (select null
3059: from pay_element_entries_f pay_pee,
3060: pay_element_types_f pay_pet,
3061: pay_element_entry_values_f pay_pev,
3062: pay_element_entry_values_f pay_pev2,
3063: pay_input_values_f pay_piv,
3064: pay_input_values_f pay_piv2
3065: where pay_pee.assignment_id = pay_asg.assignment_id

Line 3062: pay_element_entry_values_f pay_pev2,

3058: (select null
3059: from pay_element_entries_f pay_pee,
3060: pay_element_types_f pay_pet,
3061: pay_element_entry_values_f pay_pev,
3062: pay_element_entry_values_f pay_pev2,
3063: pay_input_values_f pay_piv,
3064: pay_input_values_f pay_piv2
3065: where pay_pee.assignment_id = pay_asg.assignment_id
3066: and pay_pee.element_type_id = pay_pet.element_type_id