APPS.CSTPFCHK dependencies on DUAL

Line 810: -- FROM sys.dual)

806: -- i_prg_appl_id,
807: -- i_prg_id,
808: -- sysdate,
809: -- l_new_onhand
810: -- FROM sys.dual)
811: -- WHERE cpql.quantity_layer_id = i_qty_layer_id
812: -- AND EXISTS
813: -- (SELECT 'there is a layer'
814: -- FROM cst_pac_quantity_layers cpql

Line 1097: FROM dual;

1093: FOR l_prior_period_cost IN prior_period_cost_cursor LOOP
1094:
1095: SELECT cst_pac_item_costs_s.nextval
1096: INTO l_cost_layer_id
1097: FROM dual;
1098:
1099: -------------------------------------------
1100: -- Copy prior info of CST_PAC_ITEM_COSTS --
1101: -------------------------------------------

Line 1232: FROM dual;

1228: prior_period_quantity_cursor (l_prior_period_cost.cost_layer_id) LOOP
1229:
1230: SELECT cst_pac_quantity_layers_s.nextval
1231: INTO l_quantity_layer_id
1232: FROM dual;
1233:
1234: ------------------------------------------------
1235: -- Copy prior info of CST_PAC_QUANTITY_LAYERS --
1236: ------------------------------------------------