DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on GME_BATCH_STEPS

Line 1770: FROM GME_BATCH_STEPS

1766: RETURN NUMBER IS
1767: id NUMBER;
1768: CURSOR c (l_batchstep_num VARCHAR2, l_batch_id NUMBER) is
1769: SELECT BATCHSTEP_ID
1770: FROM GME_BATCH_STEPS
1771: WHERE BATCHSTEP_NO = L_BATCHSTEP_NUM
1772: AND BATCH_ID = L_BATCH_ID;
1773: BEGIN
1774:

Line 4252: 'FROM GME_BATCH_STEPS STEPS, GMD_OPERATIONS OPS '||

4248: BEGIN
4249: l_batch_id := get_process_batch_id(p_process_batch_num, p_org_id);
4250: wild := value;
4251: sql_string := 'SELECT STEPS.BATCHSTEP_NO,OPS.OPRN_DESC BATCHSTEP_DESC '||
4252: 'FROM GME_BATCH_STEPS STEPS, GMD_OPERATIONS OPS '||
4253: 'WHERE STEPS.BATCHSTEP_NO like :1 '||
4254: 'AND STEPS.BATCH_ID =:2 '||
4255: 'AND STEPS.OPRN_ID = OPS.OPRN_ID';
4256: