APPS.AP_ISP_UTILITIES_PKG dependencies on PO_RELEASES_ALL

Line 2598: FROM po_releases_all pr

2594: IF l_po_count = 1 THEN
2595: --
2596: SELECT COUNT(*)
2597: INTO l_release_count
2598: FROM po_releases_all pr
2599: WHERE po_header_id IN (SELECT po_header_id
2600: FROM ap_invoice_lines_All
2601: WHERE invoice_id = p_invoice_id);
2602: --

Line 2643: FROM po_releases_all pr

2639: WHERE invoice_id = p_invoice_id);
2640:
2641: SELECT COUNT(*)
2642: INTO l_release_count
2643: FROM po_releases_all pr
2644: WHERE po_header_id = l_po_header_id;
2645: --
2646: IF l_release_count = 1 THEN
2647: --

Line 2650: FROM po_releases_all

2646: IF l_release_count = 1 THEN
2647: --
2648: SELECT release_num
2649: INTO l_release_num
2650: FROM po_releases_all
2651: WHERE po_header_id = l_po_header_id;
2652:
2653: l_po_number := l_po_number||'-'|| l_release_num;
2654: END IF;

Line 2720: FROM po_releases_all pr

2716: --
2717: IF l_po_header_id is NOT NULL THEN
2718: SELECT COUNT(*)
2719: INTO l_release_count
2720: FROM po_releases_all pr
2721: WHERE po_header_id IN (SELECT po_header_id
2722: FROM ap_invoice_lines_All
2723: WHERE invoice_id = p_invoice_id);
2724: --

Line 2731: FROM po_releases_all

2727: SELECT po_release_id,
2728: release_num
2729: INTO l_po_release_id,
2730: l_release_num
2731: FROM po_releases_all
2732: WHERE po_header_id = l_po_header_id;
2733: END IF;
2734: --
2735: END IF;