DBA Data[Home] [Help]

APPS.PAY_NZ_EXC dependencies on HR_NZ_ROUTES

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

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

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

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

Line 136: l_user_span_start := hr_nz_routes.span_start(p_user_effective_date

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

Line 429: p_start_date:= hr_nz_routes.anniversary_span_start(

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