APPS.CSTPPCIC dependencies on DUAL

Line 270: from dual

266:
267:
268: select 1
269: into l_valid
270: from dual
271: where p_from_cost_group_id in
272: (select distinct cost_group
273: from cst_cost_groups
274: where legal_entity = p_legal_entity

Line 302: from dual

298:
299:
300: select 1
301: into l_valid
302: from dual
303: where p_period_id in
304: (select distinct pac_period_id
305: from cst_pac_process_phases
306: where cost_group_id = p_from_cost_group_id

Line 322: from dual

318:
319:
320: select 1
321: into l_valid
322: from dual
323: where p_to_org_id in
324: (
325: (select distinct CCGA.organization_id
326: from cst_cost_group_assignments CCGA

Line 346: from dual

342:
343:
344: select 1
345: into l_valid
346: from dual
347: where p_to_cost_type_id in
348: (select distinct cost_type_id
349: from cst_cost_types
350: where organization_id = p_to_org_id

Line 370: from dual

366:
367:
368: select 1
369: into l_valid
370: from dual
371: where p_material in
372: (select resource_id
373: from bom_resources
374: where organization_id = p_to_org_id

Line 393: from dual

389:
390:
391: select 1
392: into l_valid
393: from dual
394: where p_material_overhead in
395: (select resource_id
396: from bom_resources
397: where organization_id = p_to_org_id

Line 414: from dual

410:
411:
412: select 1
413: into l_valid
414: from dual
415: where p_resource in
416: (select resource_id
417: from bom_resources
418: where organization_id = p_to_org_id

Line 436: from dual

432:
433:
434: select 1
435: into l_valid
436: from dual
437: where p_outside_processing in
438: (select resource_id
439: from bom_resources
440: where organization_id = p_to_org_id

Line 457: from dual

453:
454:
455: select 1
456: into l_valid
457: from dual
458: where p_overhead in
459: (select resource_id
460: from bom_resources
461: where organization_id = p_to_org_id

Line 479: from dual

475:
476:
477: select 1
478: into l_valid
479: from dual
480: where p_copy_option in (1,2,3);
481:
482: l_valid := 0;
483:

Line 492: from dual

488:
489:
490: select 1
491: into l_valid
492: from dual
493: where p_range in (1,2,5);
494:
495:
496: IF (l_valid <> 1) THEN

Line 590: FROM dual;

586:
587: l_grp_id := 0;
588:
589: SELECT CST_LISTS_S.NEXTVAL INTO l_grp_id
590: FROM dual;
591:
592: INSERT INTO cst_item_costs_interface
593: ( inventory_item_id
594: , cost_type_id

Line 1276: FROM dual;

1272:
1273: l_grp_id := 0;
1274:
1275: SELECT CST_LISTS_S.NEXTVAL INTO l_grp_id
1276: FROM dual;
1277:
1278: INSERT INTO cst_item_costs_interface
1279: ( inventory_item_id
1280: , cost_type_id