DBA Data[Home] [Help]

APPS.PSP_VALID_NON_ORCL_PKG dependencies on PAY_ELEMENT_TYPES_F

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

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

Line 808: FROM PAY_ELEMENT_TYPES_F pef

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