APPS.BEN_PCG_BUS dependencies on BEN_PRTT_REIMBMT_RQST_F

Line 115: from ben_prtt_reimbmt_rqst_f a

111: l_dummy varchar2(1);
112: --
113: cursor c1 is
114: select null
115: from ben_prtt_reimbmt_rqst_f a
116: where a.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
117: and p_effective_date
118: between a.effective_start_date
119: and a.effective_end_date;

Line 134: -- check if prtt_reimbmt_rqst_id value exists in ben_prtt_reimbmt_rqst_f table

130: and nvl(p_prtt_reimbmt_rqst_id,hr_api.g_number)
131: <> nvl(ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id,hr_api.g_number)
132: or not l_api_updating) then
133: --
134: -- check if prtt_reimbmt_rqst_id value exists in ben_prtt_reimbmt_rqst_f table
135: --
136: open c1;
137: --
138: fetch c1 into l_dummy;

Line 143: -- raise error as FK does not relate to PK in ben_prtt_reimbmt_rqst_f

139: if c1%notfound then
140: --
141: close c1;
142: --
143: -- raise error as FK does not relate to PK in ben_prtt_reimbmt_rqst_f
144: -- table.
145: --
146: ben_pcg_shd.constraint_error('BEN_PRTT_CLM_GD_OR_SVC_TYP_DT1');
147: --

Line 215: -- check if prtt_reimbmt_rqst_id value exists in ben_prtt_reimbmt_rqst_f table

211: and nvl(p_pl_gd_or_svc_id,hr_api.g_number)
212: <> nvl(ben_pcg_shd.g_old_rec.pl_gd_or_svc_id,hr_api.g_number)
213: or not l_api_updating) then
214: --
215: -- check if prtt_reimbmt_rqst_id value exists in ben_prtt_reimbmt_rqst_f table
216: --
217: open c1;
218: --
219: fetch c1 into l_dummy;

Line 224: -- raise error as FK does not relate to PK in ben_prtt_reimbmt_rqst_f

220: if c1%notfound then
221: --
222: close c1;
223: --
224: -- raise error as FK does not relate to PK in ben_prtt_reimbmt_rqst_f
225: -- table.
226: --
227: ben_pcg_shd.constraint_error('BEN_PRTT_CLM_GD_OR_SVC_TYP_DT1');
228: --