DBA Data[Home] [Help]

APPS.PAY_IN_UTILS dependencies on PER_TIME_PERIODS

Line 2782: update per_time_periods

2778:
2779: pay_in_utils.set_location(g_debug,'Inside: '||l_procedure, 30);
2780:
2781: if l_date_offset =0 then
2782: update per_time_periods
2783: set PERIOD_NAME= decode(to_char(end_date,'MM'),'03',1,'04',2,'05',3,'06',4,'07',5,'08',6,'09',7,'10',8,'11',9,'12',10,'01',11,'02',12)||' '||to_char(end_date,'YYYY')||' Calendar Month',
2784: PERIOD_NUM=decode(to_char(end_date,'MM'),'03',1,'04',2,'05',3,'06',4,'07',5,'08',6,'09',7,'10',8,'11',9,'12',10,'01',11,'02',12),
2785: REGULAR_PAYMENT_DATE=decode(to_char(end_date,'MM'),'03',end_date + p_offset,end_date)
2786: where PAYROLL_ID=p_payroll_id;