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.

APPS.PSP_VALID_NON_ORCL_PKG dependencies on PER_TIME_PERIODS

Line 437: from PER_TIME_PERIODS a

433:
434: Begin
435: select a.Start_Date, a.End_Date
436: into Time_Period_Start_Date, Time_Period_End_Date
437: from PER_TIME_PERIODS a
438: where a.Time_Period_ID = v_Payroll_Period_ID
439: and a.PAYROLL_ID = v_Payroll_ID
440: and (v_Effective_Date BETWEEN a.Start_Date AND a.End_Date);
441:

Line 521: From Per_Time_Periods

517: End If;
518:
519: Select Time_Period_id
520: into v_local_number
521: From Per_Time_Periods
522: where Payroll_id = v_Payroll_ID
523: and Time_Period_ID = v_Payroll_Period_ID
524: and (v_Effective_Date between start_date and end_date);
525:

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 801: PER_TIME_PERIODS b

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
805: AND a.business_group_id = v_business_group_id