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 12: TYPE g_element_link_id_typ IS TABLE OF pay_element_entries_f.element_link_id%TYPE

8: g_ee_contributions constant pay_input_values_f.name%type := 'EE Contr';
9: g_er_contributions constant pay_input_values_f.name%type := 'ER Contr';
10:
11: -- private package global vars for element entry type cache
12: TYPE g_element_link_id_typ IS TABLE OF pay_element_entries_f.element_link_id%TYPE
13: INDEX BY BINARY_INTEGER;
14: TYPE g_binary_integer_typ IS TABLE OF BINARY_INTEGER INDEX BY BINARY_INTEGER;
15: TYPE g_entry_type_typ IS TABLE OF pay_element_entries_f.entry_type%TYPE
16: INDEX BY BINARY_INTEGER;

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

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

Line 261: pay_element_entries_f pee

257: --
258: cursor nonrecurring_entries (adjust_ee_source in varchar2) is
259: select 'Y'
260: from pay_run_results prr,
261: pay_element_entries_f pee
262: where pee.element_entry_id = p_element_entry_id
263: and p_effective_date between pee.effective_start_date
264: and pee.effective_end_date
265: and prr.source_id = decode(pee.entry_type,

Line 289: from pay_element_entries_f oee,

285: -- Retropay by Element Entry for unprocessed nonrecurring entry
286: --
287: cursor nonrecurring_retro_entry is
288: select 'Y'
289: from pay_element_entries_f oee,
290: pay_element_entries_f ree
291: where oee.element_entry_id = p_element_entry_id
292: and p_effective_date between oee.effective_start_date
293: and oee.effective_end_date

Line 290: pay_element_entries_f ree

286: --
287: cursor nonrecurring_retro_entry is
288: select 'Y'
289: from pay_element_entries_f oee,
290: pay_element_entries_f ree
291: where oee.element_entry_id = p_element_entry_id
292: and p_effective_date between oee.effective_start_date
293: and oee.effective_end_date
294: and ree.assignment_id = oee.assignment_id

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

323: --
324: -- Retropay by Element Entry for unprocessed recurring entry
325: --
326: cursor recurring_retro_entry is
327: select /*+ ORDERED INDEX(ree PAY_ELEMENT_ENTRIES_F_N50)*/
328: 'Y'
329: from pay_element_entries_f oee,
330: pay_element_entries_f ree,
331: pay_assignment_actions paa,

Line 329: from pay_element_entries_f oee,

325: --
326: cursor recurring_retro_entry is
327: select /*+ ORDERED INDEX(ree PAY_ELEMENT_ENTRIES_F_N50)*/
328: 'Y'
329: from pay_element_entries_f oee,
330: pay_element_entries_f ree,
331: pay_assignment_actions paa,
332: pay_payroll_actions pac,
333: per_time_periods period

Line 330: pay_element_entries_f ree,

326: cursor recurring_retro_entry is
327: select /*+ ORDERED INDEX(ree PAY_ELEMENT_ENTRIES_F_N50)*/
328: 'Y'
329: from pay_element_entries_f oee,
330: pay_element_entries_f ree,
331: pay_assignment_actions paa,
332: pay_payroll_actions pac,
333: per_time_periods period
334: where oee.element_entry_id = p_element_entry_id

Line 360: pay_element_entries_f pee

356: into adjust_ee_source
357: from pay_legislation_rules plr,
358: per_business_groups pbg,
359: per_assignments_f paf,
360: pay_element_entries_f pee
361: where pee.element_entry_id = p_element_entry_id
362: and p_effective_date between pee.effective_start_date
363: and pee.effective_end_date
364: and paf.assignment_id = pee.assignment_id

Line 427: FROM pay_element_entries_f pee

423: CURSOR csr_entry is
424: SELECT DISTINCT
425: pee.element_link_id,
426: pee.entry_type
427: FROM pay_element_entries_f pee
428: WHERE pee.assignment_id = p_assignment_id
429: AND p_effective_date
430: BETWEEN pee.effective_start_date and pee.effective_end_date
431: ORDER BY 1,2;

Line 603: -- , pay_element_entries_f ent

599: );
600: -- select 'Y'
601: -- from pay_element_types_f ety
602: -- , pay_element_links_f elk
603: -- , pay_element_entries_f ent
604: -- , pay_payroll_actions pya
605: -- , pay_assignment_actions asa
606: -- where p_use_qpay_excl_model = 'Y'
607: -- /*

Line 885: from pay_element_entries_f peef,

881: l_creator_type varchar2(10);
882: --
883: cursor csr_original_entry is
884: select peef.element_entry_id, peef.creator_type
885: from pay_element_entries_f peef,
886: pay_element_links_f pelf,
887: pay_element_types_f petf
888: where petf.element_type_id = p_element_type_id
889: and pelf.element_type_id = petf.element_type_id