APPS.PA_CONTROL_ITEMS_UTILS dependencies on PA_CLASS_CODES
Line 1629: pa_class_codes cc
1625: BEGIN
1626: SELECT 1
1627: INTO tmp
1628: FROM pa_control_items ci, 1629: pa_class_codes cc 1630: WHERE cc.class_category = p_class_category
1631: AND cc.class_code = p_class_code
1632: AND ( ci.classification_code_id = cc.class_code_id
1633: OR ci.reason_code_id = cc.class_code_id