APPS.HXC_INLINE_NOTIF_UTILS_PKG dependencies on FND_GLOBAL

Line 68: l_query := ' select hta.'||p_column||fnd_global.local_chr('10');

64: hr_utility.trace(' p_det_bb_id '||p_det_bb_id);
65: hr_utility.trace(' p_det_bb_ovn '||p_det_bb_ovn);
66: end if;
67:
68: l_query := ' select hta.'||p_column||fnd_global.local_chr('10');
69:
70: if(p_get_type = c_new_get_type) then
71: if p_context like 'PAEXPITDFF%' THEN
72: l_query := l_query ||

Line 191: l_query := l_query || fnd_global.local_chr('10') ||'and date_to = hr_general.end_of_time';

187: where time_building_block_id = :p_det_bb_id
188: and object_version_number = :p_det_bb_ovn';
189:
190: if(p_get_type=c_new_get_type) then
191: l_query := l_query || fnd_global.local_chr('10') ||'and date_to = hr_general.end_of_time';
192: end if;
193:
194: OPEN tbb_cr FOR l_query USING p_det_bb_id,p_det_bb_ovn;
195: FETCH tbb_cr INTO l_value;