DBA Data[Home] [Help]

APPS.PAY_IN_FF_PKG dependencies on PER_TIME_PERIODS

Line 718: FROM per_time_periods TPERIOD,

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