APPS.PA_CONTROL_ITEMS_UTILS dependencies on PA_CLASS_CODES
Line 1533: pa_class_codes cc
1529: BEGIN
1530: SELECT 1
1531: INTO tmp
1532: FROM pa_control_items ci, 1533: pa_class_codes cc 1534: WHERE cc.class_category = p_class_category
1535: AND cc.class_code = p_class_code
1536: AND ( ci.classification_code_id = cc.class_code_id
1537: OR ci.reason_code_id = cc.class_code_id