DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_UTIL_PKG dependencies on FND_DOC_SEQUENCE_ASSIGNMENTS

Line 202: fnd_doc_sequence_assignments SA

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
206: AND (NVL(SA.method_code,'A') = 'A')

Line 2165: fnd_doc_sequence_assignments SA

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
2169: AND (NVL(SA.method_code,'A') = 'A')