DBA Data[Home] [Help]

APPS.HR_COLLECTIVE_AGREEMENT_API dependencies on BEN_YR_PERD

Line 64: FROM ben_yr_perd

60: --
61: CURSOR csr_get_plan_years IS
62: SELECT start_date,
63: end_date
64: FROM ben_yr_perd
65: WHERE start_date = l_start_of_year
66: AND end_date = l_end_of_year
67: AND business_group_id = p_business_group_id; --Bug fix:3648527
68: --

Line 171: FROM ben_yr_perd

167: CURSOR csr_get_plan_years IS
168: SELECT yr_perd_id,
169: TRUNC(start_date) start_date,
170: TRUNC(end_date) end_date
171: FROM ben_yr_perd
172: WHERE business_group_id = p_business_group_id --Bug fix:3648527
173: AND end_date <= l_ten_year_date
174: ORDER BY start_date ASC;
175: --