DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on FND_DOCUMENT_SEQUENCES

Line 2930: LEFT OUTER JOIN fnd_document_sequences doc

2926: END doc_sequence_id_valid_flag
2927: FROM xla_ae_headers h
2928: LEFT OUTER JOIN fnd_doc_sequence_categories cat
2929: ON cat.code = h.doc_category_code
2930: LEFT OUTER JOIN fnd_document_sequences doc
2931: ON doc.doc_sequence_id = h.doc_sequence_id
2932: WHERE h.ae_header_id = g_ae_header_id
2933: AND h.application_id = g_application_id
2934: AND ((h.doc_category_code IS NOT NULL AND cat.code IS NULL) OR

Line 2954: LEFT OUTER JOIN fnd_document_sequences doc

2950: END doc_sequence_id_valid_flag
2951: FROM xla_ae_headers_gt h
2952: LEFT OUTER JOIN fnd_doc_sequence_categories cat
2953: ON cat.code = h.doc_category_code
2954: LEFT OUTER JOIN fnd_document_sequences doc
2955: ON doc.doc_sequence_id = h.doc_sequence_id
2956: WHERE h.ledger_id = g_ledger_id
2957: AND h.accounting_date <= NVL(g_end_date, h.accounting_date) -- 4262811
2958: AND ((h.doc_category_code IS NOT NULL AND cat.code IS NULL) OR