APPS.GMD_RECIPE_DESIGNER_PKG dependencies on DUAL

Line 2032: FROM FND_DUAL;

2028: --FND_PROFILE.VALUE('LOGIN_ID');
2029:
2030: CURSOR Cur_recipe_id IS
2031: SELECT gmd_recipe_id_s.NEXTVAL
2032: FROM FND_DUAL;
2033:
2034:
2035: l_return_status VARCHAR2(5);
2036: l_owner_orgn_code VARCHAR2(4);

Line 2413: FROM SYS.DUAL;

2409: x_return_code OUT NOCOPY VARCHAR2,
2410: x_error_msg OUT NOCOPY VARCHAR2) IS
2411: CURSOR Cur_loss_id IS
2412: SELECT gmd_recipe_process_loss_id_s.NEXTVAL
2413: FROM SYS.DUAL;
2414:
2415: l_loss_tbl GMD_RECIPE_DETAIL.recipe_dtl;
2416: l_status VARCHAR2(30);
2417: l_msg_cnt NUMBER;

Line 3296: FROM sys.dual;

3292: line_no <> -1;
3293:
3294: CURSOR Get_text_code IS
3295: SELECT gem5_text_code_s.NEXTVAL
3296: FROM sys.dual;
3297:
3298: CURSOR Cur_recipe_id IS
3299: SELECT gmd_recipe_id_s.NEXTVAL
3300: FROM FND_DUAL;

Line 3300: FROM FND_DUAL;

3296: FROM sys.dual;
3297:
3298: CURSOR Cur_recipe_id IS
3299: SELECT gmd_recipe_id_s.NEXTVAL
3300: FROM FND_DUAL;
3301:
3302: CURSOR Cur_loss_id IS
3303: SELECT gmd_recipe_process_loss_id_s.NEXTVAL
3304: FROM FND_DUAL;

Line 3304: FROM FND_DUAL;

3300: FROM FND_DUAL;
3301:
3302: CURSOR Cur_loss_id IS
3303: SELECT gmd_recipe_process_loss_id_s.NEXTVAL
3304: FROM FND_DUAL;
3305:
3306: CURSOR Cur_vr_id IS
3307: SELECT gmd_recipe_validity_id_s.NEXTVAL
3308: FROM FND_DUAL;

Line 3308: FROM FND_DUAL;

3304: FROM FND_DUAL;
3305:
3306: CURSOR Cur_vr_id IS
3307: SELECT gmd_recipe_validity_id_s.NEXTVAL
3308: FROM FND_DUAL;
3309:
3310: TYPE rcp_pp IS TABLE OF Cur_get_pp%ROWTYPE INDEX BY BINARY_INTEGER;
3311: TYPE rcp_vr IS TABLE OF Cur_get_vr%ROWTYPE INDEX BY BINARY_INTEGER;
3312: TYPE rcp_rsrc IS TABLE OF Cur_get_rsrc%ROWTYPE INDEX BY BINARY_INTEGER;