APPS.BEN_CSR_BUS dependencies on BEN_CSS_RLTD_PER_PER_IN_LER

Line 126: FROM ben_css_rltd_per_per_in_ler

122: ,p_business_group_id number
123: ,p_validation_start_date date
124: ,p_validation_end_date date) IS
125: SELECT css_rltd_per_per_in_ler_id
126: FROM ben_css_rltd_per_per_in_ler
127: WHERE css_rltd_per_per_in_ler_id <>
128: nvl(p_css_rltd_per_per_in_ler_id, hr_api.g_number)
129: AND business_group_id + 0 = p_business_group_id
130: AND ordr_to_prcs_num = nvl(p_ordr_to_prcs_num,hr_api.g_number)

Line 167: ben_csr_shd.constraint_error('BEN_CSS_RLTD_PER_PER_IN_LER_UK2');

163: close l_csr_csr;
164: --
165: -- raise error as there is another record in database with same sequence number.
166: --
167: ben_csr_shd.constraint_error('BEN_CSS_RLTD_PER_PER_IN_LER_UK2');
168: end if;
169: close l_csr_csr;
170:
171: end if;

Line 223: FROM ben_css_rltd_per_per_in_ler

219: ,p_business_group_id number
220: ,p_validation_start_date date
221: ,p_validation_end_date date) IS
222: SELECT css_rltd_per_per_in_ler_id
223: FROM ben_css_rltd_per_per_in_ler
224: WHERE css_rltd_per_per_in_ler_id <>
225: nvl(p_css_rltd_per_per_in_ler_id, hr_api.g_number)
226: AND business_group_id + 0 = p_business_group_id
227: AND rsltg_ler_id = p_rsltg_ler_id

Line 265: ben_csr_shd.constraint_error('BEN_CSS_RLTD_PER_PER_IN_LER_UK3');

261: --
262: -- raise error as there is another record in database with same
263: -- Life Event
264: --
265: ben_csr_shd.constraint_error('BEN_CSS_RLTD_PER_PER_IN_LER_UK3');
266: end if;
267: close l_csr_csr;
268:
269: end if;

Line 635: ben_css_rltd_per_per_in_ler_f b

631: --
632: cursor csr_leg_code is
633: select a.legislation_code
634: from per_business_groups a,
635: ben_css_rltd_per_per_in_ler_f b
636: where b.css_rltd_per_per_in_ler_id = p_css_rltd_per_per_in_ler_id
637: and a.business_group_id = b.business_group_id;
638: --
639: -- Declare local variables