DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on FND_DOCUMENT_SEQUENCES

Line 2655: LEFT OUTER JOIN fnd_document_sequences doc

2651: END doc_sequence_id_valid_flag
2652: FROM xla_ae_headers h
2653: LEFT OUTER JOIN fnd_doc_sequence_categories cat
2654: ON cat.code = h.doc_category_code
2655: LEFT OUTER JOIN fnd_document_sequences doc
2656: ON doc.doc_sequence_id = h.doc_sequence_id
2657: WHERE h.ae_header_id = g_ae_header_id
2658: AND h.application_id = g_application_id
2659: AND ((h.doc_category_code IS NOT NULL AND cat.code IS NULL) OR

Line 2679: LEFT OUTER JOIN fnd_document_sequences doc

2675: END doc_sequence_id_valid_flag
2676: FROM xla_ae_headers_gt h
2677: LEFT OUTER JOIN fnd_doc_sequence_categories cat
2678: ON cat.code = h.doc_category_code
2679: LEFT OUTER JOIN fnd_document_sequences doc
2680: ON doc.doc_sequence_id = h.doc_sequence_id
2681: WHERE h.ledger_id = g_ledger_id
2682: AND h.accounting_date <= NVL(g_end_date, h.accounting_date) -- 4262811
2683: AND ((h.doc_category_code IS NOT NULL AND cat.code IS NULL) OR