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 3106: FROM dual;

3102: stmt_num := 440;
3103:
3104: SELECT wip_transactions_s.nextval
3105: INTO l_wcti_txn_id
3106: FROM dual;
3107:
3108: ----------------------------------------------------------------
3109: -- Insert into WCTI
3110: ----------------------------------------------------------------

Line 3749: FROM dual

3745: and quantity_per_assembly <>0;
3746: */
3747: SELECT COUNT(1)
3748: INTO l_qty_per_assy
3749: FROM dual
3750: WHERE EXISTS ( SELECT NULL
3751: FROM wip_requirement_operations wro
3752: WHERE wro.wip_entity_id = i_wip_entity_id
3753: AND wro.quantity_per_assembly <>0