DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on FND_DOC_SEQUENCE_CATEGORIES

Line 2653: LEFT OUTER JOIN fnd_doc_sequence_categories cat

2649: THEN 'N'
2650: ELSE 'Y'
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

Line 2677: LEFT OUTER JOIN fnd_doc_sequence_categories cat

2673: THEN 'N'
2674: ELSE 'Y'
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