DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 994: financials_system_parameters FSP

990: cancellation_flag ,
991: match_status_flag ,
992: awt_invoice_payment_id
993: FROM ap_self_assessed_tax_dist_all ) AID,
994: financials_system_parameters FSP
995: WHERE AID.invoice_id = P_invoice_id
996: AND AID.awt_invoice_payment_id IS NULL
997: AND AID.org_id = FSP.org_id -- Bug 4516136
998: AND AID.set_of_books_id = FSP.set_of_books_id

Line 4514: l_purch_enc_flag financials_system_parameters.purch_encumbrance_flag%TYPE;

4510: RETURN VARCHAR2
4511: IS
4512:
4513: l_count NUMBER := 0;
4514: l_purch_enc_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
4515:
4516: l_curr_calling_sequence VARCHAR2(2000);
4517:
4518: -- Logging:

Line 4542: FROM financials_system_parameters FSP,

4538: BEGIN
4539:
4540: SELECT nvl(purch_encumbrance_flag,'N')
4541: INTO l_purch_enc_flag
4542: FROM financials_system_parameters FSP,
4543: AP_INVOICES INV
4544: WHERE INV.org_id = FSP.org_id
4545: AND INV.set_of_books_id = FSP.set_of_books_id -- Bug 5608968 Avoid full index scan of fsp
4546: AND INV.invoice_id = p_source_id;

Line 4585: FROM financials_system_parameters FSP,

4581: BEGIN
4582:
4583: SELECT nvl(purch_encumbrance_flag,'N')
4584: INTO l_purch_enc_flag
4585: FROM financials_system_parameters FSP,
4586: AP_CHECKS AC
4587: WHERE AC.org_id = FSP.org_id
4588: AND AC.check_id = p_source_id;
4589: EXCEPTION