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 134: ,pay_element_entry_values_f peevf

130: ,pivf.name
131: ,peevf.screen_entry_value
132: from pay_element_entries_f peef
133: ,pay_element_types_f petf
134: ,pay_element_entry_values_f peevf
135: ,pay_input_values_f pivf
136: ,pay_status_processing_rules_f psprf
137: ,ff_formulas_f fff
138: ,pay_element_classifications pec

Line 265: update pay_element_entry_values_f peev

261: ,ld_rec_ele_end_date;
262: close c_get_period_dates;
263: hr_utility.trace('Updating the Element Entry values for the NR Element');
264: -- Updating the Start Date to the Payroll Start Date
265: update pay_element_entry_values_f peev
266: set screen_entry_value = fnd_date.date_to_canonical
267: (ld_rec_ele_start_date)
268: where element_entry_value_id =
269: (select distinct peev1.element_entry_value_id

Line 270: from pay_element_entry_values_f peev1,

266: set screen_entry_value = fnd_date.date_to_canonical
267: (ld_rec_ele_start_date)
268: where element_entry_value_id =
269: (select distinct peev1.element_entry_value_id
270: from pay_element_entry_values_f peev1,
271: pay_element_entries_f peef,
272: pay_input_values_f pivf
273: where peef.element_entry_id = p_element_entry_id
274: and pivf.element_type_id = peef.element_type_id

Line 280: update pay_element_entry_values_f peev

276: and peev1.element_entry_id = peef.element_entry_id
277: and peev1.input_value_id = pivf.input_value_id);
278:
279: -- Updating the End Date to the Payroll End Date
280: update pay_element_entry_values_f peev
281: set screen_entry_value = fnd_date.date_to_canonical
282: (ld_rec_ele_end_date)
283: where element_entry_value_id =
284: (select distinct peev1.element_entry_value_id

Line 285: from pay_element_entry_values_f peev1,

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

Line 690: ,pay_element_entry_values_f peev

686: select pivf.name
687: ,peev.screen_entry_value
688: ,pivf.lookup_type
689: from pay_input_values_f pivf
690: ,pay_element_entry_values_f peev
691: where peev.element_entry_id = c_element_entry_id
692: and peev.input_value_id = pivf.input_value_id
693: and c_effective_date between peev.effective_start_date
694: and peev.effective_end_date

Line 1023: from pay_element_entry_values_f peev

1019: -- entered in the element entry
1020: cursor c_get_jursidiction(c_element_entry_id number,
1021: c_effective_date date) is
1022: select rtrim(ltrim(peev.screen_entry_value))
1023: from pay_element_entry_values_f peev
1024: ,pay_element_entries_f peef
1025: ,pay_input_values_f pivf
1026: where peef.element_entry_id = c_element_entry_id
1027: and pivf.element_type_id = peef.element_type_id

Line 1290: pay_element_entry_values_f peev

1286: ,c_effective_date date) is
1287: select count(peev.screen_entry_value)
1288: from pay_element_entries_f peef,
1289: pay_input_values_f pivf,
1290: pay_element_entry_values_f peev
1291: where peef.element_entry_id = c_element_entry_id
1292: and pivf.element_type_id = peef.element_type_id
1293: and pivf.name in ('Rate', 'Rate Code')
1294: and peev.element_entry_id = peef.element_entry_id

Line 1410: from pay_element_entry_values_f peev

1406: cursor c_get_scr_entry_value(c_element_entry_id number,
1407: c_inp_value_name varchar2,
1408: c_effective_date date) is
1409: select peev.screen_entry_value
1410: from pay_element_entry_values_f peev
1411: ,pay_element_entries_f peef
1412: ,pay_input_values_f pivf
1413: where peef.element_entry_id = c_element_entry_id
1414: and peev.element_entry_id = peef.element_entry_id

Line 1822: pay_element_entry_values_f peev,

1818: ,peef.effective_start_date
1819: ,peef.effective_end_date
1820: ,peev.screen_entry_value
1821: from pay_element_entries_f peef,
1822: pay_element_entry_values_f peev,
1823: pay_input_values_f pivf
1824: where peef.creator_id = c_element_entry_id
1825: and peef.assignment_id = c_assignment_id
1826: and peef.creator_type = 'FL'

Line 1842: ,pay_element_entry_values_f peevf

1838: ,c_effective_start_date date) is
1839: select pivf.name
1840: ,peevf.screen_entry_value
1841: from pay_element_entries_f peef
1842: ,pay_element_entry_values_f peevf
1843: ,pay_input_values_f pivf
1844: where peef.element_entry_id = c_element_entry_id
1845: and peevf.element_entry_id = peef.element_entry_id
1846: and pivf.element_type_id = peef.element_type_id

Line 2096: pay_element_entry_values_f peev

2092: ,c_effective_date date) is
2093: select count(peev.screen_entry_value)
2094: from pay_element_entries_f peef,
2095: pay_input_values_f pivf,
2096: pay_element_entry_values_f peev
2097: where peef.element_entry_id = c_element_entry_id
2098: and pivf.element_type_id = peef.element_type_id
2099: and pivf.name in ('Rate', 'Rate Code')
2100: and peev.element_entry_id = peef.element_entry_id

Line 2167: from pay_element_entry_values_f peev

2163: cursor c_get_scr_entry_value(c_element_entry_id number,
2164: c_inp_value_name varchar2,
2165: c_effective_date date) is
2166: select peev.screen_entry_value
2167: from pay_element_entry_values_f peev
2168: ,pay_element_entries_f peef
2169: ,pay_input_values_f pivf
2170: where peef.element_entry_id = c_element_entry_id
2171: and peev.element_entry_id = peef.element_entry_id