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_ENTRIES_F

Line 132: from pay_element_entries_f peef

128: select petf.element_name
129: ,petf.business_group_id
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

Line 271: pay_element_entries_f peef,

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
275: and upper(pivf.name) = 'EARNED START DATE'

Line 286: pay_element_entries_f peef,

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
290: and upper(pivf.name) = 'EARNED END DATE'

Line 334: from pay_element_entries_f peef

330: ,c_effective_start_date date) is
331: select petf.element_name
332: ,petf.business_group_id
333: ,petf.processing_type
334: from pay_element_entries_f peef
335: ,pay_element_types_f petf
336: ,pay_status_processing_rules_f psprf
337: ,ff_formulas_f fff
338: where peef.element_entry_id = c_element_entry_id

Line 397: from pay_element_entries_f peef

393: cursor c_get_ele_entry_id(c_element_entry_id varchar2
394: ,c_assignment_id number) is
395: select max(peef.element_entry_id)
396: ,min(peef.effective_start_date)
397: from pay_element_entries_f peef
398: where peef.creator_id = c_element_entry_id
399: and peef.assignment_id = c_assignment_id
400: and peef.creator_type = 'FL'
401: group by peef.element_entry_id

Line 1024: ,pay_element_entries_f peef

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
1028: and upper(pivf.name) = 'JURISDICTION'

Line 1266: from pay_element_entries_f peef

1262: ,per_time_periods ptpt
1263: where paf.assignment_id = c_assignment_id
1264: and ptpp.payroll_id = paf.payroll_id
1265: and ptpp.start_date <= (select max(peef.effective_end_date)
1266: from pay_element_entries_f peef
1267: where peef.element_entry_id = c_element_entry_id)
1268: and ptpp.end_date >= (select max(peef.effective_end_date)
1269: from pay_element_entries_f peef
1270: where peef.element_entry_id = c_element_entry_id)

Line 1269: from pay_element_entries_f peef

1265: and ptpp.start_date <= (select max(peef.effective_end_date)
1266: from pay_element_entries_f peef
1267: where peef.element_entry_id = c_element_entry_id)
1268: and ptpp.end_date >= (select max(peef.effective_end_date)
1269: from pay_element_entries_f peef
1270: where peef.element_entry_id = c_element_entry_id)
1271: and ptpt.time_definition_id = c_time_def_id
1272: and ptpp.end_date between ptpt.start_date
1273: and ptpt.end_date

Line 1288: from pay_element_entries_f peef,

1284:
1285: cursor c_get_rate_entry_count(c_element_entry_id number
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

Line 1402: FROM pay_element_entries_f

1398: -- Get date_earned of element_entry
1399: CURSOR c_get_date_earned(c_element_entry_id number
1400: ) IS
1401: SELECT date_earned
1402: FROM pay_element_entries_f
1403: WHERE element_entry_id = c_element_entry_id;
1404:
1405: -- Get the screen entry value
1406: cursor c_get_scr_entry_value(c_element_entry_id number,

Line 1411: ,pay_element_entries_f peef

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
1415: and pivf.element_type_id = peef.element_type_id

Line 1725: update pay_element_entries_f

1721: * set as it requires that the Orignal Entry ID be a recurring
1722: * Element. In our case we can have the Original Entry ID to
1723: * be Non-Recurring.
1724: */
1725: update pay_element_entries_f
1726: set original_entry_id = p_element_entry_id
1727: where element_entry_id = ln_element_entry_id;
1728: end loop; -- for lvr in 1..
1729: end if; -- if lb_mop_up_flag

Line 1821: from pay_element_entries_f peef,

1817: peef.element_entry_id
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

Line 1841: from pay_element_entries_f peef

1837: cursor c_get_aug_entry_details(c_element_entry_id number
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

Line 2094: from pay_element_entries_f peef,

2090:
2091: cursor c_get_rate_entry_count(c_element_entry_id number
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

Line 2113: from pay_element_entries_f peef

2109:
2110: cursor c_check_mop_up_exists(c_element_entry_id number
2111: ,c_assignment_id number) is
2112: select 'Exist'
2113: from pay_element_entries_f peef
2114: where peef.creator_id = c_element_entry_id
2115: and peef.assignment_id = c_assignment_id
2116: and peef.creator_type = 'FL';
2117:

Line 2123: from pay_element_entries_f peef

2119: cursor c_get_entry_end_date(c_element_entry_id number
2120: ,c_assignment_id number) is
2121: select nvl(max(peef.effective_end_date),
2122: fnd_date.canonical_to_date('4712/12/31'))
2123: from pay_element_entries_f peef
2124: where peef.element_entry_id = c_element_entry_id
2125: and peef.assignment_id = c_assignment_id;
2126:
2127: -- Get date_earned of element_entry

Line 2131: FROM pay_element_entries_f

2127: -- Get date_earned of element_entry
2128: CURSOR c_get_date_earned(c_element_entry_id number
2129: ) IS
2130: SELECT date_earned
2131: FROM pay_element_entries_f
2132: WHERE element_entry_id = c_element_entry_id;
2133:
2134: -- Get dates in which mop-up should exist of element_entry
2135: cursor c_get_nrec_mop_up_dates(c_assignment_id NUMBER

Line 2168: ,pay_element_entries_f peef

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
2172: and pivf.element_type_id = peef.element_type_id

Line 2188: from pay_element_entries_f peef

2184: ,c_assignment_id number) is
2185: select distinct
2186: peef.element_entry_id
2187: ,peef.effective_start_date
2188: from pay_element_entries_f peef
2189: where peef.creator_id = c_element_entry_id
2190: and peef.assignment_id = c_assignment_id
2191: and peef.creator_type = 'FL'
2192: order by peef.effective_start_date;

Line 2472: from pay_element_entries_f peef

2468: -- Get the End date of the recurring element.
2469: cursor c_get_entry_end_date(c_element_entry_id number
2470: ,c_assignment_id number) is
2471: select max(peef.effective_end_date)
2472: from pay_element_entries_f peef
2473: where peef.element_entry_id = c_element_entry_id
2474: and peef.assignment_id = c_assignment_id;
2475:
2476: ln_business_group_id number;

Line 2547: from pay_element_entries_f

2543:
2544: -- Check if the element entry Exists
2545: cursor c_chk_elem_entry_exists(c_element_entry_id number) is
2546: select 'Exist'
2547: from pay_element_entries_f
2548: where element_entry_id = c_element_entry_id;
2549:
2550: lv_exists varchar2(10);
2551: