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