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

1088: FOR l_prior_period_cost IN prior_period_cost_cursor LOOP
1089:
1090: SELECT cst_pac_item_costs_s.nextval
1091: INTO l_cost_layer_id
1092: FROM dual;
1093:
1094: -------------------------------------------
1095: -- Copy prior info of CST_PAC_ITEM_COSTS --
1096: -------------------------------------------

Line 1227: FROM dual;

1223: prior_period_quantity_cursor (l_prior_period_cost.cost_layer_id) LOOP
1224:
1225: SELECT cst_pac_quantity_layers_s.nextval
1226: INTO l_quantity_layer_id
1227: FROM dual;
1228:
1229: ------------------------------------------------
1230: -- Copy prior info of CST_PAC_QUANTITY_LAYERS --
1231: ------------------------------------------------