APPS.PAY_NL_GENERAL dependencies on PAY_RETRO_COMPONENTS

Line 2690: PAY_RETRO_COMPONENTS prc

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
2694: and pre.reprocess_date between peef.effective_start_date and peef.effective_end_date

Line 2709: PAY_RETRO_COMPONENTS prc1

2705: AND (pet.element_name like '%ABP%' OR pet.element_name like '%PGGM%')
2706: AND EXISTS
2707: ( select 1 from
2708: pay_retro_component_usages prcu,
2709: PAY_RETRO_COMPONENTS prc1
2710: where
2711: prcu.creator_id = pet.element_type_id
2712: AND prcu.business_group_id IS NULL
2713: AND prcu.legislation_code = prc1.legislation_code

Line 2742: PAY_RETRO_COMPONENTS

2738: CURSOR c_corr_adj_component(p_component_name VARCHAR2)
2739: IS
2740: SELECT retro_component_id
2741: FROM
2742: PAY_RETRO_COMPONENTS
2743: WHERE component_name = p_component_name
2744: AND legislation_code = 'NL';
2745:
2746: l_corr_component_id number;

Line 2758: pay_retro_components prc

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
2761: and peef.ELEMENT_ENTRY_ID = pre.ELEMENT_ENTRY_ID
2762: and pre.reprocess_date between peef.effective_start_date and peef.effective_end_date

Line 2793: PAY_RETRO_COMPONENTS prc1

2789: AND (pet.element_name like '%ABP%' OR pet.element_name like '%PGGM%')
2790: AND EXISTS
2791: ( select 1 from
2792: pay_retro_component_usages prcu,
2793: PAY_RETRO_COMPONENTS prc1
2794: where
2795: prcu.creator_id = pet.element_type_id
2796: AND prcu.business_group_id IS NULL
2797: AND prcu.legislation_code = prc1.legislation_code