APPS.BEN_CPY_BUS dependencies on BEN_YR_PERD

Line 118: from ben_yr_perd yrp

114: l_dummy varchar2(1);
115: --
116: cursor c_plan is
117: select null
118: from ben_yr_perd yrp
119: where yrp.yr_perd_id = p_yr_perd_id
120: and yrp.business_group_id = p_business_group_id
121: and exists (select null
122: from ben_popl_yr_perd a,

Line 123: ben_yr_perd b

119: where yrp.yr_perd_id = p_yr_perd_id
120: and yrp.business_group_id = p_business_group_id
121: and exists (select null
122: from ben_popl_yr_perd a,
123: ben_yr_perd b
124: where a.popl_yr_perd_id <> nvl(p_popl_yr_perd_id,-1)
125: and a.pl_id = p_pl_id
126: and a.business_group_id = p_business_group_id
127: and a.yr_perd_id = b.yr_perd_id

Line 138: from ben_yr_perd yrp

134: and b.end_date));
135: --
136: cursor c_prog is
137: select null
138: from ben_yr_perd yrp
139: where yrp.yr_perd_id = p_yr_perd_id
140: and yrp.business_group_id = p_business_group_id
141: and exists (select null
142: from ben_popl_yr_perd a,

Line 143: ben_yr_perd b

139: where yrp.yr_perd_id = p_yr_perd_id
140: and yrp.business_group_id = p_business_group_id
141: and exists (select null
142: from ben_popl_yr_perd a,
143: ben_yr_perd b
144: where a.popl_yr_perd_id <> nvl(p_popl_yr_perd_id,-1)
145: and a.pgm_id = p_pgm_id
146: and a.business_group_id = p_business_group_id
147: and a.yr_perd_id = b.yr_perd_id

Line 433: from ben_yr_perd a

429: l_dummy varchar2(1);
430: --
431: cursor c1 is
432: select null
433: from ben_yr_perd a
434: where a.yr_perd_id = p_yr_perd_id;
435: --
436: Begin
437: --

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

451: and nvl(p_yr_perd_id,hr_api.g_number)
452: <> nvl(ben_cpy_shd.g_old_rec.yr_perd_id,hr_api.g_number)
453: or not l_api_updating) then
454: --
455: -- check if yr_perd_id value exists in ben_yr_perd table
456: --
457: open c1;
458: --
459: fetch c1 into l_dummy;

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

460: if c1%notfound then
461: --
462: close c1;
463: --
464: -- raise error as FK does not relate to PK in ben_yr_perd
465: -- table.
466: --
467: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');
468: --

Line 572: from ben_yr_perd a

568: l_end date;
569: --
570: cursor c1 is
571: select start_date, end_date
572: from ben_yr_perd a
573: where a.yr_perd_id = p_yr_perd_id;
574: --
575: Begin
576: --

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

624: if c1%notfound then
625: --
626: close c1;
627: --
628: -- raise error as FK does not relate to PK in ben_yr_perd
629: -- table.
630: --
631: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');
632: --

Line 697: from ben_yr_perd a

693: l_end date;
694: --
695: cursor c1 is
696: select start_date, end_date
697: from ben_yr_perd a
698: where a.yr_perd_id = p_yr_perd_id;
699: --
700: cursor c_claims (p_pl_id number) is
701: select null

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

742: if c1%notfound then
743: --
744: close c1;
745: --
746: -- raise error as FK does not relate to PK in ben_yr_perd
747: -- table.
748: --
749: ben_cpy_shd.constraint_error('BEN_POPL_YR_PERD_FK1');
750: --