DBA Data[Home] [Help]

APPS.PAY_NZ_EXC dependencies on HR_NZ_ROUTES

Line 111: l_fy_user_span_start := hr_nz_routes.get_fiscal_date( l_business_group_id);

107: open csr_get_business_group;
108: fetch csr_get_business_group into l_business_group_id;
109: close csr_get_business_group;
110: --
111: l_fy_user_span_start := hr_nz_routes.get_fiscal_date( l_business_group_id);
112: --
113: if lower(l_dimension_name) = '_asg_fy_ytd' then
114: l_frequency := 1;
115: else

Line 124: l_date_dd_mm := to_char(hr_nz_routes.get_anniversary_date ( p_user_assignment_action_id

120: --
121: elsif lower(l_dimension_name) = '_asg_hol_ytd' then
122: --
123: l_frequency := 1;
124: l_date_dd_mm := to_char(hr_nz_routes.get_anniversary_date ( p_user_assignment_action_id
125: , p_user_effective_date), 'dd-mm-');
126: --
127: end if;
128: --

Line 134: l_user_span_start := hr_nz_routes.span_start(p_user_effective_date

130: --
131: -- Bug 3181581
132: -- Changed to use effective date instead of regular_payment_date
133: --
134: l_user_span_start := hr_nz_routes.span_start(p_user_effective_date
135: ,l_frequency
136: ,l_date_dd_mm);
137: if p_owner_effective_date < l_user_span_start then
138: --

Line 427: p_start_date:= hr_nz_routes.anniversary_span_start(

423: , p_asg_action IN NUMBER
424: )
425: IS
426: BEGIN
427: p_start_date:= hr_nz_routes.anniversary_span_start(
428: p_asg_action
429: ,p_effective_date);
430:
431: END start_code_hol_ytd;