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

Line 14: TYPE g_element_link_id_typ IS TABLE OF pay_element_entries_f.element_link_id%TYPE

10:
11: lv_release_name constant varchar2(10) := fnd_release.release_name;
12:
13: -- private package global vars for element entry type cache
14: TYPE g_element_link_id_typ IS TABLE OF pay_element_entries_f.element_link_id%TYPE
15: INDEX BY BINARY_INTEGER;
16: TYPE g_binary_integer_typ IS TABLE OF BINARY_INTEGER INDEX BY BINARY_INTEGER;
17: TYPE g_entry_type_typ IS TABLE OF pay_element_entries_f.entry_type%TYPE
18: INDEX BY BINARY_INTEGER;

Line 17: TYPE g_entry_type_typ IS TABLE OF pay_element_entries_f.entry_type%TYPE

13: -- private package global vars for element entry type cache
14: TYPE g_element_link_id_typ IS TABLE OF pay_element_entries_f.element_link_id%TYPE
15: INDEX BY BINARY_INTEGER;
16: TYPE g_binary_integer_typ IS TABLE OF BINARY_INTEGER INDEX BY BINARY_INTEGER;
17: TYPE g_entry_type_typ IS TABLE OF pay_element_entries_f.entry_type%TYPE
18: INDEX BY BINARY_INTEGER;
19: g_element_link_id_tab g_element_link_id_typ;
20: g_entry_type_start_tab g_binary_integer_typ;
21: g_entry_type_stop_tab g_binary_integer_typ;

Line 278: pay_element_entries_f pee

274: --
275: cursor nonrecurring_entries (adjust_ee_source in varchar2) is
276: select 'Y'
277: from pay_run_results prr,
278: pay_element_entries_f pee
279: where pee.element_entry_id = p_element_entry_id
280: and p_effective_date between pee.effective_start_date
281: and pee.effective_end_date
282: and prr.source_id = decode(pee.entry_type,

Line 306: from pay_element_entries_f oee,

302: -- Retropay by Element Entry for unprocessed nonrecurring entry
303: --
304: cursor nonrecurring_retro_entry is
305: select 'Y'
306: from pay_element_entries_f oee,
307: pay_element_entries_f ree
308: where oee.element_entry_id = p_element_entry_id
309: and p_effective_date between oee.effective_start_date
310: and oee.effective_end_date

Line 307: pay_element_entries_f ree

303: --
304: cursor nonrecurring_retro_entry is
305: select 'Y'
306: from pay_element_entries_f oee,
307: pay_element_entries_f ree
308: where oee.element_entry_id = p_element_entry_id
309: and p_effective_date between oee.effective_start_date
310: and oee.effective_end_date
311: and ree.assignment_id = oee.assignment_id

Line 345: select /+ ORDERED INDEX(ree PAY_ELEMENT_ENTRIES_F_N50)/

341: -- Retropay by Element Entry for unprocessed recurring entry
342: --
343: -- Bug 11872475 Added entry_type 'E' to display recurring entry as processed after Retropay.
344: cursor recurring_retro_entry is
345: select /*+ ORDERED INDEX(ree PAY_ELEMENT_ENTRIES_F_N50)*/
346: 'Y'
347: from pay_element_entries_f oee,
348: pay_element_entries_f ree,
349: pay_assignment_actions paa,

Line 347: from pay_element_entries_f oee,

343: -- Bug 11872475 Added entry_type 'E' to display recurring entry as processed after Retropay.
344: cursor recurring_retro_entry is
345: select /*+ ORDERED INDEX(ree PAY_ELEMENT_ENTRIES_F_N50)*/
346: 'Y'
347: from pay_element_entries_f oee,
348: pay_element_entries_f ree,
349: pay_assignment_actions paa,
350: pay_payroll_actions pac,
351: per_time_periods period

Line 348: pay_element_entries_f ree,

344: cursor recurring_retro_entry is
345: select /*+ ORDERED INDEX(ree PAY_ELEMENT_ENTRIES_F_N50)*/
346: 'Y'
347: from pay_element_entries_f oee,
348: pay_element_entries_f ree,
349: pay_assignment_actions paa,
350: pay_payroll_actions pac,
351: per_time_periods period
352: where oee.element_entry_id = p_element_entry_id

Line 379: pay_element_entries_f pee

375: into adjust_ee_source
376: from pay_legislation_rules plr,
377: per_business_groups pbg,
378: per_assignments_f paf,
379: pay_element_entries_f pee
380: where pee.element_entry_id = p_element_entry_id
381: and p_effective_date between pee.effective_start_date
382: and pee.effective_end_date
383: and paf.assignment_id = pee.assignment_id

Line 451: FROM pay_element_entries_f pee

447: CURSOR csr_entry is
448: SELECT DISTINCT
449: pee.element_link_id,
450: pee.entry_type
451: FROM pay_element_entries_f pee
452: WHERE pee.assignment_id = p_assignment_id
453: AND p_effective_date
454: BETWEEN pee.effective_start_date and pee.effective_end_date
455: ORDER BY 1,2;

Line 627: -- , pay_element_entries_f ent

623: );
624: -- select 'Y'
625: -- from pay_element_types_f ety
626: -- , pay_element_links_f elk
627: -- , pay_element_entries_f ent
628: -- , pay_payroll_actions pya
629: -- , pay_assignment_actions asa
630: -- where p_use_qpay_excl_model = 'Y'
631: -- /*

Line 909: from pay_element_entries_f peef,

905: l_creator_type varchar2(10);
906: --
907: cursor csr_original_entry is
908: select peef.element_entry_id, peef.creator_type
909: from pay_element_entries_f peef,
910: pay_element_links_f pelf,
911: pay_element_types_f petf
912: where petf.element_type_id = p_element_type_id
913: and pelf.element_type_id = petf.element_type_id