DBA Data[Home] [Help]

APPS.GL_SEL_SEG_TURNOVER_RPT_PKG dependencies on AP_INVOICES

Line 76: ,ap_invoices ai

72: BEGIN
73: SELECT ai.doc_sequence_value
74: INTO lc_doc_num
75: FROM gl_import_references gir
76: ,ap_invoices ai
77: WHERE gir.je_header_id = p_je_header_id
78: AND gir.je_line_num = p_je_line_num
79: AND gir.reference_6 = 'AP Invoices'
80: AND gir.reference_2 = ai.invoice_id;

Line 79: AND gir.reference_6 = 'AP Invoices'

75: FROM gl_import_references gir
76: ,ap_invoices ai
77: WHERE gir.je_header_id = p_je_header_id
78: AND gir.je_line_num = p_je_line_num
79: AND gir.reference_6 = 'AP Invoices'
80: AND gir.reference_2 = ai.invoice_id;
81: EXCEPTION
82: WHEN NO_DATA_FOUND THEN
83: BEGIN