DBA Data[Home] [Help]

APPS.HR_NZBAL dependencies on HR_NZ_ROUTES

Line 834: l_start_dd_mm := to_char(hr_nz_routes.get_anniversary_date(l_assignment_action_id, l_action_eff_date),'dd-mm-');

830: --
831: -- is effective date (sess) later than the expiry of the financial year of the
832: -- effective date.
833: --
834: l_start_dd_mm := to_char(hr_nz_routes.get_anniversary_date(l_assignment_action_id, l_action_eff_date),'dd-mm-');
835: --
836: if p_effective_date >= get_expired_year_date(l_action_eff_date, l_start_dd_mm) then /*3072939*/
837: l_balance := 0;
838: else

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

962: --
963: open csr_business_group(p_assignment_id);
964: fetch csr_business_group into l_business_group_id;
965: close csr_business_group;
966: l_start_dd_mm := to_char(hr_nz_routes.get_fiscal_date(l_business_group_id),'dd-mm-');
967: --
968: if p_effective_date >= get_expired_year_date(l_action_eff_date, l_start_dd_mm) then /*3072939*/
969: l_balance := 0;
970: else

Line 1131: if p_effective_date > hr_nz_routes.fiscal_span_start(add_months(l_action_eff_date,4),4,l_business_group_id) then

1127: --
1128: -- is effective date (sess) later than the expiry of the fiscal quarter ( the start of the
1129: -- next fiscal quarter) of the effective date.
1130: --
1131: if p_effective_date > hr_nz_routes.fiscal_span_start(add_months(l_action_eff_date,4),4,l_business_group_id) then
1132: l_balance := 0;
1133: else
1134: --
1135: l_balance := calc_asg_fy_qtd ( p_assignment_action_id => l_assignment_action_id