APPS.AP_ISP_UTILITIES_PKG dependencies on PO_RELEASES_ALL

Line 2959: FROM po_releases_all pr

2955: IF l_po_count = 1 THEN
2956: --
2957: SELECT COUNT(*)
2958: INTO l_release_count
2959: FROM po_releases_all pr
2960: WHERE po_header_id IN (SELECT po_header_id
2961: FROM ap_invoice_lines_All
2962: WHERE invoice_id = p_invoice_id);
2963: --

Line 3004: FROM po_releases_all pr

3000: WHERE invoice_id = p_invoice_id);
3001:
3002: SELECT COUNT(*)
3003: INTO l_release_count
3004: FROM po_releases_all pr
3005: WHERE po_header_id = l_po_header_id;
3006: --
3007: IF l_release_count = 1 THEN
3008: --

Line 3011: FROM po_releases_all

3007: IF l_release_count = 1 THEN
3008: --
3009: SELECT release_num
3010: INTO l_release_num
3011: FROM po_releases_all
3012: WHERE po_header_id = l_po_header_id;
3013:
3014: l_po_number := l_po_number||'-'|| l_release_num;
3015: END IF;

Line 3081: FROM po_releases_all pr

3077: --
3078: IF l_po_header_id is NOT NULL THEN
3079: SELECT COUNT(*)
3080: INTO l_release_count
3081: FROM po_releases_all pr
3082: WHERE po_header_id IN (SELECT po_header_id
3083: FROM ap_invoice_lines_All
3084: WHERE invoice_id = p_invoice_id);
3085: --

Line 3092: FROM po_releases_all

3088: SELECT po_release_id,
3089: release_num
3090: INTO l_po_release_id,
3091: l_release_num
3092: FROM po_releases_all
3093: WHERE po_header_id = l_po_header_id;
3094: END IF;
3095: --
3096: END IF;