DBA Data[Home] [Help]

APPS.OCM_ADD_DATA_POINTS dependencies on AR_CMGT_DATA_POINTS_VL

Line 136: FROM ar_cmgt_data_points_vl

132: CURSOR getChildDataPointsC IS
133: SELECT data_point_id, package_name, function_name,
134: parent_data_point_id,
135: return_data_type, return_date_format
136: FROM ar_cmgt_data_points_vl
137: where enabled_flag = 'Y'
138: start with parent_data_point_id = p_parent_data_point_id
139: connect by prior data_point_id = parent_data_point_id
140: order by level;

Line 288: FROM ar_cmgt_data_points_vl

284: l_data_point_id NUMBER;
285: CURSOR getParentDataPoints IS
286: SELECT data_point_id,package_name, function_name, scorable_flag,
287: application_id, return_data_type, return_date_format
288: FROM ar_cmgt_data_points_vl
289: where enabled_flag = 'Y'
290: and data_point_category = 'ADDITIONAL'
291: and parent_data_point_id IS NULL
292: and ( application_id = pg_ocm_add_dp_param_rec.p_SOURCE_RESP_APPLN_ID