DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_UTILITY_PKG dependencies on GL_CODE_COMBINATIONS

Line 856: from gl_code_combinations C

852: WHERE D.invoice_id = p_line_rec.invoice_id
853: AND D.invoice_line_number = p_line_rec.line_number
854: AND D.posted_flag IN ('N', 'P')
855: AND ((EXISTS (select 'x'
856: from gl_code_combinations C
857: where D.dist_code_combination_id = C.code_combination_id (+)
858: and (C.code_combination_id is null
859: or C.detail_posting_allowed_flag = 'N'
860: or C.start_date_active > D.accounting_date

Line 876: , gl_code_combinations glcc

872:
873: SELECT count(1)
874: INTO l_valid_alt_acct_exists
875: FROM ap_invoice_distributions aid
876: , gl_code_combinations glcc
877: WHERE aid.invoice_id = p_line_rec.invoice_id
878: AND aid.invoice_line_number = p_line_rec.line_number
879: AND aid.posted_flag IN ('N', 'P')
880: AND dist_code_combination_id = glcc.code_combination_id

Line 885: FROM gl_code_combinations glcc1

881: AND glcc.alternate_code_combination_id IS NOT NULL
882: AND EXISTS
883: (
884: SELECT 'Account Valid'
885: FROM gl_code_combinations glcc1
886: WHERE glcc1.code_combination_id = glcc.alternate_code_combination_id
887: AND glcc1.enabled_flag = 'Y'
888: AND glcc1.detail_posting_allowed_flag = 'Y'
889: AND aid.accounting_date BETWEEN