DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on PO_SYSTEM_PARAMETERS_ALL

Line 3036: po_system_parameters_all pspa

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
3040: AND TRUNC(SYSDATE) BETWEEN TRUNC(hou.date_from)

Line 3084: po_system_parameters_all pspa

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
3088: AND TRUNC(SYSDATE) BETWEEN TRUNC(hou.date_from)