2769: hr_utility.raise_error;
2770: end if;
2771:
2772: select nvl(PRL_INFORMATION1,'N'),nvl(PAY_DATE_OFFSET,0) into l_public_sector_flag,l_date_offset 2773: from pay_payrolls_f 2774: where PAYROLL_ID=p_payroll_id
2775: and sysdate between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
2776:
2777: if l_public_sector_flag ='Y' then