APPS.IEM_DP_MONITORING_PVT dependencies on IEM_EMTA_CONFIG_PARAMS

Line 914: select count(*) into l_count from iem_emta_config_params

910:
911: if ( l_proc_status is null ) then
912: l_processor_status(i) := 'notstartedind_active.gif';
913: elsif ( l_proc_status < sysdate-1/(24*12)-l_pre_sleep*(1/(24*60*60*1000))) then
914: select count(*) into l_count from iem_emta_config_params
915: where email_account_id=v_res.email_account_id
916: and Account_update_flag='N'
917: and action_type='active';
918: if ( l_count > 0 ) then

Line 974: select count(*) into l_count from iem_emta_config_params

970: else
971: if ( l_proc_status is null ) then
972: l_processor_status(i) := 'notstartedind_active.gif';
973: elsif ( l_proc_status < sysdate-1/(24*12)-l_pre_sleep*(1/(24*60*60*1000))) then
974: select count(*) into l_count from iem_emta_config_params
975: where email_account_id=v_res.email_account_id
976: and Account_update_flag='N'
977: and action_type='active';
978: if ( l_count > 0 ) then