DBA Data[Home] [Help]

APPS.PAY_IN_FF_PKG dependencies on PER_TIME_PERIODS

Line 712: FROM per_time_periods TPERIOD,

708: SELECT decode(to_char(TPERIOD.end_date,'MM'),'04',1,'05',2,'06',3,
709: '07',4,'08',5,'09',6,
710: '10',7,'11',8,'12',9,
711: '01',10,'02',11,'03',12)
712: FROM per_time_periods TPERIOD,
713: per_time_period_types TPTYPE
714: WHERE TPERIOD.payroll_id = p_payroll_id
715: AND TPTYPE.period_type = TPERIOD.period_type
716: AND p_term_date between TPERIOD.start_date and TPERIOD.end_date;