APPS.BEN_PBN_BUS dependencies on BEN_PL_BNF_F

Line 269: -- check if ben_pl_f bnf parameters do not contradict ben_pl_bnf_f values

265: hr_utility.set_location('l_lf_evt_ocrd_dt :' || l_lf_evt_ocrd_dt, 12345);
266: close c_pil;
267: end if;
268:
269: -- check if ben_pl_f bnf parameters do not contradict ben_pl_bnf_f values
270: open pl1(l_lf_evt_ocrd_dt);
271:
272: fetch pl1 into
273: l_bnf_dsgn_cd

Line 465: from ben_pl_bnf_f b

461: --
462: --
463: cursor c1 is
464: select sum(pct_dsgd_num)
465: from ben_pl_bnf_f b
466: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
467: and b.business_group_id + 0 = p_business_group_id
468: and b.prmry_cntngnt_cd = p_prmry_cntngnt_cd
469: and b.pl_bnf_id <> nvl(p_pl_bnf_id, hr_api.g_number)

Line 566: from ben_pl_bnf_f b

562: ;
563: --
564: cursor c2 is
565: select sum(amt_dsgd_val)
566: from ben_pl_bnf_f b
567: where b.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
568: and b.business_group_id + 0 = p_business_group_id
569: and b.prmry_cntngnt_cd = p_prmry_cntngnt_cd
570: and b.pl_bnf_id <> nvl(p_pl_bnf_id, hr_api.g_number)

Line 602: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK4');

598: --
599: -- raise error as corresponding rslt does not exist on ben_prtt_enrt_rslt_f
600: -- table.
601: --
602: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK4');
603: else
604: --
605: open c2;
606: fetch c2 into l_sum;

Line 703: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK4');

699: --
700: -- raise error as corresponding rslt does not exist on ben_prtt_enrt_rslt_f
701: -- table.
702: --
703: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK4');
704: elsif p_amt_dsgd_uom <> l_uom then
705: --
706: fnd_message.set_name('BEN', 'BEN_91647_BNF_AMT_UOM_INVALID');
707: fnd_message.raise_error;

Line 767: from ben_pl_bnf_f pbn,

763: -- backed out per in ler.
764: --
765: cursor c3 is
766: select null
767: from ben_pl_bnf_f pbn,
768: ben_per_in_ler pil
769: where pbn.bnf_person_id = p_bnf_person_id
770: and pil.per_in_ler_id(+)=pbn.per_in_ler_id and
771: pil.business_group_id(+)=pbn.business_group_id

Line 818: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK1');

814: --
815: -- raise error as FK does not relate to PK in per_all_people
816: -- table.
817: --
818: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK1');
819: --
820: end if;
821: --
822: close c1;

Line 926: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK2');

922: --
923: -- raise error as FK does not relate to PK in per_all_people
924: -- table.
925: --
926: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK2');
927: --
928: end if;
929: --
930: close c1;

Line 1700: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK3');

1696: --
1697: -- raise error as FK does not relate to PK in per_all_people
1698: -- table.
1699: --
1700: ben_pbn_shd.constraint_error('BEN_PL_BNF_FK3');
1701: --
1702: end if;
1703: --
1704: close c1;

Line 1760: from ben_pl_bnf_f pbn,

1756: --
1757: --
1758: cursor c1 is
1759: select null
1760: from ben_pl_bnf_f pbn,
1761: ben_per_in_ler pil
1762: where (pbn.bnf_person_id = p_bnf_person_id
1763: or pbn.organization_id = p_organization_id)
1764: and pil.per_in_ler_id (+) = pbn.per_in_ler_id

Line 2374: ben_pl_bnf_f b

2370: --
2371: cursor csr_leg_code is
2372: select a.legislation_code
2373: from per_business_groups a,
2374: ben_pl_bnf_f b
2375: where b.pl_bnf_id = p_pl_bnf_id
2376: and a.business_group_id = b.business_group_id;
2377: --
2378: -- Declare local variables