APPS.PAY_IN_TAX_UTILS dependencies on PAY_PAYROLLS_F

Line 35: from pay_payrolls_f

31: g_debug := hr_utility.debug_enabled;
32: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
33:
34: select to_number(nvl(PAY_DATE_OFFSET,0)),PRL_INFORMATION1 into l_date_offset,l_pub_sect_flag
35: from pay_payrolls_f
36: where payroll_id = p_payroll_id
37: and p_date between EFFECTIVE_START_DATE and EFFECTIVE_end_date;
38:
39:

Line 128: from pay_payrolls_f

124: g_debug := hr_utility.debug_enabled;
125: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
126: l_end_date := '01-FEB-';
127: select to_number(nvl(PAY_DATE_OFFSET,0)),PRL_INFORMATION1 into l_date_offset,l_pub_sect_flag
128: from pay_payrolls_f
129: where payroll_id = p_payroll_id
130: and p_date between EFFECTIVE_START_DATE and EFFECTIVE_end_date;
131:
132:

Line 573: from pay_payrolls_f

569: pay_in_utils.set_location(g_debug,l_procedure, 20);
570: hr_utility.trace('l_effective_date'||l_effective_date);
571:
572: select to_number(nvl(PAY_DATE_OFFSET,0)),PRL_INFORMATION1 into l_date_offset,l_pub_sect_flag
573: from pay_payrolls_f
574: where payroll_id = p_payroll_id
575: and l_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_end_date;
576:
577: pay_in_utils.set_location(g_debug,l_procedure, 30);