APPS.CSTPPWAC dependencies on DUAL

Line 3638: FROM dual) temp

3634: CSTPPINV.l_level_type_tbl(l_index) level_type,
3635: CSTPPINV.l_txn_category_tbl(l_index) txn_category,
3636: l_category_qty_tbl (l_index) category_quantity,
3637: CSTPPINV.l_item_balance_tbl(l_index) category_balance
3638: FROM dual) temp
3639: ON ( cppb.pac_period_id = temp.pac_period_id
3640: AND cppb.cost_layer_id = temp.cost_layer_id
3641: AND cppb.cost_element_id = temp.cost_element_id
3642: AND cppb.level_type = temp.level_type

Line 3753: FROM dual

3749: 0,
3750: CSTPPINV.l_item_balance_tbl (l_index),
3751: CSTPPINV.l_make_balance_tbl (l_index),
3752: CSTPPINV.l_buy_balance_tbl (l_index)
3753: FROM dual
3754: WHERE NOT EXISTS (SELECT 1
3755: FROM cst_pac_item_cost_details cpicd1
3756: WHERE cpicd1.cost_layer_id = CSTPPINV.l_cost_layer_id_tbl (l_index)
3757: AND cpicd1.cost_element_id = CSTPPINV.l_cost_element_id_tbl (l_index)

Line 3798: FROM sys.dual)

3794: i_prog_appl_id,
3795: i_prog_id,
3796: sysdate,
3797: l_new_qty_tbl (l_index)
3798: FROM sys.dual)
3799: WHERE cpql.quantity_layer_id = CSTPPINV.l_qty_layer_id_tbl (l_index)
3800: AND EXISTS
3801: (SELECT 'there is a layer'
3802: FROM cst_pac_quantity_layers cpql