DBA Data[Home] [Help]

APPS.BEN_PCP_BUS dependencies on BEN_POPL_ORG_F

Line 751: -- with pcp_rpstry_flag = 'Y' until it has a ben_popl_org_f/ben_popl_org_role_f

747: -- ----------------------------------------------------------------------------
748: --
749: -- Description
750: -- This procedure is used to check that the plan cannot have a ben_pl_pcp row
751: -- with pcp_rpstry_flag = 'Y' until it has a ben_popl_org_f/ben_popl_org_role_f
752: --
753: -- Pre Conditions
754: -- None.
755: --

Line 776: --cursor to check the row exist in the ben_popl_org_f table.

772:
773: l_proc varchar2(72) := g_package|| ' chk_pl_pcp_rpstry';
774: l_dummy varchar2(1);
775:
776: --cursor to check the row exist in the ben_popl_org_f table.
777: cursor c1 is select 'x'
778: from ben_popl_org_f
779: Where pl_id = p_pl_id;
780: --

Line 778: from ben_popl_org_f

774: l_dummy varchar2(1);
775:
776: --cursor to check the row exist in the ben_popl_org_f table.
777: cursor c1 is select 'x'
778: from ben_popl_org_f
779: Where pl_id = p_pl_id;
780: --
781: Begin
782: hr_utility.set_location('Entering:'||l_proc, 5);