APPS.HXT_RETRIEVAL_ROLLBACK dependencies on HXT_TIMECARDS_F

Line 447: AND timecard_type = 'HXT_TIMECARDS_F';

443: CURSOR get_rollback_eligibility(p_timecard_id IN NUMBER)
444: IS SELECT timecard_id
445: FROM hxc_rollback_timecards_all
446: WHERE timecard_id = p_timecard_id
447: AND timecard_type = 'HXT_TIMECARDS_F';
448:
449: l_id NUMBER;
450:
451:

Line 480: FROM hxt_timecards_f

476: IS
477:
478: CURSOR get_data_set_id(p_timecard_id NUMBER)
479: IS SELECT data_set_id
480: FROM hxt_timecards_f
481: WHERE id = p_timecard_id;
482:
483: l_data_set_id NUMBER;
484:

Line 1839: FROM hxt_timecards_f tim,

1835: IS
1836:
1837: CURSOR get_row
1838: IS SELECT ROWIDTOCHAR(tim.ROWID)
1839: FROM hxt_timecards_f tim,
1840: FND_sessions sess
1841: WHERE id = p_tim_id
1842: AND session_id = USERENV('SESSIONID')
1843: AND effective_date BETWEEN effective_start_date

Line 1856: UPDATE hxt_timecards_f

1852: FETCH get_row INTO l_rowid;
1853: CLOSE get_row;
1854:
1855:
1856: UPDATE hxt_timecards_f
1857: SET batch_id = p_batch_id
1858: WHERE ROWID = CHARTOROWID(l_rowid);
1859:
1860:

Line 1938: FROM hxt_timecards_f tim,

1934:
1935: CURSOR check_retro_batches(p_batch_id IN NUMBER)
1936: IS SELECT retro_batch_id,
1937: tim_id
1938: FROM hxt_timecards_f tim,
1939: hxt_det_hours_worked_f det
1940: WHERE tim.batch_id = p_batch_id
1941: AND tim.id = det.tim_id;
1942:

Line 1962: FROM hxt_timecards_f tim,

1958: CURSOR check_retro_batches_person(p_person_id IN NUMBER,
1959: p_batch_id IN NUMBER)
1960: IS SELECT retro_batch_id,
1961: tim_id
1962: FROM hxt_timecards_f tim,
1963: hxt_det_hours_worked_f det
1964: WHERE tim.batch_id = p_batch_id
1965: AND tim.id = det.tim_id
1966: AND tim.for_person_id = p_person_id;

Line 3230: DELETE FROM hxt_timecards_f

3226:
3227: DELETE FROM hxt_sum_hours_worked_f
3228: WHERE tim_id = p_tim_id;
3229:
3230: DELETE FROM hxt_timecards_f
3231: WHERE id = p_tim_id;
3232:
3233: put_log('All Details for this timecard are deleted from OTM',g_cache);
3234:

Line 3884: FROM hxt_timecards_f tim,

3880:
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

Line 3894: FROM hxt_timecards_f tim,

3890:
3891:
3892: l_asg_sql VARCHAR2(400) :=
3893: 'SELECT id
3894: FROM hxt_timecards_f tim,
3895: per_all_assignments_f
3896: WHERE payroll_id = :payroll_id
3897: AND time_period_id = :period_id';
3898: