APPS.HXT_RETRIEVAL_ROLLBACK dependencies on PER_TIME_PERIODS

Line 281: from per_time_periods

277: CURSOR get_period_details
278: IS select 'Period Name: '||period_name
279: ||' Start: '||TO_CHAR(start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
280: ||' End: '||TO_CHAR(end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))
281: from per_time_periods
282: where time_period_id = p_time_period_id;
283:
284: l_period_details VARCHAR2(240):= 'XXXX';
285:

Line 3885: per_time_periods ptp

3881:
3882: l_query VARCHAR2(4000) :=
3883: 'SELECT id,batch_id
3884: FROM hxt_timecards_f tim,
3885: per_time_periods ptp
3886: WHERE tim.payroll_id = :payroll_id
3887: AND tim.time_period_id = :period_id
3888: AND ptp.time_period_id = tim.time_period_id
3889: AND ptp.payroll_id = tim.payroll_id';