APPS.CAC_VIEW_ACC_DAILY_VIEW_PVT dependencies on DUAL

Line 463: AND rt_ind.resource_type = 'INDIVIDUAL'

459: WHERE jta.resource_type_code = 'RS_TEAM'
460: AND jta.assignee_role = 'ASSIGNEE'
461: AND jta.task_id = p_task_id
462: AND rt_ind.team_id = jta.resource_id
463: AND rt_ind.resource_type = 'INDIVIDUAL'
464: AND rs.resource_id = rt_ind.team_resource_id
465: UNION
466: SELECT source_first_name||' '||source_last_name attendee_name
467: FROM jtf_rs_resource_extns rs

Line 686: FROM dual;

682: l_month_var VARCHAR2(80);
683: BEGIN
684: SELECT to_char(to_date('2000-'||to_char(p_occurs_month,'09')||'-01', 'YYYY-MM-DD'),'Month')
685: INTO l_month_var
686: FROM dual;
687:
688: RETURN rtrim(l_month_var);
689: EXCEPTION
690: WHEN OTHERS THEN