APPS.BEN_PDP_BUS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 421: from ben_prtt_enrt_rslt_f a

417: --
418: --
419: cursor c1 is
420: select null
421: from ben_prtt_enrt_rslt_f a
422: where a.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
423: and a.prtt_enrt_rslt_stat_cd is null
424: and a.business_group_id + 0 = p_business_group_id
425: and p_validation_start_date <= effective_end_date

Line 444: -- check if prtt_enrt_rslt_id value exists in ben_prtt_enrt_rslt_f table

440: and nvl(p_prtt_enrt_rslt_id, hr_api.g_number)
441: <> nvl(ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id, hr_api.g_number)
442: or not l_api_updating) then
443: --
444: -- check if prtt_enrt_rslt_id value exists in ben_prtt_enrt_rslt_f table
445: --
446: open c1;
447: --
448: fetch c1 into l_dummy;

Line 453: -- raise error as FK does not relate to PK in ben_prtt_enrt_rslt_f

449: if c1%notfound then
450: --
451: close c1;
452: --
453: -- raise error as FK does not relate to PK in ben_prtt_enrt_rslt_f
454: -- table.
455: --
456: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK2');
457: --

Line 530: from ben_prtt_enrt_rslt_f r ,

526: select r.person_id
527: ,r.pl_id
528: ,r.oipl_id
529: ,o.opt_id
530: from ben_prtt_enrt_rslt_f r ,
531: ben_oipl_f o
532: where r.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
533: and r.prtt_enrt_rslt_stat_cd is null
534: and r.business_group_id + 0 = p_business_group_id

Line 689: -- raise error as FK does not relate to PK in ben_prtt_enrt_rslt_f

685: if info1_c%notfound then
686: --
687: close info1_c;
688: --
689: -- raise error as FK does not relate to PK in ben_prtt_enrt_rslt_f
690: -- table.
691: --
692: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK2');
693: --

Line 843: FROM ben_prtt_enrt_rslt_f rslt

839: CURSOR c_rslt
840: IS
841: SELECT person_id, pgm_id, pl_id, ptip_id, pl_typ_id,
842: enrt_cvg_strt_dt, enrt_cvg_thru_dt, per_in_ler_id
843: FROM ben_prtt_enrt_rslt_f rslt
844: WHERE rslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
845: and rslt.prtt_enrt_rslt_stat_cd is null
846: AND rslt.business_group_id = p_business_group_id
847: AND p_effective_date BETWEEN rslt.effective_start_date

Line 1344: from ben_prtt_enrt_rslt_f pen

1340: l_message_name varchar2(500) := 'BEN_94592_RT_STRT_GT_END_DT';
1341: --
1342: cursor c_person_id is
1343: select person_id
1344: from ben_prtt_enrt_rslt_f pen
1345: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
1346: --
1347: Begin
1348: --

Line 1440: (p_base_table_name => 'ben_prtt_enrt_rslt_f',

1436: --
1437: /*
1438: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and
1439: NOT (dt_api.check_min_max_dates
1440: (p_base_table_name => 'ben_prtt_enrt_rslt_f',
1441: p_base_key_column => 'prtt_enrt_rslt_id',
1442: p_base_key_value => p_prtt_enrt_rslt_id,
1443: p_from_date => p_validation_start_date,
1444: p_to_date => p_validation_end_date))) Then

Line 1445: l_table_name := 'ben_prtt_enrt_rslt_f';

1441: p_base_key_column => 'prtt_enrt_rslt_id',
1442: p_base_key_value => p_prtt_enrt_rslt_id,
1443: p_from_date => p_validation_start_date,
1444: p_to_date => p_validation_end_date))) Then
1445: l_table_name := 'ben_prtt_enrt_rslt_f';
1446: Raise l_integrity_error;
1447: End If;
1448: */
1449: --