DBA Data[Home] [Help]

APPS.PAY_SE_ABSENCE_USER dependencies on PAY_SE_HOLIDAY_PAY

Line 686: l_earn_year:=PAY_SE_HOLIDAY_PAY.Get_Earning_Year(p_date_earned,p_tax_unit_id);

682: AND hoi4.org_information1 IS NOT NULL;
683:
684: BEGIN
685: /*Get the Earn Year end date*/
686: l_earn_year:=PAY_SE_HOLIDAY_PAY.Get_Earning_Year(p_date_earned,p_tax_unit_id);
687: OPEN csr_end_earn_month(p_assignment_id,p_date_earned,p_business_group_id);
688: FETCH csr_end_earn_month INTO l_end_month;
689: CLOSE csr_end_earn_month;
690: l_earning_end_date:=last_day(to_date('01/'||l_end_month|| '/' ||l_earn_year,'dd/mm/yyyy'));