APPS.AP_TURNOVER_RPT_PKG dependencies on GL_CODE_COMBINATIONS

Line 74: gc_prepay_invoice_from := ' gl_code_combinations gcc';

70:
71: IF PRPMT_PROCESSING_PARAM=2 THEN
72: gc_prepay_invoice_select := ' ai.gl_date ';
73:
74: gc_prepay_invoice_from := ' gl_code_combinations gcc';
75:
76: gc_prepay_where := ' gcc.code_combination_id=xal.code_combination_id';
77: gc_prepay_invoice_where := gc_prepay_where ;--||' AND gcc.code_combination_id = :ACCOUNT_ID';
78:

Line 89: gc_prepay_invoice_from := gc_prepay_invoice_from ||' ,gl_code_combinations gcc';

85:
86: gc_prepay_invoice_from := gc_prepay_invoice_from ||' ap_invoice_payments aip';
87: gc_prepay_invoice_from := gc_prepay_invoice_from ||' ,ap_checks ac';
88: gc_prepay_invoice_from := gc_prepay_invoice_from ||' ,ap_system_parameters asps';
89: gc_prepay_invoice_from := gc_prepay_invoice_from ||' ,gl_code_combinations gcc';
90: --************************
91: --WHERE Clause
92: --************************
93: gc_prepay_where := ' aip.invoice_id=ai.invoice_id';

Line 181: ,gl_code_combinations gcc

177: ,xla_events xe
178: ,xla_distribution_links xdl
179: ,xla_ae_lines xal
180: ,xla_ae_headers xah
181: ,gl_code_combinations gcc
182: WHERE aia.vendor_id = p_in_sup_id
183: AND aia.org_id = p_in_orgs_id
184: AND aia.vendor_site_id = p_in_sup_site_id
185: AND aia.invoice_currency_code = p_in_curr

Line 232: ,gl_code_combinations gcc

228: ,xla_transaction_entities xte
229: ,xla_events xe
230: ,xla_ae_headers xah
231: ,xla_ae_lines xal
232: ,gl_code_combinations gcc
233: WHERE ai.set_of_books_id = LEDGER_ID_PARAM
234: AND ai.vendor_id = p_in_sup_id
235: AND ai.org_id = p_in_orgs_id
236: AND ai.vendor_site_id = p_in_sup_site_id