APPS.AP_INVOICE_LINES_UTILITY_PKG dependencies on AP_INVOICE_LINES_ALL

Line 1332: debug_info := 'Select from ap_invoice_lines_all';

1328: current_calling_sequence :=
1329: 'AP_INVOICE_LINES_UTILITY_PKG.LINE_REFERRED_BY_CORR<-'
1330: ||p_Calling_Sequence;
1331:
1332: debug_info := 'Select from ap_invoice_lines_all';
1333:
1334: Select count(*)
1335: Into dummy
1336: From ap_invoice_lines_all AIL

Line 1336: From ap_invoice_lines_all AIL

1332: debug_info := 'Select from ap_invoice_lines_all';
1333:
1334: Select count(*)
1335: Into dummy
1336: From ap_invoice_lines_all AIL
1337: Where NVL(AIL.discarded_flag, 'N' ) <> 'Y'
1338: And NVL( AIL.cancelled_flag, 'N' ) <> 'Y'
1339: And AIL.corrected_inv_id = p_Invoice_Id
1340: And AIL.corrected_line_number = p_Line_Number;

Line 2010: FROM ap_invoice_lines_all

2006: BEGIN
2007:
2008: SELECT count(*)
2009: INTO l_count
2010: FROM ap_invoice_lines_all
2011: WHERE corrected_inv_id = p_invoice_id
2012: AND corrected_line_number = p_line_number
2013: AND line_type_lookup_code IN ('RETROITEM')
2014: AND line_source = 'PO PRICE ADJUSTMENT'

Line 2051: FROM ap_invoice_lines_all

2047: BEGIN
2048:
2049: SELECT 'Y'
2050: INTO is_po_price_adjustment
2051: FROM ap_invoice_lines_all
2052: WHERE invoice_id = p_invoice_id
2053: AND line_number = p_line_number
2054: AND line_type_lookup_code = 'RETROITEM'
2055: AND line_source = 'PO PRICE ADJUSTMENT'