APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 848: FROM ap_invoice_distributions AID, financials_system_parameters FSP

844: -- decode (line_type_lookup_code, 'PREPAY',
845: -- invoice_distribution_id, -1) invoice_distribution_id,
846: -- Bug 6931461: invoice_line_number invoice_line_number
847: decode(line_type_lookup_code, 'PREPAY', invoice_line_number, 1) invoice_line_number
848: FROM ap_invoice_distributions AID, financials_system_parameters FSP
849: WHERE AID.invoice_id = P_invoice_id
850: AND AID.awt_invoice_payment_id is NULL
851: AND AID.org_id = FSP.org_id -- Bug 4516136
852: AND AID.set_of_books_id = FSP.set_of_books_id -- Bug 5608968 Avoid full index scan of fsp

Line 3944: l_purch_enc_flag financials_system_parameters.purch_encumbrance_flag%TYPE;

3940: RETURN VARCHAR2
3941: IS
3942:
3943: l_count NUMBER := 0;
3944: l_purch_enc_flag financials_system_parameters.purch_encumbrance_flag%TYPE;
3945:
3946: l_curr_calling_sequence VARCHAR2(2000);
3947:
3948: -- Logging:

Line 3972: FROM financials_system_parameters FSP,

3968: BEGIN
3969:
3970: SELECT nvl(purch_encumbrance_flag,'N')
3971: INTO l_purch_enc_flag
3972: FROM financials_system_parameters FSP,
3973: AP_INVOICES INV
3974: WHERE INV.org_id = FSP.org_id
3975: AND INV.set_of_books_id = FSP.set_of_books_id -- Bug 5608968 Avoid full index scan of fsp
3976: AND INV.invoice_id = p_source_id;

Line 4015: FROM financials_system_parameters FSP,

4011: BEGIN
4012:
4013: SELECT nvl(purch_encumbrance_flag,'N')
4014: INTO l_purch_enc_flag
4015: FROM financials_system_parameters FSP,
4016: AP_CHECKS AC
4017: WHERE AC.org_id = FSP.org_id
4018: AND AC.check_id = p_source_id;
4019: EXCEPTION