APPS.PQH_RBC_STAGE dependencies on DUAL

Line 193: from dual;

189: elsif p_crit_col_dtyp ='D' then
190: hr_utility.set_location('Date based vset',40);
191: select to_char(p_date_value1,fnd_profile.value('ICX_DATE_FORMAT_MASK'))
192: into l_node1_desc
193: from dual;
194: hr_utility.set_location('val1 is '||l_node1_desc,40);
195: if p_range_flag = 'Y' and p_date_value2 is not null then
196: select to_char(p_date_value2,fnd_profile.value('ICX_DATE_FORMAT_MASK'))
197: into l_node2_desc

Line 198: from dual;

194: hr_utility.set_location('val1 is '||l_node1_desc,40);
195: if p_range_flag = 'Y' and p_date_value2 is not null then
196: select to_char(p_date_value2,fnd_profile.value('ICX_DATE_FORMAT_MASK'))
197: into l_node2_desc
198: from dual;
199: hr_utility.set_location('val2 is '||l_node2_desc,40);
200: l_node_desc := l_node1_desc ||' - '||l_node2_desc;
201: else
202: l_node_desc := l_node1_desc ;