APPS.PAY_RETRO_NOTIF_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 311: , pay_element_entries_f pef

307: SELECT petTL.element_name element
308: FROM pay_element_types_f_tl petTL
309: , pay_element_types_f pet
310: , pay_element_links_f pel
311: , pay_element_entries_f pef
312: WHERE pef.element_entry_id = p_element_entry_id
313: AND pef.element_link_id = pel.element_link_id
314: AND pel.business_group_id = p_business_group_id
315: AND pel.element_type_id = pet.element_type_id

Line 411: from pay_element_entries_f pee

407: AND (ppa.date_earned BETWEEN p_min AND p_max
408: OR ppa.effective_date BETWEEN p_min AND p_max)
409: /* Make sure that the Entry is not a Retropay Entry */
410: AND NOT EXISTS (select ''
411: from pay_element_entries_f pee
412: where pee.element_entry_id = prr.source_id
413: and nvl(pee.creator_type, 'F') in ('EE', 'RR', 'PR', 'NR')
414: )
415: UNION

Line 423: FROM pay_element_entries_f pee

419: USE_NL(PDE PAF)*/
420: DISTINCT
421: pee.element_entry_id entry,
422: pde.datetracked_event_id
423: FROM pay_element_entries_f pee
424: , pay_datetracked_events pde
425: WHERE pee.assignment_id = p_asg
426: AND pde.event_group_id = p_event_group_id
427: /* Make sure that the Entry is not a Retropay Entry */

Line 482: from pay_element_entries_f pee

478: AND ppa.action_type in ('R', 'Q', 'B', 'V')
479: AND ppa.date_earned IS NOT NULL
480: /* Make sure that the Entry is not a Retropay Entry */
481: AND NOT EXISTS (select ''
482: from pay_element_entries_f pee
483: where pee.element_entry_id = prr.source_id
484: and nvl(pee.creator_type, 'F') in ('EE', 'RR', 'PR', 'NR')
485: )
486: AND (ppa.date_earned BETWEEN cp_min_ed AND cp_max_ed

Line 496: FROM pay_element_entries_f pee

492: pee.element_entry_id entry,
493: pee.element_type_id type,
494: pde.datetracked_event_id,
495: p_event_group_id
496: FROM pay_element_entries_f pee
497: , pay_datetracked_events pde
498: WHERE pee.assignment_id = cp_asg
499: -- Only bring back a row if an event group is
500: -- supplied to the process or a recalc one

Line 559: from pay_element_entries_f pee

555: AND ppa.action_type in ('R', 'Q', 'B', 'V')
556: AND ppa.date_earned IS NOT NULL
557: /* Make sure that the Entry is not a Retropay Entry */
558: AND NOT EXISTS (select ''
559: from pay_element_entries_f pee
560: where pee.element_entry_id = prr.source_id
561: and nvl(pee.creator_type, 'F') in ('EE', 'RR', 'PR', 'NR')
562: )
563: AND (ppa.date_earned BETWEEN cp_min_ed AND cp_max_ed

Line 574: FROM pay_element_entries_f pee

570: pee.element_entry_id entry,
571: pet.element_type_id type,
572: pde.datetracked_event_id,
573: nvl(pet.recalc_event_group_id, -1) event_group_id
574: FROM pay_element_entries_f pee
575: , pay_element_types_f pet
576: , pay_datetracked_events pde
577: WHERE pee.assignment_id = cp_asg
578: AND pee.element_type_id = pet.element_type_id

Line 606: pay_element_entries_f.element_entry_id%type

602: )
603: ORDER BY 1, 2;
604: --
605: type t_element_entry_id is table of
606: pay_element_entries_f.element_entry_id%type
607: index by binary_integer;
608: type t_element_type_id is table of
609: pay_element_entries_f.element_type_id%type
610: index by binary_integer;

Line 609: pay_element_entries_f.element_type_id%type

605: type t_element_entry_id is table of
606: pay_element_entries_f.element_entry_id%type
607: index by binary_integer;
608: type t_element_type_id is table of
609: pay_element_entries_f.element_type_id%type
610: index by binary_integer;
611: type t_datetracked_evt_id is table of
612: pay_datetracked_events.datetracked_event_id%type
613: index by binary_integer;