APPS.PA_COPY_CHANGE_DOC_PVT dependencies on PA_CI_IMPACT_TYPE_USAGE

Line 97: from pa_ci_impact_type_usage Usg,

93:
94: cursor c_old_supp
95: is
96: select 'Y'
97: from pa_ci_impact_type_usage Usg,
98: pa_control_items ci
99: where usg.ci_type_id = ci.ci_type_id
100: and ci.ci_id = p_ci_id
101: and usg.impact_type_code = 'SUPPLIER';

Line 662: from pa_ci_impact_type_usage Usg,

658:
659: cursor c_old_supp
660: is
661: select 'Y'
662: from pa_ci_impact_type_usage Usg,
663: pa_control_items ci
664: where usg.ci_type_id = ci.ci_type_id
665: and ci.ci_id = p_ci_id
666: and usg.impact_type_code = 'SUPPLIER';