APPS.BEN_PSL_BUS dependencies on BEN_PER_INFO_CHG_CS_LER_F

Line 59: ben_psl_shd.constraint_error('BEN_PER_INFO_CHG_CS_LER_F_PK');

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

Line 69: ben_psl_shd.constraint_error('BEN_PER_INFO_CHG_CS_LER_F_PK');

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

Line 225: FROM ben_per_info_chg_cs_ler_f

221: ,p_old_val varchar2
222: ,p_effective_date date
223: ,p_business_group_id number) IS
224: SELECT 'x'
225: FROM ben_per_info_chg_cs_ler_f
226: WHERE per_info_chg_cs_ler_id <> nvl(p_per_info_chg_cs_ler_id,
227: hr_api.g_number)
228: AND source_table = p_source_table
229: AND source_column = p_source_column

Line 311: FROM ben_per_info_chg_cs_ler_f

307: ,p_name varchar2
308: ,p_effective_date date
309: ,p_business_group_id number) IS
310: SELECT 'x'
311: FROM ben_per_info_chg_cs_ler_f
312: WHERE per_info_chg_cs_ler_id <> nvl(p_per_info_chg_cs_ler_id,
313: hr_api.g_number)
314: AND name = nvl(p_name, hr_api.g_varchar2)
315: AND business_group_id + 0 = p_business_group_id

Line 379: FROM ben_per_info_chg_cs_ler_f

375: ,p_whatif_lbl_txt varchar2
376: ,p_effective_date date
377: ,p_business_group_id number) IS
378: SELECT 'x'
379: FROM ben_per_info_chg_cs_ler_f
380: WHERE whatif_lbl_txt = p_whatif_lbl_txt
381: AND per_info_chg_cs_ler_id <> nvl(p_per_info_chg_cs_ler_id,
382: hr_api.g_number)
383: AND business_group_id + 0 = p_business_group_id

Line 779: ben_per_info_chg_cs_ler_f b

775: --
776: cursor csr_leg_code is
777: select a.legislation_code
778: from per_business_groups a,
779: ben_per_info_chg_cs_ler_f b
780: where b.per_info_chg_cs_ler_id = p_per_info_chg_cs_ler_id
781: and a.business_group_id = b.business_group_id;
782: --
783: -- Declare local variables