APPS.FEM_INTG_DIM_RULE_ENG_PKG dependencies on DUAL

Line 707: FROM DUAL;

703: --
704:
705: SELECT FEM_VALUE_SETS_B_S.nextval
706: INTO pv_fem_vs_id
707: FROM DUAL;
708:
709: pv_progress := 'insert fem vs into aol mapping table';
710:
711: INSERT INTO FEM_INTG_AOL_VALSET_MAP(

Line 971: FROM DUAL;

967: pv_progress := 'insert newly created company vset into aol mapping table';
968:
969: SELECT FEM_VALUE_SETS_B_S.nextval
970: INTO pv_com_vs_id
971: FROM DUAL;
972:
973: INSERT INTO FEM_INTG_AOL_VALSET_MAP
974: (
975: FEM_VALUE_SET_ID,

Line 1072: FROM DUAL;

1068:
1069:
1070: SELECT FEM_VALUE_SETS_B_S.nextval
1071: INTO pv_cc_vs_id
1072: FROM DUAL;
1073:
1074: pv_progress := 'insert newly created cc vset into aol mapping table';
1075:
1076: INSERT INTO FEM_INTG_AOL_VALSET_MAP

Line 1193: FROM DUAL;

1189: WHERE dimension_id = pv_com_dim_id;
1190: ELSE
1191: SELECT FEM_VALUE_SETS_B_S.nextval
1192: INTO pv_com_vs_id
1193: FROM DUAL;
1194: END IF;
1195:
1196: INSERT INTO FEM_INTG_AOL_VALSET_MAP
1197: (

Line 1274: FROM DUAL;

1270: WHERE dimension_id = pv_cc_dim_id;
1271: ELSE
1272: SELECT FEM_VALUE_SETS_B_S.nextval
1273: INTO pv_cc_vs_id
1274: FROM DUAL;
1275: END IF;
1276:
1277: INSERT INTO FEM_INTG_AOL_VALSET_MAP
1278: (