APPS.GMD_SPREAD_FETCH_PKG dependencies on DUAL

Line 904: FROM dual;

900: WHERE entity_id = V_entity_id;
901:
902: CURSOR Cur_formulaline_id IS
903: SELECT gem5_formulaline_id_s.NEXTVAL
904: FROM dual;
905:
906: CURSOR Cur_spreadline_id IS
907: SELECT gem5_sprd_line_id_s.nextval
908: FROM dual;

Line 908: FROM dual;

904: FROM dual;
905:
906: CURSOR Cur_spreadline_id IS
907: SELECT gem5_sprd_line_id_s.nextval
908: FROM dual;
909:
910: CURSOR Cur_get_materials (Pline_id NUMBER) IS
911: SELECT *
912: FROM gmd_material_details_gtmp

Line 1215: FROM fnd_dual;

1211: V_maintain_type IN NUMBER,V_text_code IN NUMBER,
1212: V_last_update_date IN DATE,V_move_order_header_id IN NUMBER) IS
1213: CURSOR Cur_sprd_id IS
1214: SELECT gem5_sprd_id_s.nextval
1215: FROM fnd_dual;
1216:
1217: CURSOR Cur_line_id IS
1218: SELECT gem5_sprd_line_id_s.nextval
1219: FROM fnd_dual;

Line 1219: FROM fnd_dual;

1215: FROM fnd_dual;
1216:
1217: CURSOR Cur_line_id IS
1218: SELECT gem5_sprd_line_id_s.nextval
1219: FROM fnd_dual;
1220:
1221: CURSOR Cur_sprd_insert IS
1222: SELECT line_id,V_orgn_id,move_order_line_id,line_type,formulaline_id,
1223: material_detail_id,line_no,rollup_ind,inventory_item_id,qty,detail_uom,