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.PAY_US_ELEMENT_ENTRY_HOOK dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 150: ,pay_element_entry_values_f peevf

146: ,pivf.name
147: ,peevf.screen_entry_value
148: from pay_element_entries_f peef
149: ,pay_element_types_f petf
150: ,pay_element_entry_values_f peevf
151: ,pay_input_values_f pivf
152: ,pay_status_processing_rules_f psprf
153: ,ff_formulas_f fff
154: ,pay_element_classifications pec

Line 281: update pay_element_entry_values_f peev

277: ,ld_rec_ele_end_date;
278: close c_get_period_dates;
279: hr_utility.trace('Updating the Element Entry values for the NR Element');
280: -- Updating the Start Date to the Payroll Start Date
281: update pay_element_entry_values_f peev
282: set screen_entry_value = fnd_date.date_to_canonical
283: (ld_rec_ele_start_date)
284: where element_entry_value_id =
285: (select distinct peev1.element_entry_value_id

Line 286: from pay_element_entry_values_f peev1,

282: set screen_entry_value = fnd_date.date_to_canonical
283: (ld_rec_ele_start_date)
284: where element_entry_value_id =
285: (select distinct peev1.element_entry_value_id
286: from pay_element_entry_values_f peev1,
287: pay_element_entries_f peef,
288: pay_input_values_f pivf
289: where peef.element_entry_id = p_element_entry_id
290: and pivf.element_type_id = peef.element_type_id

Line 296: update pay_element_entry_values_f peev

292: and peev1.element_entry_id = peef.element_entry_id
293: and peev1.input_value_id = pivf.input_value_id);
294:
295: -- Updating the End Date to the Payroll End Date
296: update pay_element_entry_values_f peev
297: set screen_entry_value = fnd_date.date_to_canonical
298: (ld_rec_ele_end_date)
299: where element_entry_value_id =
300: (select distinct peev1.element_entry_value_id

Line 301: from pay_element_entry_values_f peev1,

297: set screen_entry_value = fnd_date.date_to_canonical
298: (ld_rec_ele_end_date)
299: where element_entry_value_id =
300: (select distinct peev1.element_entry_value_id
301: from pay_element_entry_values_f peev1,
302: pay_element_entries_f peef,
303: pay_input_values_f pivf
304: where peef.element_entry_id = p_element_entry_id
305: and pivf.element_type_id = peef.element_type_id

Line 718: ,pay_element_entry_values_f peev

714: select pivf.name
715: ,peev.screen_entry_value
716: ,pivf.lookup_type
717: from pay_input_values_f pivf
718: ,pay_element_entry_values_f peev
719: where peev.element_entry_id = c_element_entry_id
720: and peev.input_value_id = pivf.input_value_id
721: and c_effective_date between peev.effective_start_date
722: and peev.effective_end_date

Line 1051: from pay_element_entry_values_f peev

1047: -- entered in the element entry
1048: cursor c_get_jursidiction(c_element_entry_id number,
1049: c_effective_date date) is
1050: select rtrim(ltrim(peev.screen_entry_value))
1051: from pay_element_entry_values_f peev
1052: ,pay_element_entries_f peef
1053: ,pay_input_values_f pivf
1054: where peef.element_entry_id = c_element_entry_id
1055: and pivf.element_type_id = peef.element_type_id

Line 1376: pay_element_entry_values_f peev

1372: ,c_effective_date date) is
1373: select count(peev.screen_entry_value)
1374: from pay_element_entries_f peef,
1375: pay_input_values_f pivf,
1376: pay_element_entry_values_f peev
1377: where peef.element_entry_id = c_element_entry_id
1378: and pivf.element_type_id = peef.element_type_id
1379: and pivf.name in ('Rate', 'Rate Code')
1380: and peev.element_entry_id = peef.element_entry_id

Line 1508: from pay_element_entry_values_f peev

1504: cursor c_get_scr_entry_value(c_element_entry_id number,
1505: c_inp_value_name varchar2,
1506: c_effective_date date) is
1507: select peev.screen_entry_value
1508: from pay_element_entry_values_f peev
1509: ,pay_element_entries_f peef
1510: ,pay_input_values_f pivf
1511: where peef.element_entry_id = c_element_entry_id
1512: and peev.element_entry_id = peef.element_entry_id

Line 1920: pay_element_entry_values_f peev,

1916: ,peef.effective_start_date
1917: ,peef.effective_end_date
1918: ,peev.screen_entry_value
1919: from pay_element_entries_f peef,
1920: pay_element_entry_values_f peev,
1921: pay_input_values_f pivf
1922: where peef.creator_id = c_element_entry_id
1923: and peef.assignment_id = c_assignment_id
1924: and peef.creator_type = 'FL'

Line 1940: ,pay_element_entry_values_f peevf

1936: ,c_effective_start_date date) is
1937: select pivf.name
1938: ,peevf.screen_entry_value
1939: from pay_element_entries_f peef
1940: ,pay_element_entry_values_f peevf
1941: ,pay_input_values_f pivf
1942: where peef.element_entry_id = c_element_entry_id
1943: and peevf.element_entry_id = peef.element_entry_id
1944: and pivf.element_type_id = peef.element_type_id

Line 2194: pay_element_entry_values_f peev

2190: ,c_effective_date date) is
2191: select count(peev.screen_entry_value)
2192: from pay_element_entries_f peef,
2193: pay_input_values_f pivf,
2194: pay_element_entry_values_f peev
2195: where peef.element_entry_id = c_element_entry_id
2196: and pivf.element_type_id = peef.element_type_id
2197: and pivf.name in ('Rate', 'Rate Code')
2198: and peev.element_entry_id = peef.element_entry_id

Line 2265: from pay_element_entry_values_f peev

2261: cursor c_get_scr_entry_value(c_element_entry_id number,
2262: c_inp_value_name varchar2,
2263: c_effective_date date) is
2264: select peev.screen_entry_value
2265: from pay_element_entry_values_f peev
2266: ,pay_element_entries_f peef
2267: ,pay_input_values_f pivf
2268: where peef.element_entry_id = c_element_entry_id
2269: and peev.element_entry_id = peef.element_entry_id