DBA Data[Home] [Help]

APPS.GMS_CLIENT_EXTN_BUDGET_WF dependencies on DUAL

Line 313: FROM sys.dual;

309: -- Get System Date for Worflow-Started-Date
310: CURSOR l_wf_started_date_csr
311: IS
312: SELECT sysdate
313: FROM sys.dual;
314:
315: ItemType varchar2(30) := 'GMSWF'; --<----Identifies the workflow process!!!
316: ItemKey varchar2(30);
317:

Line 589: from dual;

585: --------------------------------------------------------------------------------
586:
587: SELECT gms_workflow_itemkey_s.nextval
588: INTO ItemKey
589: from dual;
590:
591:
592: EXCEPTION
593:

Line 1051: FROM sys.dual;

1047: -- Get System Date for Worflow-Started-Date
1048: CURSOR l_wf_started_date_csr
1049: IS
1050: SELECT sysdate
1051: FROM sys.dual;
1052:
1053: ItemType varchar2(30) := 'GMSWF'; --<----Identifies the workflow process!!!
1054: ItemKey varchar2(30);
1055:

Line 1338: from dual;

1334: --------------------------------------------------------------------------------
1335:
1336: SELECT gms_workflow_itemkey_s.nextval
1337: INTO ItemKey
1338: from dual;
1339:
1340:
1341: EXCEPTION
1342: