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_NL_GENERAL dependencies on PAY_ELEMENT_ENTRIES_F

Line 274: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

270: ---------------------------------------------------------------------------
271:
272: function get_retro_period
273: (
274: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
275: p_date_earned in pay_payroll_actions.date_earned%TYPE
276: )return date is
277:
278: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

Line 278: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

274: p_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
275: p_date_earned in pay_payroll_actions.date_earned%TYPE
276: )return date is
277:
278: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
279: c_date_earned in pay_payroll_actions.date_earned%TYPE
280: ) is
281: SELECT creator_type
282: FROM pay_element_entries_f pee

Line 282: FROM pay_element_entries_f pee

278: cursor c_get_creator_type(c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
279: c_date_earned in pay_payroll_actions.date_earned%TYPE
280: ) is
281: SELECT creator_type
282: FROM pay_element_entries_f pee
283: WHERE pee.element_entry_id=c_element_entry_id
284: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
285:
286: cursor get_retro_period_rr

Line 287: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

283: WHERE pee.element_entry_id=c_element_entry_id
284: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
285:
286: cursor get_retro_period_rr
287: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
288: c_date_earned in pay_payroll_actions.date_earned%TYPE
289: ) is
290:
291: SELECT ptp.start_date

Line 296: pay_element_entries_f pee

292: FROM per_time_periods ptp,
293: pay_payroll_actions ppa,
294: pay_assignment_actions paa,
295: pay_run_results prr,
296: pay_element_entries_f pee
297: WHERE pee.element_entry_id=c_element_entry_id
298: and prr.run_result_id = pee.source_id
299: and paa.assignment_action_id=prr.assignment_action_id
300: and ppa.payroll_action_id=paa.payroll_action_id

Line 307: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

303: and ppa.date_earned between ptp.start_date and ptp.end_date
304: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
305:
306: cursor get_retro_period_nr
307: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
308: c_date_earned in pay_payroll_actions.date_earned%TYPE
309: ) is
310:
311: SELECT ptp.start_date

Line 316: pay_element_entries_f pee

312: FROM per_time_periods ptp,
313: pay_payroll_actions ppa,
314: pay_assignment_actions paa,
315: pay_run_results prr,
316: pay_element_entries_f pee
317: WHERE pee.element_entry_id=c_element_entry_id
318: and prr.run_result_id = pee.source_id
319: and paa.assignment_action_id=prr.assignment_action_id
320: and ppa.payroll_action_id=paa.payroll_action_id

Line 327: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

323: and ppa.date_earned between ptp.start_date and ptp.end_date
324: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
325:
326: cursor get_retro_period_pr
327: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
328: c_date_earned in pay_payroll_actions.date_earned%TYPE
329: ) is
330:
331: SELECT ptp.start_date

Line 336: pay_element_entries_f pee

332: FROM per_time_periods ptp,
333: pay_payroll_actions ppa,
334: pay_assignment_actions paa,
335: pay_run_results prr,
336: pay_element_entries_f pee
337: WHERE pee.element_entry_id=c_element_entry_id
338: and prr.run_result_id = pee.source_id
339: and paa.assignment_action_id=prr.assignment_action_id
340: and ppa.payroll_action_id=paa.payroll_action_id

Line 347: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,

343: and ppa.date_earned between ptp.start_date and ptp.end_date
344: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
345:
346: cursor get_retro_period_ee
347: ( c_element_entry_id in pay_element_entries_f.element_entry_id%TYPE,
348: c_date_earned in pay_payroll_actions.date_earned%TYPE
349: ) is
350: SELECT ptp.start_date
351: FROM per_time_periods ptp,

Line 354: pay_element_entries_f pee

350: SELECT ptp.start_date
351: FROM per_time_periods ptp,
352: pay_payroll_actions ppa,
353: pay_assignment_actions paa,
354: pay_element_entries_f pee
355: WHERE pee.element_entry_id=c_element_entry_id
356: and paa.assignment_action_id=pee.source_asg_action_id
357: and ppa.payroll_action_id=paa.payroll_action_id
358: and ptp.payroll_id=ppa.payroll_id

Line 363: l_creator_type pay_element_entries_f.creator_type%TYPE;

359: and pee.creator_type='EE'
360: and ppa.date_earned between ptp.start_date and ptp.end_date
361: and c_date_earned between pee.effective_start_date and pee.effective_end_date;
362:
363: l_creator_type pay_element_entries_f.creator_type%TYPE;
364: l_period_obtained_flag number;
365: l_retro_date date;
366:
367:

Line 1880: ,pay_element_entries_f peef

1876: SELECT 'Y'
1877: FROM dual
1878: WHERE exists (SELECT 1
1879: FROM pay_object_groups pog
1880: ,pay_element_entries_f peef
1881: ,pay_element_types_f petf
1882: WHERE pog.parent_object_group_id = c_parent_id
1883: AND peef.assignment_id = pog.source_id
1884: AND peef.element_type_id = petf.element_type_id

Line 2065: ,pay_element_entries_f peef

2061: SELECT 'Y'
2062: FROM dual
2063: WHERE exists (SELECT 1
2064: FROM pay_object_groups pog
2065: ,pay_element_entries_f peef
2066: ,pay_element_types_f petf
2067: WHERE pog.parent_object_group_id = c_parent_id
2068: AND peef.assignment_id = pog.source_id
2069: AND peef.element_type_id = petf.element_type_id

Line 2295: FROM pay_element_entries_f peef

2291: ,c_eff_date DATE) IS
2292: SELECT 'Y'
2293: FROM dual
2294: WHERE exists (SELECT 1
2295: FROM pay_element_entries_f peef
2296: ,pay_element_types_f petf
2297: WHERE peef.assignment_id = c_ass_id
2298: AND peef.element_type_id = petf.element_type_id
2299: AND petf.element_name = 'Late Hire Indicator'

Line 2533: FROM pay_element_entries_f peef

2529: ,c_eff_date DATE) IS
2530: SELECT 'Y'
2531: FROM dual
2532: WHERE exists (SELECT 1
2533: FROM pay_element_entries_f peef
2534: ,pay_element_types_f petf
2535: WHERE peef.assignment_id = c_ass_id
2536: AND peef.element_type_id = petf.element_type_id
2537: AND petf.element_name = 'Late Hire Indicator'

Line 2689: pay_element_entries_f peef,

2685: CURSOR c_valid_entries(p_retro_assignment_id number)
2686: IS
2687: select pre.* from
2688: pay_retro_entries pre,
2689: pay_element_entries_f peef,
2690: PAY_RETRO_COMPONENTS prc
2691: where
2692: pre.retro_assignment_id = p_retro_assignment_id
2693: and pre.element_entry_id = peef.element_entry_id

Line 2756: pay_element_entries_f peef,

2752: select 1
2753: from
2754: pay_retro_assignments pra,
2755: pay_retro_entries pre,
2756: pay_element_entries_f peef,
2757: pay_element_types_f petf,
2758: pay_retro_components prc
2759: where
2760: pra.RETRO_ASSIGNMENT_ID = pre.RETRO_ASSIGNMENT_ID