DBA Data[Home] [Help]

APPS.PA_BILLING dependencies on DUAL

Line 149: FROM DUAL;

145: l_org_id NUMBER(15);
146: BEGIN
147: SELECT NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)
148: INTO l_org_id
149: FROM DUAL;
150:
151: IF (G_ORG_ID is NULL or
152: G_ORG_ID <> l_org_id) THEN
153: SELECT NVL(INVOICE_NZ_LINES,'N')

Line 2162: From dual

2158: /* Check whether the customer is associated with any of the top tasks */
2159:
2160: Select 'Y'
2161: Into l_exist_flag
2162: From dual
2163: Where exists ( select null
2164: from pa_tasks
2165: where project_id = p_project_id
2166: and customer_id = p_customer_id