APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on OKL_LEASEAPP_DATAPOINTS

Line 3101: okl_leaseapp_datapoints

3097:
3098: CURSOR c_get_leaseapp_datapoints IS
3099: SELECT id
3100: FROM
3101: okl_leaseapp_datapoints
3102: WHERE
3103: leaseapp_id = p_leaseapp_id;
3104:
3105: BEGIN

Line 3155: okl_leaseapp_datapoints

3151:
3152: CURSOR c_get_leaseapp_datapoints IS
3153: SELECT count(*)
3154: FROM
3155: okl_leaseapp_datapoints
3156: WHERE
3157: leaseapp_id = p_leaseapp_id;
3158:
3159: BEGIN

Line 3178: lv_data_point_value okl_leaseapp_datapoints.data_point_value%TYPE;

3174:
3175: l_lease_app_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_column1);
3176: l_data_point_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id);
3177:
3178: lv_data_point_value okl_leaseapp_datapoints.data_point_value%TYPE;
3179:
3180: BEGIN
3181: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
3182: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 3186: FROM OKL_LEASEAPP_DATAPOINTS

3182: x_resultout := FND_API.G_RET_STS_SUCCESS;
3183: BEGIN
3184: SELECT DATA_POINT_VALUE
3185: INTO lv_data_point_value
3186: FROM OKL_LEASEAPP_DATAPOINTS
3187: WHERE DATA_POINT_ID = l_data_point_id
3188: AND LEASEAPP_ID = l_lease_app_id;
3189:
3190: EXCEPTION