APPS.CSTPACWC dependencies on DUAL

Line 212: FROM dual

208: and quantity_per_assembly <>0;
209: */
210: SELECT count(1)
211: INTO l_qty_per_assy
212: FROM dual
213: WHERE EXISTS ( SELECT NULL
214: FROM wip_requirement_operations wro
215: WHERE wro.wip_entity_id = i_wip_entity_id
216: AND wro.quantity_per_assembly <>0

Line 286: * lances to figure out the residual costs in the Job. *

282: * the job has no bill and no routing. *
283: * ------------------------------------------------------- *
284: * In this case, we do not maintain costs for resources, *
285: * ovhds, components in our tables. We go to wip_period_ba- *
286: * lances to figure out the residual costs in the Job. *
287: * *
288: * Note : *
289: * For automatic final completion, the condition is *
290: * satisfied if : *

Line 2970: FROM dual;

2966: stmt_num := 440;
2967:
2968: SELECT wip_transactions_s.nextval
2969: INTO l_wcti_txn_id
2970: FROM dual;
2971:
2972: ----------------------------------------------------------------
2973: -- Insert into WCTI
2974: ----------------------------------------------------------------

Line 3584: FROM dual

3580: and quantity_per_assembly <>0;
3581: */
3582: SELECT COUNT(1)
3583: INTO l_qty_per_assy
3584: FROM dual
3585: WHERE EXISTS ( SELECT NULL
3586: FROM wip_requirement_operations wro
3587: WHERE wro.wip_entity_id = i_wip_entity_id
3588: AND wro.quantity_per_assembly <>0