APPS.CRP_FORM_PK dependencies on CRP_CAPACITY_PLANS

Line 214: from crp_capacity_plans cap

210: least(NVL(PERIOD15,100000000),
211: least(NVL(PERIOD16,100000000),
212: least(NVL(PERIOD17,100000000),
213: least(NVL(PERIOD18,100000000))))))))))))))))))), 2)
214: from crp_capacity_plans cap
215: where cap.type_id = 5
216: and cap.line_id = query.number5
217: and cap.query_id = arg_query_id1)
218: where query_id = arg_query_id2

Line 266: from crp_capacity_plans cap

262: least(NVL(PERIOD33,100000000),
263: least(NVL(PERIOD34,100000000),
264: least(NVL(PERIOD35,100000000),
265: NVL(PERIOD36, 100000000)))))))))))))))))))), 2)
266: from crp_capacity_plans cap
267: where cap.type_id = 5
268: and cap.line_id = query.number5
269: and cap.query_id = arg_query_id1)
270: where query_id = arg_query_id2

Line 324: from crp_capacity_plans cap

320: least(NVL(PERIOD15,100000000),
321: least(NVL(PERIOD16,100000000),
322: least(NVL(PERIOD17,100000000),
323: least(NVL(PERIOD18,100000000))))))))))))))))))), 2)
324: from crp_capacity_plans cap
325: where cap.type_id = 5
326: and cap.resource_id = query.number3
327: and cap.department_id = query.number2
328: and cap.query_id = arg_query_id1)

Line 373: from crp_capacity_plans cap

369: least(NVL(PERIOD33,100000000),
370: least(NVL(PERIOD34,100000000),
371: least(NVL(PERIOD35,100000000),
372: NVL(PERIOD36, 100000000))))))))))))))))))), 2)
373: from crp_capacity_plans cap
374: where cap.type_id = 5
375: and cap.resource_id = query.number3
376: and cap.department_id = query.number2
377: and cap.query_id = arg_query_id1)

Line 431: FROM crp_capacity_plans

427: number3
428: FROM crp_form_query query
429: WHERE not exists
430: (SELECT null
431: FROM crp_capacity_plans
432: WHERE query_id = arg_session_id
433: AND department_id = query.number2
434: AND resource_id = query.number3)
435: AND number13 = 1

Line 457: FROM crp_capacity_plans

453: number5
454: FROM crp_form_query query
455: WHERE not exists
456: (SELECT null
457: FROM crp_capacity_plans
458: WHERE query_id = arg_session_id
459: AND line_id = query.number5)
460: AND number13 = 1
461: AND query.query_id = arg_query_id1;

Line 470: update crp_capacity_plans plan

466: END crp_resource_list;
467:
468: PROCEDURE crp_upd_dept_class(arg_query_id NUMBER) IS
469: BEGIN
470: update crp_capacity_plans plan
471: set department_class =
472: (select department_class_code
473: from bom_departments
474: where department_id = plan.department_id),