APPS.AP_R11_PREPAY_PKG dependencies on DUAL

Line 561: FROM sys.dual;

557: ---------------------------------------------------------------------
558: debug_info := 'Get the amount_positive';
559: SELECT DECODE((SIGN(X_amount_apply)), 1, 'Y', 'N')
560: INTO X_amount_positive
561: FROM sys.dual;
562:
563:
564: ---------------------------------------------------------------------
565: -- We need to check if the invoice has been overapplyed when

Line 1032: FROM sys.dual; -- added for Invoice_Distribution_Id

1028:
1029: /* First get the Invoice_Distribution_Id from the sequence */
1030: SELECT ap_invoice_distributions_s.NEXTVAL
1031: INTO l_invoice_distribution_id
1032: FROM sys.dual; -- added for Invoice_Distribution_Id
1033:
1034:
1035: debug_info := 'Update ap_invoice_distributions for creating the distribution reversals';
1036:

Line 1937: FROM SYS.DUAL

1933: DECODE(X_last_update_login, -999, null, X_last_update_login),
1934: SYSDATE,
1935: X_user_id,
1936: X_org_id /* Bug 3700128. MOAC Project */
1937: FROM SYS.DUAL
1938: WHERE NOT EXISTS (
1939: SELECT 'Already updated existing record'
1940: FROM ap_invoice_prepays
1941: WHERE prepay_id = X_prepay_id