APPS.HXC_RDB_ATT_SNAPSHOT dependencies on HXC_PAY_LATEST_DETAILS

Line 57: FROM hxc_pay_latest_details hld,

53: DECODE (TBB.DATE_TO, HR_GENERAL.end_of_time, nvl (tbb.measure,
54: TO_NUMBER (tbb.stop_time - tbb.start_time) * 24 ) ,
55: 0 ) measure,
56: hld.timecard_id
57: FROM hxc_pay_latest_details hld,
58: hxc_time_attribute_usages htau,
59: hxc_time_attributes hta,
60: hxc_bld_blk_info_types bld,
61: hxc_time_building_blocks tbb

Line 325: fnd_file.put_line (fnd_file.LOG,'STARTING WITH HXC_PAY_LATEST_DETAILS');

321: if l_pay_upg = 'Y' then
322:
323: if g_debug then
324: fnd_file.put_line (fnd_file.LOG,'******************************');
325: fnd_file.put_line (fnd_file.LOG,'STARTING WITH HXC_PAY_LATEST_DETAILS');
326: fnd_file.put_line (fnd_file.LOG,'******************************');
327: end if;
328:
329: OPEN get_pay_attribute_info;

Line 350: fnd_file.put_line (fnd_file.LOG,'Updating hxc_pay_latest_details');

346:
347: TIMECARD_ID_STATUS:= get_locked_timecards(TIMECARD_ID_TAB);
348:
349: if g_debug then
350: fnd_file.put_line (fnd_file.LOG,'Updating hxc_pay_latest_details');
351: fnd_file.put_line (fnd_file.LOG,'ROW_ID_TAB.COUNT ='||ROW_ID_TAB.COUNT);
352: end if;
353:
354:

Line 357: UPDATE hxc_pay_latest_details

353:
354:
355: begin
356: FORALL i in ROW_ID_TAB.first .. ROW_ID_TAB.last SAVE EXCEPTIONS
357: UPDATE hxc_pay_latest_details
358: SET ATTRIBUTE_CATEGORY = ATTRIBUTE_CATEGORY_TAB(i),
359: ATTRIBUTE1 = ATTRIBUTE1_TAB(i),
360: ATTRIBUTE2 = ATTRIBUTE2_TAB(i),
361: ATTRIBUTE3 = ATTRIBUTE3_TAB(i),