APPS.AP_AUTO_DM_CREATION_PKG dependencies on FND_DOCUMENT_SEQUENCES

Line 1121: l_db_seq_name fnd_document_sequences.db_sequence_name%TYPE;

1117: l_invoice_num ap_invoices.invoice_num%TYPE;
1118: l_terms_date DATE;
1119: l_inv_desc ap_invoices.description%TYPE;
1120: l_seq_num_profile VARCHAR2(25);
1121: l_db_seq_name fnd_document_sequences.db_sequence_name%TYPE;
1122: l_db_seq_id fnd_document_sequences.doc_sequence_id%TYPE;
1123: l_doc_seq_value NUMBER;
1124: l_invoice_amount ap_invoices.invoice_amount%TYPE;
1125: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;

Line 1122: l_db_seq_id fnd_document_sequences.doc_sequence_id%TYPE;

1118: l_terms_date DATE;
1119: l_inv_desc ap_invoices.description%TYPE;
1120: l_seq_num_profile VARCHAR2(25);
1121: l_db_seq_name fnd_document_sequences.db_sequence_name%TYPE;
1122: l_db_seq_id fnd_document_sequences.doc_sequence_id%TYPE;
1123: l_doc_seq_value NUMBER;
1124: l_invoice_amount ap_invoices.invoice_amount%TYPE;
1125: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;
1126: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;

Line 1453: FROM fnd_document_sequences SEQ,

1449: SELECT SEQ.db_sequence_name,
1450: SEQ.doc_sequence_id
1451: INTO l_db_seq_name,
1452: l_db_seq_id
1453: FROM fnd_document_sequences SEQ,
1454: fnd_doc_sequence_assignments SA
1455: WHERE SEQ.doc_sequence_id = SA.doc_sequence_id
1456: AND SA.application_id = 200
1457: AND SA.category_code = 'DBM INV'