APPS.BEN_BNR_BUS dependencies on BEN_RPTG_GRP

Line 40: FROM ben_rptg_grp_tl rtl,

36: p_rpt_grp_id IN NUMBER,
37: p_bus_grp_id in number ,
38: p_leg_code IN VARCHAR2) IS
39: SELECT 1
40: FROM ben_rptg_grp_tl rtl,
41: ben_rptg_grp rgp
42: WHERE upper(rgp.name)= upper(p_rpt_grp_name)
43: AND rgp.rptg_grp_id = rtl.rptg_grp_id
44: AND rtl.language = p_language

Line 41: ben_rptg_grp rgp

37: p_bus_grp_id in number ,
38: p_leg_code IN VARCHAR2) IS
39: SELECT 1
40: FROM ben_rptg_grp_tl rtl,
41: ben_rptg_grp rgp
42: WHERE upper(rgp.name)= upper(p_rpt_grp_name)
43: AND rgp.rptg_grp_id = rtl.rptg_grp_id
44: AND rtl.language = p_language
45: AND (rtl.rptg_grp_id <> p_rpt_grp_id OR p_rpt_grp_id IS NULL)

Line 116: ben_bnr_shd.constraint_error('BEN_RPTG_GRP_PK');

112: <> ben_bnr_shd.g_old_rec.rptg_grp_id) then
113: --
114: -- raise error as PK has changed
115: --
116: ben_bnr_shd.constraint_error('BEN_RPTG_GRP_PK');
117: --
118: elsif not l_api_updating then
119: --
120: -- check if PK is null

Line 126: ben_bnr_shd.constraint_error('BEN_RPTG_GRP_PK');

122: if p_rptg_grp_id is not null then
123: --
124: -- raise error as PK is not null
125: --
126: ben_bnr_shd.constraint_error('BEN_RPTG_GRP_PK');
127: --
128: end if;
129: --
130: end if;

Line 370: from ben_rptg_grp bnr

366: --
367: -- added nvl for CWB Changes
368: cursor c1 is
369: select null
370: from ben_rptg_grp bnr
371: ------ business group valiadted for global and non global
372: where nvl(bnr.business_group_id,nvl(p_business_group_id,-1)) =
373: nvl(p_business_group_id,nvl(bnr.business_group_id,-1))
374: --- changes of busienss group from non glbaol to gloabl

Line 809: ben_rptg_grp b

805: --
806: cursor csr_leg_code is
807: select a.legislation_code
808: from per_business_groups a,
809: ben_rptg_grp b
810: where b.rptg_grp_id = p_rptg_grp_id
811: and a.business_group_id = b.business_group_id;
812: --
813: -- Declare local variables