APPS.GL_SEL_SEG_TURNOVER_RPT_PKG dependencies on GL_IMPORT_REFERENCES

Line 61: FROM gl_import_references gir

57: SELECT SUBSTR(aba.description,1,2)||'/'||
58: SUBSTR(csh.statement_number,1,4)||'/'||
59: SUBSTR(TO_CHAR(csl.line_number),1,4)
60: INTO lc_doc_num
61: FROM gl_import_references gir
62: ,ce_statement_lines csl
63: ,ce_statement_headers csh
64: ,ap_bank_accounts aba
65: WHERE gir.je_header_id = p_je_header_id

Line 75: FROM gl_import_references gir

71: WHEN NO_DATA_FOUND THEN
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'

Line 86: FROM gl_import_references gir

82: WHEN NO_DATA_FOUND THEN
83: BEGIN
84: SELECT TO_CHAR(gir.reference_4)
85: INTO lc_doc_num
86: FROM gl_import_references gir
87: WHERE gir.je_header_id = p_je_header_id
88: AND gir.je_line_num = p_je_line_num
89: AND (gir.reference_6 IN ('INV','DM','DEP','CM','AP Payments','AP Reconciled Payments','CUSTOMER','DIALOG_HK')
90: OR gir.reference_10 IN ('AR_CASH_RECEIPT_HISTORY','AR_RECEIVABLE_APPLICATIONS'));