APPS.BEN_RCL_BUS dependencies on BEN_RLTD_PER_CHG_CS_LER_F

Line 59: ben_rcl_shd.constraint_error('BEN_RLTD_PER_CHG_CS_LER_F_PK');

55: <> ben_rcl_shd.g_old_rec.rltd_per_chg_cs_ler_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_rcl_shd.constraint_error('BEN_RLTD_PER_CHG_CS_LER_F_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_rcl_shd.constraint_error('BEN_RLTD_PER_CHG_CS_LER_F_PK');

65: if p_rltd_per_chg_cs_ler_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_rcl_shd.constraint_error('BEN_RLTD_PER_CHG_CS_LER_F_PK');
70: --
71: end if;
72: --
73: end if;

Line 223: FROM ben_rltd_per_chg_cs_ler_f

219: ,p_new_val varchar2
220: ,p_old_val varchar2
221: ,p_business_group_id number) IS
222: SELECT 'x'
223: FROM ben_rltd_per_chg_cs_ler_f
224: WHERE rltd_per_chg_cs_ler_id <> nvl(p_rltd_per_chg_cs_ler_id,
225: hr_api.g_number)
226: AND source_table = p_source_table
227: AND source_column = p_source_column

Line 306: FROM ben_rltd_per_chg_cs_ler_f

302: CURSOR c1 (p_rltd_per_chg_cs_ler_id number
303: ,p_name varchar2
304: ,p_business_group_id number) IS
305: SELECT 'x'
306: FROM ben_rltd_per_chg_cs_ler_f
307: WHERE rltd_per_chg_cs_ler_id <> nvl(p_rltd_per_chg_cs_ler_id,
308: hr_api.g_number)
309: AND name = nvl(p_name, hr_api.g_varchar2)
310: AND business_group_id + 0 = p_business_group_id

Line 375: FROM ben_rltd_per_chg_cs_ler_f

371: ,p_whatif_lbl_txt varchar2
372: ,p_effective_date date
373: ,p_business_group_id number) IS
374: SELECT 'x'
375: FROM ben_rltd_per_chg_cs_ler_f
376: WHERE whatif_lbl_txt = p_whatif_lbl_txt
377: and rltd_per_chg_cs_ler_id <> nvl(p_rltd_per_chg_cs_ler_id,
378: hr_api.g_number)
379: AND business_group_id + 0 = p_business_group_id

Line 775: ben_rltd_per_chg_cs_ler_f b

771: --
772: cursor csr_leg_code is
773: select a.legislation_code
774: from per_business_groups a,
775: ben_rltd_per_chg_cs_ler_f b
776: where b.rltd_per_chg_cs_ler_id = p_rltd_per_chg_cs_ler_id
777: and a.business_group_id = b.business_group_id;
778: --
779: -- Declare local variables