APPS.OKS_MASSCHANGE_PVT dependencies on OKS_PM_SCHEDULES_V

Line 7070: SELECT count(*) FROM oks_pm_schedules_v

7066: AND okl.date_cancelled is NULL
7067: AND okl.lse_id in (1,12,14,19,46) ;
7068:
7069: CURSOR Get_cle_id_PM ( p_cle_id IN NUMBER ) IS
7070: SELECT count(*) FROM oks_pm_schedules_v
7071: WHERE cle_id = p_cle_id;
7072:
7073: CURSOR Get_act_time ( p_chr_id IN NUMBER , p_action_type_code VARCHAR2
7074: , p_old_value IN Varchar2) IS