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 148: from pay_element_entries_f peef

144: select petf.element_name
145: ,petf.business_group_id
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

Line 287: pay_element_entries_f peef,

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

Line 302: pay_element_entries_f peef,

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

Line 350: from pay_element_entries_f peef

346: ,c_effective_start_date date) is
347: select petf.element_name
348: ,petf.business_group_id
349: ,petf.processing_type
350: from pay_element_entries_f peef
351: ,pay_element_types_f petf
352: ,pay_status_processing_rules_f psprf
353: ,ff_formulas_f fff
354: where peef.element_entry_id = c_element_entry_id

Line 413: from pay_element_entries_f peef

409: cursor c_get_ele_entry_id(c_element_entry_id varchar2
410: ,c_assignment_id number) is
411: select max(peef.element_entry_id)
412: ,min(peef.effective_start_date)
413: from pay_element_entries_f peef
414: where peef.creator_id = c_element_entry_id
415: and peef.assignment_id = c_assignment_id
416: and peef.creator_type = 'FL'
417: group by peef.element_entry_id

Line 1052: ,pay_element_entries_f peef

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

Line 1352: from pay_element_entries_f peef

1348: ,per_time_periods ptpt
1349: where paf.assignment_id = c_assignment_id
1350: and ptpp.payroll_id = paf.payroll_id
1351: and ptpp.start_date <= (select max(peef.effective_end_date)
1352: from pay_element_entries_f peef
1353: where peef.element_entry_id = c_element_entry_id)
1354: and ptpp.end_date >= (select max(peef.effective_end_date)
1355: from pay_element_entries_f peef
1356: where peef.element_entry_id = c_element_entry_id)

Line 1355: from pay_element_entries_f peef

1351: and ptpp.start_date <= (select max(peef.effective_end_date)
1352: from pay_element_entries_f peef
1353: where peef.element_entry_id = c_element_entry_id)
1354: and ptpp.end_date >= (select max(peef.effective_end_date)
1355: from pay_element_entries_f peef
1356: where peef.element_entry_id = c_element_entry_id)
1357: and ptpt.time_definition_id = c_time_def_id
1358: and ptpp.end_date between ptpt.start_date
1359: and ptpt.end_date

Line 1374: from pay_element_entries_f peef,

1370:
1371: cursor c_get_rate_entry_count(c_element_entry_id number
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

Line 1500: FROM pay_element_entries_f

1496: -- Get date_earned of element_entry
1497: CURSOR c_get_date_earned(c_element_entry_id number
1498: ) IS
1499: SELECT date_earned
1500: FROM pay_element_entries_f
1501: WHERE element_entry_id = c_element_entry_id;
1502:
1503: -- Get the screen entry value
1504: cursor c_get_scr_entry_value(c_element_entry_id number,

Line 1509: ,pay_element_entries_f peef

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

Line 1823: update pay_element_entries_f

1819: * set as it requires that the Orignal Entry ID be a recurring
1820: * Element. In our case we can have the Original Entry ID to
1821: * be Non-Recurring.
1822: */
1823: update pay_element_entries_f
1824: set original_entry_id = p_element_entry_id
1825: where element_entry_id = ln_element_entry_id;
1826: end loop; -- for lvr in 1..
1827: end if; -- if lb_mop_up_flag

Line 1919: from pay_element_entries_f peef,

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

Line 1939: from pay_element_entries_f peef

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

Line 2192: from pay_element_entries_f peef,

2188:
2189: cursor c_get_rate_entry_count(c_element_entry_id number
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

Line 2211: from pay_element_entries_f peef

2207:
2208: cursor c_check_mop_up_exists(c_element_entry_id number
2209: ,c_assignment_id number) is
2210: select 'Exist'
2211: from pay_element_entries_f peef
2212: where peef.creator_id = c_element_entry_id
2213: and peef.assignment_id = c_assignment_id
2214: and peef.creator_type = 'FL';
2215:

Line 2221: from pay_element_entries_f peef

2217: cursor c_get_entry_end_date(c_element_entry_id number
2218: ,c_assignment_id number) is
2219: select nvl(max(peef.effective_end_date),
2220: fnd_date.canonical_to_date('4712/12/31'))
2221: from pay_element_entries_f peef
2222: where peef.element_entry_id = c_element_entry_id
2223: and peef.assignment_id = c_assignment_id;
2224:
2225: -- Get date_earned of element_entry

Line 2229: FROM pay_element_entries_f

2225: -- Get date_earned of element_entry
2226: CURSOR c_get_date_earned(c_element_entry_id number
2227: ) IS
2228: SELECT date_earned
2229: FROM pay_element_entries_f
2230: WHERE element_entry_id = c_element_entry_id;
2231:
2232: -- Get dates in which mop-up should exist of element_entry
2233: cursor c_get_nrec_mop_up_dates(c_assignment_id NUMBER

Line 2266: ,pay_element_entries_f peef

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

Line 2286: from pay_element_entries_f peef

2282: ,c_assignment_id number) is
2283: select distinct
2284: peef.element_entry_id
2285: ,peef.effective_start_date
2286: from pay_element_entries_f peef
2287: where peef.creator_id = c_element_entry_id
2288: and peef.assignment_id = c_assignment_id
2289: and peef.creator_type = 'FL'
2290: order by peef.effective_start_date;

Line 2570: from pay_element_entries_f peef

2566: -- Get the End date of the recurring element.
2567: cursor c_get_entry_end_date(c_element_entry_id number
2568: ,c_assignment_id number) is
2569: select max(peef.effective_end_date)
2570: from pay_element_entries_f peef
2571: where peef.element_entry_id = c_element_entry_id
2572: and peef.assignment_id = c_assignment_id;
2573:
2574: ln_business_group_id number;

Line 2645: from pay_element_entries_f

2641:
2642: -- Check if the element entry Exists
2643: cursor c_chk_elem_entry_exists(c_element_entry_id number) is
2644: select 'Exist'
2645: from pay_element_entries_f
2646: where element_entry_id = c_element_entry_id;
2647:
2648: lv_exists varchar2(10);
2649: