DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 626: FROM ap_system_parameters_all

622: to_char(l_org_id) ;
623: -----------------------------------------------------------------
624: SELECT NVL(ALLOW_PAID_INVOICE_ADJUST, 'N')
625: INTO l_allow_paid_invoice_adjust
626: FROM ap_system_parameters_all
627: WHERE org_id = l_org_id_list(i);
628:
629: IF l_allow_paid_invoice_adjust = 'N' THEN
630: FND_MESSAGE.SET_NAME('SQLAP', 'ALLOW_PAID_INVOICE_ADJUST');

Line 5370: FROM ap_system_parameters

5366: l_invoice_header_rec := l_invoice_header_list(i);
5367:
5368: SELECT auto_calculate_interest_flag
5369: INTO l_allow_interest_invoices
5370: FROM ap_system_parameters
5371: WHERE org_id = l_invoice_header_rec.org_id;
5372:
5373: --
5374: IF (AP_IMPORT_VALIDATION_PKG.v_check_invoice_validation

Line 5768: ap_system_parameters_all asp

5764: l_seqassid,
5765: l_set_of_books_id
5766: FROM fnd_document_sequences SEQ,
5767: fnd_doc_sequence_assignments SA,
5768: ap_system_parameters_all asp
5769: WHERE SEQ.doc_sequence_id = SA.doc_sequence_id
5770: AND SA.application_id = 200
5771: AND SA.category_code = l_doc_category_code
5772: AND (NVL(SA.method_code,'A') = 'A')