DBA Data[Home] [Help]

APPS.HR_AUBAL dependencies on HR_AU_ROUTES

Line 1135: l_start_dd_mm := to_char(hr_AU_routes.get_fiscal_date(l_business_group_id),'dd-mm-');

1131: --
1132: open csr_business_group(p_assignment_id);
1133: fetch csr_business_group into l_business_group_id;
1134: close csr_business_group;
1135: l_start_dd_mm := to_char(hr_AU_routes.get_fiscal_date(l_business_group_id),'dd-mm-');
1136: --
1137: if p_effective_date >= get_expired_year_date(l_action_eff_date, l_start_dd_mm) then
1138: l_balance := 0;
1139: else

Line 1280: if p_effective_date > hr_AU_routes.fiscal_span_start(add_months(l_action_eff_date,4),4,l_business_group_id) then

1276: --
1277: -- is effective date (sess) later than the expiry of the fiscal quarter ( the start of the
1278: -- next fiscal quarter) of the effective date.
1279: --
1280: if p_effective_date > hr_AU_routes.fiscal_span_start(add_months(l_action_eff_date,4),4,l_business_group_id) then
1281: l_balance := 0;
1282: else
1283: --
1284: l_balance := calc_asg_fy_qtd ( p_assignment_action_id => l_assignment_action_id