APPS.AP_APPROVAL_PKG dependencies on DUAL

Line 2127: FROM DUAL

2123: /* bug 11845564 starts */
2124:
2125: /* SELECT 'Y'
2126: INTO l_lcm_used
2127: FROM DUAL
2128: WHERE EXISTS
2129: (SELECT 1 FROM AP_INVOICE_DISTRIBUTIONS aid, RCV_TRANSACTIONS rt
2130: WHERE aid.invoice_id = l_invoice_id
2131: AND aid.rcv_transaction_id = rt.transaction_id

Line 2137: FROM DUAL

2133: AND aid.match_status_flag = 'S'); */
2134:
2135: SELECT 'Y'
2136: INTO l_lcm_used
2137: FROM DUAL
2138: WHERE EXISTS
2139: (SELECT 1
2140: FROM AP_INVOICE_DISTRIBUTIONS_ALL aid,
2141: RCV_TRANSACTIONS rt

Line 2175: FROM dual

2171: /* bug 12674049: Added "AND C.user_releaseable_flag = 'N' " condition to handle non postable-user releasable holds*/
2172:
2173: SELECT 'Y'
2174: INTO l_unpostable_holds_exist
2175: FROM dual
2176: WHERE EXISTS (SELECT 1
2177: FROM ap_holds H, ap_hold_codes C
2178: WHERE H.invoice_id = l_invoice_id
2179: AND H.hold_lookup_code = C.hold_lookup_code

Line 4547: FROM DUAL

4543:
4544: CURSOR Dist_Var_Cur IS
4545: /* Modified by epajaril to fix bug 6729934 */
4546: SELECT 'Distribution needs to be verified. '
4547: FROM DUAL
4548: WHERE EXISTS (
4549: SELECT 'Dist Total <> Invoice Line Amount'
4550: FROM ap_invoice_lines_all AIL, ap_invoice_distributions_all D
4551: -- WHERE AIL.invoice_id = D.invoice_id

Line 7086: FROM DUAL;

7082: -------------------------------------------
7083:
7084: SELECT ap_holds_s.nextval
7085: INTO l_hold_id
7086: FROM DUAL;
7087:
7088: --Introduced select stmt for 8691645
7089:
7090: select org_id into l_org_id

Line 8957: FROM DUAL;

8953: l_dist_tab(i).invoice_line_number := p_invoice_line_rec.line_number;
8954:
8955: SELECT ap_invoice_distributions_s.nextval
8956: INTO l_dist_tab(i).invoice_distribution_id
8957: FROM DUAL;
8958:
8959: l_dist_tab(i).line_type_lookup_code := 'ITEM';
8960:
8961: IF (nvl(p_generate_permanent,'N') = 'N') THEN

Line 9156: -- individually.

9152: ------------------------------------------------------------------------
9153: -- Function Batch_Approval:
9154: -- It selects all invoices depending on the parameters given to it and
9155: -- calls the on-line PL/SQL approval package to approve each invoice
9156: -- individually.
9157: ------------------------------------------------------------------------
9158:
9159: FUNCTION batch_approval
9160: (p_run_option IN VARCHAR2,

Line 9788: FROM DUAL

9784: NVL(AI.HISTORICAL_FLAG,''N'') = ''Y'' AND
9785: NVL(AI.FORCE_REVALIDATION_FLAG,''N'') = ''N'') /*Bug11934187*/
9786: AND EXISTS (
9787: SELECT /*+ PUSH_SUBQ */ 1
9788: FROM DUAL
9789: WHERE UPPER(NVL(AI.SOURCE, ''X'')) <> ''RECURRING INVOICE''
9790: UNION ALL
9791: SELECT 1
9792: FROM DUAL

Line 9792: FROM DUAL

9788: FROM DUAL
9789: WHERE UPPER(NVL(AI.SOURCE, ''X'')) <> ''RECURRING INVOICE''
9790: UNION ALL
9791: SELECT 1
9792: FROM DUAL
9793: WHERE UPPER(NVL(AI.SOURCE, ''X'')) = ''RECURRING INVOICE''
9794: AND NOT EXISTS
9795: ( SELECT NULL
9796: FROM GL_PERIOD_STATUSES GLPS

Line 9806: FROM DUAL

9802: )
9803: )
9804: AND EXISTS (
9805: SELECT 1
9806: FROM DUAL
9807: WHERE AI.FORCE_REVALIDATION_FLAG = ''Y''
9808: UNION ALL
9809: SELECT 1
9810: FROM AP_INVOICE_DISTRIBUTIONS_ALL D,