DBA Data[Home] [Help]

APPS.AMW_LOAD_CONSTRAINT_DATA dependencies on DUAL

Line 450: FROM dual;

446:
447: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S
448: CURSOR c_constraint_rev_id IS
449: SELECT AMW_CONSTRAINT_REV_S.NEXTVAL
450: FROM dual;
451:
452: BEGIN
453: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S
454: OPEN c_constraint_rev_id;

Line 564: FROM dual;

560: l_objective_code VARCHAR2(30):=p_objective_code;
561: -- get constraint_rev_id from AMW_CONSTRAINT_REV_S
562: CURSOR c_constraint_rev_id IS
563: SELECT AMW_CONSTRAINT_REV_S.NEXTVAL
564: FROM dual;
565:
566: CURSOR c_classification(c_cst_rev_id number) IS
567: SELECT classification
568: FROM amw_constraints_b