DBA Data[Home] [Help]

APPS.OCM_ADD_DATA_POINTS dependencies on AR_CMGT_DATA_POINTS_VL

Line 147: FROM ar_cmgt_data_points_vl

143: CURSOR getChildDataPointsC IS
144: SELECT data_point_id, package_name, function_name,
145: parent_data_point_id,
146: return_data_type, return_date_format
147: FROM ar_cmgt_data_points_vl
148: where enabled_flag = 'Y'
149: start with parent_data_point_id = p_parent_data_point_id
150: connect by prior data_point_id = parent_data_point_id
151: order by level;

Line 356: FROM ar_cmgt_data_points_vl

352: l_data_point_id NUMBER;
353: CURSOR getParentDataPoints IS
354: SELECT data_point_id,package_name, function_name, scorable_flag,
355: application_id, return_data_type, return_date_format
356: FROM ar_cmgt_data_points_vl
357: where enabled_flag = 'Y'
358: and data_point_category = 'ADDITIONAL'
359: and parent_data_point_id IS NULL
360: and ( application_id = 206 -- Added for bug 10304146