APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on OKL_LEASEAPP_DATAPOINTS

Line 3098: okl_leaseapp_datapoints

3094:
3095: CURSOR c_get_leaseapp_datapoints IS
3096: SELECT id
3097: FROM
3098: okl_leaseapp_datapoints
3099: WHERE
3100: leaseapp_id = p_leaseapp_id;
3101:
3102: BEGIN

Line 3152: okl_leaseapp_datapoints

3148:
3149: CURSOR c_get_leaseapp_datapoints IS
3150: SELECT count(*)
3151: FROM
3152: okl_leaseapp_datapoints
3153: WHERE
3154: leaseapp_id = p_leaseapp_id;
3155:
3156: BEGIN

Line 3175: lv_data_point_value okl_leaseapp_datapoints.data_point_value%TYPE;

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

Line 3183: FROM OKL_LEASEAPP_DATAPOINTS

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