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 557: from pay_element_entries_f pee

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

Line 572: FROM pay_element_entries_f pee

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

Line 604: pay_element_entries_f.element_entry_id%type

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

Line 607: pay_element_entries_f.element_type_id%type

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