APPS.PO_COPYDOC_SUB dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 2446: l_ship_to_ou_id FINANCIALS_SYSTEM_PARAMS_ALL.org_id%TYPE; --< Bug 3265539 >

2442: l_val_proj_error_code VARCHAR2(80);
2443: --
2444:
2445: l_return_status VARCHAR2(1); --< Bug 3265539 >
2446: l_ship_to_ou_id FINANCIALS_SYSTEM_PARAMS_ALL.org_id%TYPE; --< Bug 3265539 >
2447: l_is_complex_work_po BOOLEAN := FALSE; --Bug6314548
2448: l_clm_flag VARCHAR2(1) := 'N'; --CLM
2449:
2450: --

Line 3229: financials_system_params_all fspa,

3225: WHERE psg.key = l_key
3226: AND NOT EXISTS
3227: (SELECT 'is active ou'
3228: FROM hr_operating_units hou,
3229: financials_system_params_all fspa,
3230: po_system_parameters_all pspa
3231: WHERE hou.organization_id = psg.num1
3232: AND hou.organization_id = pspa.org_id
3233: AND pspa.org_id = fspa.org_id

Line 3277: financials_system_params_all fspa,

3273: WHERE psg.key = l_key
3274: AND (NOT EXISTS
3275: (SELECT 'is active ou'
3276: FROM hr_operating_units hou,
3277: financials_system_params_all fspa,
3278: po_system_parameters_all pspa
3279: WHERE hou.organization_id = psg.num2
3280: AND hou.organization_id = pspa.org_id
3281: AND pspa.org_id = fspa.org_id

Line 3288: FROM financials_system_params_all fspa1,

3284: )
3285: OR
3286: NOT EXISTS
3287: (SELECT 'encumbrance check'
3288: FROM financials_system_params_all fspa1,
3289: financials_system_params_all fspa2
3290: WHERE fspa1.org_id = psg.num1
3291: AND fspa2.org_id = psg.num2
3292: AND ( fspa1.org_id = fspa2.org_id

Line 3289: financials_system_params_all fspa2

3285: OR
3286: NOT EXISTS
3287: (SELECT 'encumbrance check'
3288: FROM financials_system_params_all fspa1,
3289: financials_system_params_all fspa2
3290: WHERE fspa1.org_id = psg.num1
3291: AND fspa2.org_id = psg.num2
3292: AND ( fspa1.org_id = fspa2.org_id
3293: OR