DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on GME_BATCH_HEADER

Line 1748: FROM GME_BATCH_HEADER

1744: RETURN NUMBER IS
1745: id NUMBER;
1746: CURSOR c (batch_num VARCHAR2,o_id NUMBER) IS
1747: SELECT BATCH_ID
1748: FROM GME_BATCH_HEADER
1749: WHERE BATCH_NO = batch_num
1750: AND ( ORGANIZATION_ID IS NULL OR
1751: ORGANIZATION_ID = o_id );
1752: BEGIN

Line 4230: 'FROM GME_BATCH_HEADER '||

4226: BEGIN
4227: wild := value||'%';
4228:
4229: sql_string := 'SELECT BATCH_NO, BATCH_NO BATCH_DESC '||
4230: 'FROM GME_BATCH_HEADER '||
4231: 'WHERE BATCH_NO like :1 '||
4232: 'AND (ORGANIZATION_ID = :2 '||
4233: ' or ORGANIZATION_ID IS NULL)';
4234: