APPS.JTF_TERR_CHANGES_REPORT_PVT dependencies on DUAL

Line 98: from dual;

94: l_response := p_response;
95:
96: select trunc(to_date(p_sd_date||'-'||p_sm_date||'-'||p_sy_date,'DD/MM/YYYY'))
97: into l_from_date
98: from dual;
99: select trunc(to_date(p_ed_date||'-'||p_em_date||'-'||p_ey_date,'DD/MM/YYYY'))
100: into l_to_date
101: from dual;
102:

Line 101: from dual;

97: into l_from_date
98: from dual;
99: select trunc(to_date(p_ed_date||'-'||p_em_date||'-'||p_ey_date,'DD/MM/YYYY'))
100: into l_to_date
101: from dual;
102:
103: /*
104: htp.p(l_from_date);
105: htp.br;

Line 396: from dual;

392:
393: -- fnd_client_info.set_org_context(fnd_profile.value_wnps('ORG_ID'));
394: SELECT FND_GLOBAL.TAB
395: INTO v_tab
396: from dual;
397:
398: --htp.p(v_tabrow);
399: v_tabrow := null;
400: -- display territories