APPS.PAY_IN_TAX_DECLARATION dependencies on HR_GENERAL

Line 272: AND NVL(date_to, hr_general.end_of_time);

268: WHERE person_id = p_person_id
269: AND primary_flag = 'Y'
270: AND style = 'IN'
271: AND p_effective_date BETWEEN date_from
272: AND NVL(date_to, hr_general.end_of_time);
273: --
274: l_lookup_code hr_lookups.lookup_code%TYPE;
275: l_procedure VARCHAR(100);
276: l_message VARCHAR2(250);

Line 308: pay_in_utils.trace('Decoded Lookup Code',hr_general.decode_lookup('IN_CITY_TYPE', l_lookup_code));

304: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
305:
306: IF g_debug THEN
307: pay_in_utils.trace('**************************************************','********************');
308: pay_in_utils.trace('Decoded Lookup Code',hr_general.decode_lookup('IN_CITY_TYPE', l_lookup_code));
309: pay_in_utils.trace('**************************************************','********************');
310: END IF;
311:
312:

Line 313: return hr_general.decode_lookup('IN_CITY_TYPE', l_lookup_code);

309: pay_in_utils.trace('**************************************************','********************');
310: END IF;
311:
312:
313: return hr_general.decode_lookup('IN_CITY_TYPE', l_lookup_code);
314:
315:
316:
317: END get_city_type;