APPS.AMS_STATUS_PVT dependencies on AMS_APPROVAL_RULES
Line 110: FROM ams_approval_rules
106: l_count NUMBER;
107:
108: CURSOR c_approval_rules IS
109: SELECT count(*) 110: FROM ams_approval_rules 111: WHERE arc_approval_for_object = p_arc_approval_for
112: AND approval_type = p_approval_type
113: AND (activity_type_code = p_activity_type_code
114: or activity_type_code IS NULL);