APPS.PO_COPYDOC_SUB dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

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

2296: l_val_proj_error_code VARCHAR2(80);
2297: --
2298:
2299: l_return_status VARCHAR2(1); --< Bug 3265539 >
2300: l_ship_to_ou_id FINANCIALS_SYSTEM_PARAMS_ALL.org_id%TYPE; --< Bug 3265539 >
2301: l_is_complex_work_po BOOLEAN := FALSE; --Bug6314548
2302:
2303: --
2304: x_msg_application varchar2(30);

Line 3035: financials_system_params_all fspa,

3031: WHERE psg.key = l_key
3032: AND NOT EXISTS
3033: (SELECT 'is active ou'
3034: FROM hr_operating_units hou,
3035: financials_system_params_all fspa,
3036: po_system_parameters_all pspa
3037: WHERE hou.organization_id = psg.num1
3038: AND hou.organization_id = pspa.org_id
3039: AND pspa.org_id = fspa.org_id

Line 3083: financials_system_params_all fspa,

3079: WHERE psg.key = l_key
3080: AND (NOT EXISTS
3081: (SELECT 'is active ou'
3082: FROM hr_operating_units hou,
3083: financials_system_params_all fspa,
3084: po_system_parameters_all pspa
3085: WHERE hou.organization_id = psg.num2
3086: AND hou.organization_id = pspa.org_id
3087: AND pspa.org_id = fspa.org_id

Line 3094: FROM financials_system_params_all fspa1,

3090: )
3091: OR
3092: NOT EXISTS
3093: (SELECT 'encumbrance check'
3094: FROM financials_system_params_all fspa1,
3095: financials_system_params_all fspa2
3096: WHERE fspa1.org_id = psg.num1
3097: AND fspa2.org_id = psg.num2
3098: AND ( fspa1.org_id = fspa2.org_id

Line 3095: financials_system_params_all fspa2

3091: OR
3092: NOT EXISTS
3093: (SELECT 'encumbrance check'
3094: FROM financials_system_params_all fspa1,
3095: financials_system_params_all fspa2
3096: WHERE fspa1.org_id = psg.num1
3097: AND fspa2.org_id = psg.num2
3098: AND ( fspa1.org_id = fspa2.org_id
3099: OR