APPS.BEN_LRC_BUS dependencies on BEN_LER_RLTD_PER_CS_LER_F

Line 132: FROM ben_ler_rltd_per_cs_ler_f

128: ,p_business_group_id number
129: ,p_validation_start_date date
130: ,p_validation_end_date date) IS
131: SELECT 'x'
132: FROM ben_ler_rltd_per_cs_ler_f
133: WHERE ler_rltd_per_cs_ler_id <> nvl(p_ler_rltd_per_cs_ler_id, hr_api.g_number)
134: AND rltd_per_chg_cs_ler_id = p_rltd_per_chg_cs_ler_id
135: AND ler_id = p_ler_id
136: AND business_group_id + 0 = p_business_group_id

Line 169: ben_lrc_shd.constraint_error('BEN_LER_RLTD_PER_CS_LER_F_FK2');

165: if c1%notfound then
166: close c1;
167: -- raise error as FK does not relate to PK in ben_rltd_per_chg_cs_ler_f
168: -- table.
169: ben_lrc_shd.constraint_error('BEN_LER_RLTD_PER_CS_LER_F_FK2');
170: end if;
171: close c1;
172: -- check if the foreign key is unique for this ler.
173: open c2

Line 654: ben_ler_rltd_per_cs_ler_f b

650: --
651: cursor csr_leg_code is
652: select a.legislation_code
653: from per_business_groups a,
654: ben_ler_rltd_per_cs_ler_f b
655: where b.ler_rltd_per_cs_ler_id = p_ler_rltd_per_cs_ler_id
656: and a.business_group_id = b.business_group_id;
657: --
658: -- Declare local variables