APPS.AMS_DM_SCORE_PVT dependencies on DUAL

Line 411: FROM dual;

407: l_is_org_prod BOOLEAN;
408:
409: CURSOR c_id IS
410: SELECT ams_dm_scores_all_b_s.NEXTVAL
411: FROM dual;
412:
413: CURSOR c_id_exists (l_id IN NUMBER) IS
414: SELECT 1
415: FROM ams_dm_scores_all_b

Line 1542: IS SELECT 1 from dual

1538:
1539: l_valid_flag VARCHAR2(1);
1540:
1541: CURSOR c_score_name
1542: IS SELECT 1 from dual
1543: WHERE EXISTS ( SELECT * from ams_dm_scores_vl
1544: WHERE UPPER(score_name) = UPPER(p_score_rec.score_name)) ;
1545: CURSOR c_score_name_updt
1546: IS SELECT 1 from dual

Line 1546: IS SELECT 1 from dual

1542: IS SELECT 1 from dual
1543: WHERE EXISTS ( SELECT * from ams_dm_scores_vl
1544: WHERE UPPER(score_name) = UPPER(p_score_rec.score_name)) ;
1545: CURSOR c_score_name_updt
1546: IS SELECT 1 from dual
1547: WHERE EXISTS ( SELECT * from ams_dm_scores_vl
1548: WHERE UPPER(score_name) = UPPER(p_score_rec.score_name)
1549: AND score_id <> p_score_rec.score_id );
1550:

Line 3105: FROM dual

3101: l_dummy NUMBER;
3102:
3103: CURSOR c_scoring_model IS
3104: SELECT 1
3105: FROM dual
3106: WHERE EXISTS (SELECT 1
3107: FROM ams_dm_scores_all_b
3108: WHERE model_id = p_model_id
3109: AND status_code = G_STATUS_SCORING