DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_UTIL_PKG dependencies on FND_DOCUMENT_SEQUENCES

Line 201: FROM fnd_document_sequences SEQ,

197: debug_info := 'Is sequence Assigned?';
198:
199: SELECT count(*)
200: INTO l_count
201: FROM fnd_document_sequences SEQ,
202: fnd_doc_sequence_assignments SA
203: WHERE SEQ.doc_sequence_id = SA.doc_sequence_id
204: AND SA.application_id = 200
205: AND SA.category_code = p_document_category_code

Line 2164: FROM fnd_document_sequences SEQ,

2160: SELECT SEQ.db_sequence_name,
2161: SEQ.doc_sequence_id,
2162: SA.doc_sequence_assignment_id
2163: INTO l_dbseqnm, l_ppa_invoice_rec.doc_sequence_id, l_seqassid
2164: FROM fnd_document_sequences SEQ,
2165: fnd_doc_sequence_assignments SA
2166: WHERE SEQ.doc_sequence_id = SA.doc_sequence_id
2167: AND SA.application_id = 200
2168: AND SA.category_code = l_ppa_invoice_rec.doc_category_code