DBA Data[Home] [Help]

APPS.QA_PLAN_ELEMENT_API dependencies on GME_BATCH_HEADER

Line 1767: FROM GME_BATCH_HEADER

1763: RETURN NUMBER IS
1764: id NUMBER;
1765: CURSOR c (batch_num VARCHAR2,o_id NUMBER) IS
1766: SELECT BATCH_ID
1767: FROM GME_BATCH_HEADER
1768: WHERE BATCH_NO = batch_num
1769: AND ( ORGANIZATION_ID IS NULL OR
1770: ORGANIZATION_ID = o_id );
1771: BEGIN

Line 4428: 'FROM GME_BATCH_HEADER '||

4424: BEGIN
4425: wild := value||'%';
4426:
4427: sql_string := 'SELECT BATCH_NO, BATCH_NO BATCH_DESC '||
4428: 'FROM GME_BATCH_HEADER '||
4429: 'WHERE BATCH_NO like :1 '||
4430: 'AND (ORGANIZATION_ID = :2 '||
4431: ' or ORGANIZATION_ID IS NULL)';
4432: