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

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

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

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