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 1075: FROM gme_batch_header

1071:
1072: CURSOR cur_get_batch (v_batch_id NUMBER)
1073: IS
1074: SELECT *
1075: FROM gme_batch_header
1076: WHERE batch_id = v_batch_id;
1077:
1078: l_batch_hdr gme_batch_header%ROWTYPE;
1079:

Line 1078: l_batch_hdr gme_batch_header%ROWTYPE;

1074: SELECT *
1075: FROM gme_batch_header
1076: WHERE batch_id = v_batch_id;
1077:
1078: l_batch_hdr gme_batch_header%ROWTYPE;
1079:
1080: CURSOR cur_check_fpo (v_actv_id NUMBER)
1081: IS
1082: SELECT batch_type

Line 1083: FROM gme_batch_header b, gme_batch_step_activities a

1079:
1080: CURSOR cur_check_fpo (v_actv_id NUMBER)
1081: IS
1082: SELECT batch_type
1083: FROM gme_batch_header b, gme_batch_step_activities a
1084: WHERE b.batch_id = a.batch_id AND batchstep_activity_id = v_actv_id;
1085:
1086: CURSOR cur_lock_actv (v_activity_id NUMBER)
1087: IS

Line 1830: l_batch_hdr gme_batch_header%ROWTYPE;

1826: l_activity gme_batch_step_activities.activity%TYPE;
1827: l_last_update_date DATE;
1828: l_inv_trans_count NUMBER;
1829: l_rsrc_trans_count NUMBER;
1830: l_batch_hdr gme_batch_header%ROWTYPE;
1831:
1832: CURSOR cur_get_batch (v_batch_id NUMBER)
1833: IS
1834: SELECT *

Line 1835: FROM gme_batch_header

1831:
1832: CURSOR cur_get_batch (v_batch_id NUMBER)
1833: IS
1834: SELECT *
1835: FROM gme_batch_header
1836: WHERE batch_id = v_batch_id;
1837:
1838: CURSOR cur_get_step_dtl (v_batchstep_act_id NUMBER)
1839: IS

Line 1844: gme_batch_header b

1840: SELECT step_status, batch_status, a.batch_id, s.batchstep_id,
1841: batchstep_activity_id, activity
1842: FROM gme_batch_steps s,
1843: gme_batch_step_activities a,
1844: gme_batch_header b
1845: WHERE batchstep_activity_id = v_batchstep_act_id
1846: AND b.batch_id = a.batch_id
1847: AND s.batchstep_id = a.batchstep_id;
1848:

Line 1858: FROM gme_batch_header b, gme_batch_step_activities a

1854:
1855: CURSOR cur_check_fpo (v_actv_id NUMBER)
1856: IS
1857: SELECT batch_type
1858: FROM gme_batch_header b, gme_batch_step_activities a
1859: WHERE b.batch_id = a.batch_id AND batchstep_activity_id = v_actv_id;
1860:
1861: CURSOR cur_lock_actv (v_activity_id NUMBER)
1862: IS