APPS.PAY_NZ_BAL_UPLOAD dependencies on HR_NZ_ROUTES

Line 85: select hr_nz_routes.fiscal_span_start( p_upload_date, 1, paf.business_group_id )

81: --
82: cursor csr_fiscal_year
83: ( p_assignment_id number
84: , p_upload_date date) is
85: select hr_nz_routes.fiscal_span_start( p_upload_date, 1, paf.business_group_id )
86: from per_assignments_f paf
87: , per_time_periods ptp
88: where paf.assignment_id = p_assignment_id
89: and ptp.payroll_id = paf.payroll_id

Line 98: select hr_nz_routes.fiscal_span_start( p_upload_date, 4, paf.business_group_id )

94: --
95: cursor csr_fiscal_quarter
96: ( p_assignment_id number
97: , p_upload_date date) is
98: select hr_nz_routes.fiscal_span_start( p_upload_date, 4, paf.business_group_id )
99: from per_assignments_f paf
100: , per_time_periods ptp
101: where paf.assignment_id = p_assignment_id
102: and ptp.payroll_id = paf.payroll_id

Line 224: l_tax_yr_start_date := hr_nz_routes.span_start(p_upload_date, 1, g_tax_start_dd_mm);

220: elsif p_dimension_name = g_asg_ytd then
221: --
222: -- what's the start_date of the tax year ?
223: --
224: l_tax_yr_start_date := hr_nz_routes.span_start(p_upload_date, 1, g_tax_start_dd_mm);
225: open csr_asg_start_date(p_assignment_id, p_upload_date, l_tax_yr_start_date);
226: fetch csr_asg_start_date into l_start_date;
227: if csr_asg_start_date%notfound then
228: close csr_asg_start_date;