APPS.BEN_PRC_BUS dependencies on BEN_GD_OR_SVC_TYP

Line 462: from ben_gd_or_svc_typ a

458: l_dummy varchar2(1);
459: --
460: cursor c1 is
461: select null
462: from ben_gd_or_svc_typ a
463: where a.gd_or_svc_typ_id = p_gd_or_svc_typ_id;
464: --
465: Begin
466: --

Line 480: -- check if gd_or_svc_typ_id value exists in ben_gd_or_svc_typ table

476: <> nvl(ben_prc_shd.g_old_rec.gd_or_svc_typ_id,hr_api.g_number)
477: or not l_api_updating) and
478: p_gd_or_svc_typ_id is not null then
479: --
480: -- check if gd_or_svc_typ_id value exists in ben_gd_or_svc_typ table
481: --
482: open c1;
483: --
484: fetch c1 into l_dummy;

Line 489: -- raise error as FK does not relate to PK in ben_gd_or_svc_typ

485: if c1%notfound then
486: --
487: close c1;
488: --
489: -- raise error as FK does not relate to PK in ben_gd_or_svc_typ
490: -- table.
491: --
492: ben_prc_shd.constraint_error('BEN_PRTT_REIMBMT_RQST_F_FK1');
493: --

Line 1797: ben_gd_or_svc_typ gds

1793: ben_popl_yr_perd cpy,
1794: ben_yr_perd yrp,
1795: ben_prtt_clm_gd_or_svc_typ pcg,
1796: ben_pl_gd_or_svc_f pgs,
1797: ben_gd_or_svc_typ gds
1798: where pcg.prtt_reimbmt_rqst_id = p_prtt_reimbmt_rqst_id
1799: and pcg.pl_gd_or_svc_id = pgs.pl_gd_or_svc_id
1800: and pgs.gd_or_svc_typ_id = gds.gd_or_svc_typ_id
1801: and cpy.pl_id = pgs.pl_id