DBA Data[Home] [Help]

APPS.PA_CI_IMPACT_TYPE_USAGE_PUB dependencies on PA_CONTROL_ITEMS

Line 283: pa_control_items pci,

279: SELECT 'N'
280: INTO l_dummy
281: FROM dual
282: WHERE exists (Select pci.ci_id from
283: pa_control_items pci,
284: pa_ci_impacts pc
285: where pci.ci_type_id = p_ci_type_id
286: and pci.ci_id = pc.ci_id
287: and pc.impact_type_code = p_impact_type_code