DBA Data[Home] [Help]

APPS.PSP_VALID_NON_ORCL_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 786: from psp_element_types a, pay_element_types_f b, per_time_periods c

782: for Bug 2916848 Ilo Enhancement
783:
784: Select a.element_type_id
785: into v_local_number
786: from psp_element_types a, pay_element_types_f b, per_time_periods c
787: where a.element_type_id = b.element_type_id
788: and a.element_type_id = v_Element_Type_ID
789: and c.time_period_id = v_payroll_period_id
790: and ((c.start_date between a.start_date_active and a.end_date_active)

Line 811: FROM PAY_ELEMENT_TYPES_F pef

807: AND b.start_date <= a.end_date_active
808: AND b.end_date >= a.start_date_active
809: AND exists
810: (SELECT 1
811: FROM PAY_ELEMENT_TYPES_F pef
812: WHERE pef.element_type_id = a.element_type_id
813: AND ( pef.output_currency_code = v_currency_code
814: OR v_currency_code = 'STAT')
815: AND pef.effective_end_date >= a.start_date_active