DBA Data[Home] [Help]

APPS.AMS_DM_SCORE_PVT dependencies on AMS_CUSTOM_SETUPS_B

Line 428: FROM ams_custom_setups_b

424: -- Changed cursor to retrieve custom_setup_id = 145 or 146 (for cue card menu
425: -- with optimal targeting option) depending on Scoring Run Type
426: CURSOR c_custom_setup_id IS
427: SELECT custom_setup_id
428: FROM ams_custom_setups_b
429: WHERE object_type = G_OBJECT_TYPE_SCORE
430: AND activity_type_code IS NULL
431: AND enabled_flag = 'Y'
432: ;

Line 435: FROM ams_custom_setups_b

431: AND enabled_flag = 'Y'
432: ;
433: CURSOR c_custom_setup_id_otgt IS
434: SELECT custom_setup_id
435: FROM ams_custom_setups_b
436: WHERE object_type = G_OBJECT_TYPE_SCORE
437: AND activity_type_code = G_OTGT_ACTIVITY_TYPE
438: AND enabled_flag = 'Y'
439: ;