APPS.IEX_SCORE_PVT dependencies on DUAL

Line 346: FROM sys.dual;

342: X_SCORE_ID OUT NOCOPY NUMBER)
343: IS
344: CURSOR get_seq_csr is
345: SELECT IEX_SCORES_S.nextval
346: FROM sys.dual;
347: --
348: l_api_name CONSTANT VARCHAR2(30) := 'Create_Score';
349: l_api_version_number CONSTANT NUMBER := 1.0;
350: l_return_status VARCHAR2(1);

Line 1076: FROM sys.dual;

1072:
1073: IS
1074: CURSOR get_seq_csr is
1075: SELECT IEX_SCORE_COMPONENTS_S.nextval
1076: FROM sys.dual;
1077: --
1078:
1079: l_api_name CONSTANT VARCHAR2(30) := 'Create_Score_Comp';
1080: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1655: FROM sys.dual;

1651:
1652: IS
1653: CURSOR get_seq_csr is
1654: SELECT IEX_SCORE_COMP_TYPES_B_S.nextval
1655: FROM sys.dual;
1656: --
1657:
1658: l_api_name CONSTANT VARCHAR2(30) := 'Create_Score_Comp_Type';
1659: l_api_version_number CONSTANT NUMBER := 1.0;

Line 2214: FROM sys.dual;

2210:
2211: IS
2212: CURSOR get_seq_csr is
2213: SELECT IEX_SCORE_COMP_DET_S.nextval
2214: FROM sys.dual;
2215: --
2216: l_api_name CONSTANT VARCHAR2(30) := 'Create_Score_Comp_Det';
2217: l_api_version_number CONSTANT NUMBER := 1.0;
2218: l_return_status VARCHAR2(1);

Line 3454: FROM dual;

3450: /* UPDATE IEX_SCORE_HISTORIES with the collections score, score_id, and last_score_date */
3451: /*
3452: SELECT IEX_SCORE_HISTORIES_S.nextval
3453: INTO l_score_history_id
3454: FROM dual;
3455:
3456: IEX_SCORE_HISTORIES_PKG.Insert_Row(X_ROWID => l_rowid,
3457: P_SCORE_HISTORY_ID => l_score_history_id,
3458: P_OBJECT_VERSION_NUMBER => 1,