DBA Data[Home] [Help]

APPS.AP_CANCEL_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 455: FROM financials_system_params_all

451: l_debug_info := 'Check if the PO is unapproved';
452:
453: SELECT NVL(purch_encumbrance_flag,'N')
454: INTO l_enc_enabled
455: FROM financials_system_params_all
456: WHERE NVL(org_id, -99) = NVL(l_org_id, -99);
457:
458: if l_enc_enabled = 'Y' then
459:

Line 815: FROM financials_system_params_all fsp

811: AND aid.parent_reversal_id is null
812: AND aid.line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX','TRV','TERV','TIPV')
813: AND nvl(aid.reversal_flag,'N')<>'Y'
814: AND EXISTS (SELECT 1
815: FROM financials_system_params_all fsp
816: WHERE fsp.org_id = aid.org_id
817: AND nvl(fsp.purch_encumbrance_flag, 'N') = 'Y');
818:
819: --End of bug 8733916

Line 1273: financials_system_params_all FSP

1269: -- Bug 9362054 : Begin
1270: SELECT COUNT(1)
1271: INTO l_unsuccessful_cancel
1272: FROM ap_invoice_distributions AID,
1273: financials_system_params_all FSP
1274: WHERE AID.invoice_id = P_invoice_id
1275: AND FSP.org_id = AID.org_id
1276: AND FSP.set_of_books_id = AID.set_of_books_id
1277: AND ( ( NVL( FSP.purch_encumbrance_flag, 'N' ) = 'Y'