APPS.CSC_CUST_PLANS_PVT dependencies on CSC_PLAN_HEADERS_B

Line 244: from csc_plan_headers_b

240: -- it into the cust_plans table, if they are passed in as nulls.
241: cursor c1( c_plan_id number ) is
242: select start_date_active,
243: end_date_active
244: from csc_plan_headers_b
245: where plan_id = c_plan_id;
246:
247: l_api_name CONSTANT VARCHAR2(30) := 'Create_cust_plans';
248: l_api_version_number CONSTANT NUMBER := 1.0;

Line 307: -- retreive these value from the csc_plan_headers_b table for the given plan_id;

303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305:
306: -- if either start_date_active or end_date_active is passed in as null, then
307: -- retreive these value from the csc_plan_headers_b table for the given plan_id;
308:
309: if (( p_csc_cust_plans_rec.START_DATE_ACTIVE is NULL OR
310: p_csc_cust_plans_rec.START_DATE_ACTIVE = FND_API.G_MISS_DATE ) OR
311: ( p_csc_cust_plans_rec.END_DATE_ACTIVE is NULL OR

Line 1476: from csc_plan_headers_b

1472: )
1473: IS
1474: cursor c1 is
1475: select plan_id
1476: from csc_plan_headers_b
1477: where plan_id = p_plan_id;
1478:
1479: l_plan_id number;
1480: l_api_name varchar2(30) := 'Validate_Plan_Id';