APPS.HXT_RETRIEVAL_ROLLBACK dependencies on HXT_BATCH_STATES

Line 1895: UPDATE hxt_batch_states

1891:
1892: put_log('Updated the batches back ');
1893: END IF;
1894:
1895: UPDATE hxt_batch_states
1896: SET status = 'H'
1897: WHERE batch_id = p_batch_id;
1898:
1899: put_log('Picking up replacement details ');

Line 2283: hxt_batch_states hbs

2279: l_sql VARCHAR2(4000) :=
2280: ' SELECT pbh.batch_id,
2281: pbh.batch_status
2282: FROM pay_batch_headers pbh,
2283: hxt_batch_states hbs
2284: WHERE pbh.business_group_id = :bg_id
2285: AND pbh.batch_id = hbs.batch_id
2286: AND hbs.status = ''VT''';
2287:

Line 2898: UPDATE hxt_batch_states

2894: END LOOP;
2895:
2896: END IF;
2897:
2898: UPDATE hxt_batch_states
2899: SET status = 'H'
2900: WHERE batch_id = p_batch_id;
2901:
2902: commit_session;

Line 2924: hxt_batch_states hbs

2920: l_sql VARCHAR2(4000) :=
2921: ' SELECT pbh.batch_id,
2922: pbh.batch_status
2923: FROM pay_batch_headers pbh,
2924: hxt_batch_states hbs
2925: WHERE pbh.business_group_id = :bg_id
2926: AND pbh.batch_id = hbs.batch_id
2927: AND hbs.status = ''VT''';
2928:

Line 3248: hxt_batch_states hbs

3244: CURSOR get_outstanding_details
3245: IS SELECT det.tim_id
3246: FROM hxt_timecards tim,
3247: hxt_det_hours_worked det,
3248: hxt_batch_states hbs
3249: WHERE tim.id = p_tim_id
3250: AND det.tim_id = tim.id
3251: AND hbs.batch_id = tim.batch_id
3252: AND hbs.status NOT IN ('VT')

Line 3480: hxt_batch_states hbs

3476: CURSOR get_outstanding_details
3477: IS SELECT det.tim_id
3478: FROM hxt_timecards tim,
3479: hxt_det_hours_worked det,
3480: hxt_batch_states hbs
3481: WHERE tim.id = p_tim_id
3482: AND det.tim_id = tim.id
3483: AND hbs.batch_id = tim.batch_id
3484: AND hbs.status NOT IN ('VT')