APPS.PYNZEXC dependencies on HR_NZ_ROUTES

Line 110: select hr_nz_routes.span_start ( bptp.regular_payment_date

106: from pay_assignment_actions_v
107: where assignment_action_id = p_user_assignment_action_id;
108: --
109: cursor csr_user_span_start(p_frequency number, p_span_start varchar2) is
110: select hr_nz_routes.span_start ( bptp.regular_payment_date
111: , p_frequency
112: , p_span_start )
113: from per_time_periods bptp
114: , pay_payroll_actions bact

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

151: open csr_get_business_group;
152: fetch csr_get_business_group into l_business_group_id;
153: close csr_get_business_group;
154: --
155: l_fy_user_span_start := hr_nz_routes.get_fiscal_date( l_business_group_id);
156: --
157: if lower(l_dimension_name) = '_asg_fy_ytd' then
158: l_frequency := 1;
159: else

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

164: --
165: elsif lower(l_dimension_name) = '_asg_hol_ytd' then
166: --
167: l_frequency := 1;
168: l_date_dd_mm := to_char(hr_nz_routes.get_anniversary_date ( p_user_assignment_action_id
169: , p_user_effective_date), 'dd-mm-');
170: --
171: end if;
172: --