DBA Data[Home] [Help]

APPS.HR_AUBAL dependencies on HR_AU_ROUTES

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

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

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

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