APPS.PAY_IN_TAX_DECLARATION dependencies on HR_GENERAL

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

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

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

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

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

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