APPS.OCM_DATA_POINTS_PUB dependencies on AR_LOOKUPS

Line 105: FROM ar_lookups

101: IF p_data_point_sub_category IS NOT NULL
102: THEN
103: BEGIN
104: SELECT 'x' INTO l_check_flag
105: FROM ar_lookups
106: WHERE lookup_type = 'OCM_USER_DATA_POINT_CATEGORIES'
107: AND lookup_code = p_data_point_sub_category
108: AND enabled_flag = 'Y'
109: AND trunc(sysdate) between trunc(start_date_active)

Line 131: FROM ar_lookups

127: IF p_data_point_category IS NOT NULL
128: THEN
129: BEGIN
130: SELECT 'x' INTO l_check_flag
131: FROM ar_lookups
132: WHERE lookup_type = 'AR_CMGT_DATA_POINT_CATEGORY'
133: AND lookup_code = p_data_point_category
134: AND enabled_flag = 'Y'
135: AND trunc(sysdate) between trunc(start_date_active)