APPS.GME_BATCHSTEP_ACT_PVT dependencies on GME_BATCH_HEADER

Line 36: FROM gme_batch_header

32:
33: CURSOR cur_get_batch_dtl (v_organization_id NUMBER, v_batch_no VARCHAR2)
34: IS
35: SELECT batch_id, batch_status
36: FROM gme_batch_header
37: WHERE organization_id = v_organization_id AND batch_no = v_batch_no;
38:
39: CURSOR cur_get_batchstep_dtl (v_batch_id NUMBER, v_batchstep_no NUMBER)
40: IS

Line 228: FROM gme_batch_header

224:
225: CURSOR cur_get_batch_asqc (v_batch_id NUMBER)
226: IS
227: SELECT automatic_step_calculation
228: FROM gme_batch_header
229: WHERE batch_id = v_batch_id;
230:
231: CURSOR cur_check_fpo (v_step_id NUMBER)
232: IS

Line 234: FROM gme_batch_header b, gme_batch_steps s

230:
231: CURSOR cur_check_fpo (v_step_id NUMBER)
232: IS
233: SELECT batch_type
234: FROM gme_batch_header b, gme_batch_steps s
235: WHERE b.batch_id = s.batch_id AND batchstep_id = v_step_id;
236: BEGIN
237: IF (NVL (g_debug, 0) IN
238: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

Line 1082: FROM gme_batch_header

1078:
1079: CURSOR cur_get_batch (v_batch_id NUMBER)
1080: IS
1081: SELECT *
1082: FROM gme_batch_header
1083: WHERE batch_id = v_batch_id;
1084:
1085: l_batch_hdr gme_batch_header%ROWTYPE;
1086:

Line 1085: l_batch_hdr gme_batch_header%ROWTYPE;

1081: SELECT *
1082: FROM gme_batch_header
1083: WHERE batch_id = v_batch_id;
1084:
1085: l_batch_hdr gme_batch_header%ROWTYPE;
1086:
1087: CURSOR cur_check_fpo (v_actv_id NUMBER)
1088: IS
1089: SELECT batch_type

Line 1090: FROM gme_batch_header b, gme_batch_step_activities a

1086:
1087: CURSOR cur_check_fpo (v_actv_id NUMBER)
1088: IS
1089: SELECT batch_type
1090: FROM gme_batch_header b, gme_batch_step_activities a
1091: WHERE b.batch_id = a.batch_id AND batchstep_activity_id = v_actv_id;
1092:
1093: CURSOR cur_lock_actv (v_activity_id NUMBER)
1094: IS

Line 1837: l_batch_hdr gme_batch_header%ROWTYPE;

1833: l_activity gme_batch_step_activities.activity%TYPE;
1834: l_last_update_date DATE;
1835: l_inv_trans_count NUMBER;
1836: l_rsrc_trans_count NUMBER;
1837: l_batch_hdr gme_batch_header%ROWTYPE;
1838:
1839: CURSOR cur_get_batch (v_batch_id NUMBER)
1840: IS
1841: SELECT *

Line 1842: FROM gme_batch_header

1838:
1839: CURSOR cur_get_batch (v_batch_id NUMBER)
1840: IS
1841: SELECT *
1842: FROM gme_batch_header
1843: WHERE batch_id = v_batch_id;
1844:
1845: CURSOR cur_get_step_dtl (v_batchstep_act_id NUMBER)
1846: IS

Line 1851: gme_batch_header b

1847: SELECT step_status, batch_status, a.batch_id, s.batchstep_id,
1848: batchstep_activity_id, activity
1849: FROM gme_batch_steps s,
1850: gme_batch_step_activities a,
1851: gme_batch_header b
1852: WHERE batchstep_activity_id = v_batchstep_act_id
1853: AND b.batch_id = a.batch_id
1854: AND s.batchstep_id = a.batchstep_id;
1855:

Line 1865: FROM gme_batch_header b, gme_batch_step_activities a

1861:
1862: CURSOR cur_check_fpo (v_actv_id NUMBER)
1863: IS
1864: SELECT batch_type
1865: FROM gme_batch_header b, gme_batch_step_activities a
1866: WHERE b.batch_id = a.batch_id AND batchstep_activity_id = v_actv_id;
1867:
1868: CURSOR cur_lock_actv (v_activity_id NUMBER)
1869: IS