APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on DUAL

Line 409: debug_info := 'Select from sys.dual';

405: --
406: current_calling_sequence :=
407: 'AP_INVOICE_DISTRIBUTIONS_PKG.All_Encumbered<-'||X_Calling_Sequence;
408:
409: debug_info := 'Select from sys.dual';
410:
411: select 'There are encumbered dists'
412: into dummy
413: from sys.dual

Line 413: from sys.dual

409: debug_info := 'Select from sys.dual';
410:
411: select 'There are encumbered dists'
412: into dummy
413: from sys.dual
414: where not exists (select 'There are other unencumbered dists'
415: from ap_invoice_distributions
416: where invoice_id = X_Invoice_Id
417: and NVL(match_status_flag, 'N') <> 'A'

Line 668: debug_info := 'Select from sys.dual';

664: --
665: current_calling_sequence :=
666: 'AP_INVOICE_DISTRIBUTION_PKG.Substrbyte<-'||X_Calling_Sequence;
667:
668: debug_info := 'Select from sys.dual';
669:
670: select SUBSTRB(X_String, X_Start, X_End)
671: into result_str
672: from sys.dual;

Line 672: from sys.dual;

668: debug_info := 'Select from sys.dual';
669:
670: select SUBSTRB(X_String, X_Start, X_End)
671: into result_str
672: from sys.dual;
673:
674: return(result_str);
675:
676: EXCEPTION

Line 767: SELECT ap_invoice_distributions_s.nextval INTO l_inv_dist_id FROM DUAL;

763: -- Step 4 - Generate distributions
764: -------------------------------------------------------------------------
765: FOR i in nvl(X_dist_tab.FIRST, 0) .. nvl(X_dist_tab.LAST, -1) LOOP
766:
767: SELECT ap_invoice_distributions_s.nextval INTO l_inv_dist_id FROM DUAL;
768:
769: INSERT INTO ap_invoice_distributions (
770: batch_id,
771: invoice_id,

Line 6187: SELECT ap_invoice_distributions_s.nextval INTO l_inv_dist_id FROM DUAL;

6183: ----------------------------------------------------------------------------
6184:
6185: FOR i in nvl(l_dist_tab.FIRST, 0) .. nvl(l_dist_tab.LAST, -1) LOOP
6186:
6187: SELECT ap_invoice_distributions_s.nextval INTO l_inv_dist_id FROM DUAL;
6188:
6189: INSERT INTO ap_invoice_distributions(
6190: batch_id,
6191: invoice_id,