APPS.BEN_CMT_BUS dependencies on BEN_CM_DLVRY_MTHD_TYP

Line 57: ben_cmt_shd.constraint_error('BEN_CM_DLVRY_MTHD_TYP_PK');

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

Line 67: ben_cmt_shd.constraint_error('BEN_CM_DLVRY_MTHD_TYP_PK');

63: if p_cm_dlvry_mthd_typ_id is not null then
64: --
65: -- raise error as PK is not null
66: --
67: ben_cmt_shd.constraint_error('BEN_CM_DLVRY_MTHD_TYP_PK');
68: --
69: end if;
70: --
71: end if;

Line 141: ben_cmt_shd.constraint_error('BEN_CM_DLVRY_MTHD_TYP_FK3');

137: --
138: -- raise error as FK does not relate to PK in ben_cm_typ_f
139: -- table.
140: --
141: ben_cmt_shd.constraint_error('BEN_CM_DLVRY_MTHD_TYP_FK3');
142: --
143: end if;
144: --
145: close c1;

Line 402: from ben_cm_dlvry_mthd_typ

398: --
399: --
400: cursor crs_cm_dlvry_mthd is
401: select null
402: from ben_cm_dlvry_mthd_typ
403: where cm_typ_id = nvl(p_cm_typ_id, hr_api.g_number)
404: /* Bug Fix for Bug 1862 Benefits Bugs */
405: and cm_dlvry_mthd_typ_cd = p_cm_dlvry_mthd_typ_cd
406: and business_group_id + 0 = p_business_group_id ;

Line 583: ben_cm_dlvry_mthd_typ b

579: --
580: cursor csr_leg_code is
581: select a.legislation_code
582: from per_business_groups a,
583: ben_cm_dlvry_mthd_typ b
584: where b.cm_dlvry_mthd_typ_id = p_cm_dlvry_mthd_typ_id
585: and a.business_group_id = b.business_group_id;
586: --
587: -- Declare local variables