APPS.IGC_CC_COMPLETE_COVER_PKG dependencies on PO_HEADERS

Line 127: from PO_HEADERS

123: -- Cursor C_purchase_orders selects the purchase orders created from a CC Release
124:
125: Cursor C_purchase_orders ( x_cc_num IN IGC_CC_HEADERS.CC_NUM%TYPE ) IS
126: Select po_header_id
127: from PO_HEADERS
128: where segment1 = x_cc_num
129: and type_lookup_code = 'STANDARD';
130:
131: /*modifed for 3199488 - fnd logging changes*/

Line 342: Function matched_releases ( x_po_header_id IN PO_HEADERS.PO_HEADER_ID%TYPE )

338: ------------------------------------
339:
340: End Submit_report;
341:
342: Function matched_releases ( x_po_header_id IN PO_HEADERS.PO_HEADER_ID%TYPE )
343: return boolean IS
344: Cursor C_matched_releases is
345: Select 'X'
346: from ap_invoice_distributions ind

Line 348: , po_headers ph

344: Cursor C_matched_releases is
345: Select 'X'
346: from ap_invoice_distributions ind
347: , po_distributions pd
348: , po_headers ph
349: where ind.po_distribution_id = pd.po_distribution_id
350: and pd.po_header_id = ph.po_header_id
351: and ph.po_header_id = x_po_header_id;
352: l_invoice_rec varchar2(1) := NULL;