DBA Data[Home] [Help]

APPS.PA_CI_IMPACT_TYPE_USAGE_PUB dependencies on PA_CONTROL_ITEMS

Line 186: pa_control_items pci,

182: SELECT 'N'
183: INTO l_dummy
184: FROM dual
185: WHERE exists (Select pci.ci_id from
186: pa_control_items pci,
187: pa_ci_impacts pc
188: where pci.ci_type_id = p_ci_type_id
189: and pci.ci_id = pc.ci_id
190: and pc.impact_type_code = p_impact_type_code