APPS.BEN_WYP_BUS dependencies on BEN_YR_PERD

Line 111: from ben_yr_perd a

107: l_dummy varchar2(1);
108: --
109: cursor c1 is
110: select null
111: from ben_yr_perd a
112: where a.yr_perd_id = p_yr_perd_id;
113: --
114: Begin
115: --

Line 128: -- check if yr_perd_id value exists in ben_yr_perd table

124: <> nvl(ben_wyp_shd.g_old_rec.yr_perd_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_yr_perd_id is not null then
127: --
128: -- check if yr_perd_id value exists in ben_yr_perd table
129: --
130: open c1;
131: --
132: fetch c1 into l_dummy;

Line 137: -- raise error as FK does not relate to PK in ben_yr_perd

133: if c1%notfound then
134: --
135: close c1;
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: --

Line 198: from ben_yr_perd

194: to_number(to_char(start_date, 'MM')) strt_mm,
195: to_number(to_char(end_date, 'DD')) end_dd,
196: to_number(to_char(end_date, 'MM')) end_mm,
197: perd_typ_cd
198: from ben_yr_perd
199: where yr_perd_id = p_yr_perd_id
200: and business_group_id = p_business_group_id;
201:
202: --

Line 818: from ben_yr_perd

814: to_number(to_char(start_date, 'YYYY')) l_strt_yy,
815: to_number(to_char(end_date, 'DD')) l_end_dd,
816: to_number(to_char(end_date, 'MM')) l_end_mm,
817: to_number(to_char(end_date, 'YYYY')) l_end_yy
818: from ben_yr_perd
819: where yr_perd_id = p_yr_perd_id
820: and business_group_id = p_business_group_id;
821:
822: --