APPS.PQH_RBC_STAGE dependencies on FND_PROFILE

Line 191: select to_char(p_date_value1,fnd_profile.value('ICX_DATE_FORMAT_MASK'))

187: l_node_desc := l_node1_desc ;
188: end if;
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

Line 196: select to_char(p_date_value2,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
198: from dual;
199: hr_utility.set_location('val2 is '||l_node2_desc,40);
200: l_node_desc := l_node1_desc ||' - '||l_node2_desc;