eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PSP_VALID_NON_ORCL_PKG dependencies on PSP_ELEMENT_TYPES

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 800: FROM PSP_ELEMENT_TYPES a,

796: /* Introduced the following check for element_type_id for Bug 2916848 Ilo Enhancement */
797:
798: SELECT a.element_type_id
799: INTO v_local_number
800: FROM PSP_ELEMENT_TYPES a,
801: PER_TIME_PERIODS b
802: WHERE a.element_type_id = v_element_type_id
803: AND b.time_period_id = v_payroll_period_id
804: -- Introduced BG/SOB check on psp_element_types for bug fix 3098050

Line 804: -- Introduced BG/SOB check on psp_element_types for bug fix 3098050

800: FROM PSP_ELEMENT_TYPES a,
801: PER_TIME_PERIODS b
802: WHERE a.element_type_id = v_element_type_id
803: AND b.time_period_id = v_payroll_period_id
804: -- Introduced BG/SOB check on psp_element_types for bug fix 3098050
805: AND a.business_group_id = v_business_group_id
806: AND a.set_of_books_id = v_set_of_books_id
807: AND b.start_date <= a.end_date_active
808: AND b.end_date >= a.start_date_active