APPS.BEN_WYP_BUS dependencies on BEN_WTHN_YR_PERD

Line 56: ben_wyp_shd.constraint_error('BEN_WTHN_YR_PERD_PK');

52: <> ben_wyp_shd.g_old_rec.wthn_yr_perd_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_wyp_shd.constraint_error('BEN_WTHN_YR_PERD_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_wyp_shd.constraint_error('BEN_WTHN_YR_PERD_PK');

62: if p_wthn_yr_perd_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_wyp_shd.constraint_error('BEN_WTHN_YR_PERD_PK');
67: --
68: end if;
69: --
70: end if;

Line 140: ben_wyp_shd.constraint_error('BEN_WTHN_YR_PERD_FK1');

136: --
137: -- raise error as FK does not relate to PK in ben_yr_perd
138: -- table.
139: --
140: ben_wyp_shd.constraint_error('BEN_WTHN_YR_PERD_FK1');
141: --
142: end if;
143: --
144: close c1;

Line 513: from ben_wthn_yr_perd

509: --
510: --
511: cursor uom is
512: select strt_day, strt_mo, end_day, end_mo
513: from ben_wthn_yr_perd
514: where tm_uom = p_tm_uom
515: and yr_perd_id = p_yr_perd_id
516: and wthn_yr_perd_id <> nvl(p_wthn_yr_perd_id, hr_api.g_number)
517: and business_group_id + 0 = p_business_group_id;

Line 655: from ben_wthn_yr_perd

651: l_exists char(1);
652: --
653: cursor c1 is
654: select null
655: from ben_wthn_yr_perd
656: where tm_uom = p_tm_uom
657: and yr_perd_id = p_yr_perd_id
658: and strt_day = p_strt_day
659: and strt_mo = p_strt_mo

Line 1065: ben_wthn_yr_perd b

1061: --
1062: cursor csr_leg_code is
1063: select a.legislation_code
1064: from per_business_groups a,
1065: ben_wthn_yr_perd b
1066: where b.wthn_yr_perd_id = p_wthn_yr_perd_id
1067: and a.business_group_id = b.business_group_id;
1068: --
1069: -- Declare local variables