APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_CMBN_PLIP_F

Line 676: -- START OF BEN_CMBN_PLIP_F ----------------------

672: ---------------------------------------------------------------
673: -- END OF BEN_LER_CHG_PLIP_ENRT_F ----------------------
674: ---------------------------------------------------------------
675: ---------------------------------------------------------------
676: -- START OF BEN_CMBN_PLIP_F ----------------------
677: ---------------------------------------------------------------
678: cursor c_cpl1_from_parent(c_PGM_ID number) is
679: select distinct cp.cmbn_plip_id
680: from ben_cmbn_plip_f cp

Line 680: from ben_cmbn_plip_f cp

676: -- START OF BEN_CMBN_PLIP_F ----------------------
677: ---------------------------------------------------------------
678: cursor c_cpl1_from_parent(c_PGM_ID number) is
679: select distinct cp.cmbn_plip_id
680: from ben_cmbn_plip_f cp
681: where cp.pgm_id = c_pgm_id;
682:
683: --
684: cursor c_cpl1(c_cmbn_plip_id number,c_mirror_src_entity_result_id number ,

Line 687: from BEN_CMBN_PLIP_F cpl

683: --
684: cursor c_cpl1(c_cmbn_plip_id number,c_mirror_src_entity_result_id number ,
685: c_table_alias varchar2) is
686: select cpl.*
687: from BEN_CMBN_PLIP_F cpl
688: where cpl.cmbn_plip_id = c_cmbn_plip_id
689: and not exists (
690: select /* */ null
691: from ben_copy_entity_results cpe

Line 704: -- END OF BEN_CMBN_PLIP_F ----------------------

700: );
701: l_cmbn_plip_id number(15);
702: l_out_cpl_result_id number(15);
703: ---------------------------------------------------------------
704: -- END OF BEN_CMBN_PLIP_F ----------------------
705: ---------------------------------------------------------------
706: ---------------------------------------------------------------
707: -- START OF BEN_CMBN_PTIP_F ----------------------
708: ---------------------------------------------------------------

Line 5103: -- START OF BEN_CMBN_PLIP_F ----------------------

5099: -- END OF BEN_PLIP_F ----------------------
5100: ---------------------------------------------------------------
5101:
5102: ---------------------------------------------------------------
5103: -- START OF BEN_CMBN_PLIP_F ----------------------
5104: ---------------------------------------------------------------
5105: --
5106: for l_parent_rec in c_cpl1_from_parent(l_PGM_ID) loop
5107: --

Line 5196: -- Standard Rates ,Flex Credits at BEN_CMBN_PLIP_F level

5192: --
5193: end loop;
5194: --
5195: -- ------------------------------------------------------------------------
5196: -- Standard Rates ,Flex Credits at BEN_CMBN_PLIP_F level
5197: -- ------------------------------------------------------------------------
5198: ben_pd_rate_and_cvg_module.create_rate_results
5199: (
5200: p_validate => p_validate

Line 5218: -- Benefit Pools BEN_CMBN_PLIP_F level

5214: ,p_effective_date => p_effective_date
5215: ,p_parent_entity_result_id => l_out_cpl_result_id
5216: ) ;
5217: -- ------------------------------------------------------------------------
5218: -- Benefit Pools BEN_CMBN_PLIP_F level
5219: -- ------------------------------------------------------------------------
5220: ben_pd_rate_and_cvg_module.create_bnft_pool_results
5221: (
5222: p_validate =>p_validate

Line 5241: -- END OF BEN_CMBN_PLIP_F ----------------------

5237: ) ;
5238: --
5239: end loop;
5240: ---------------------------------------------------------------
5241: -- END OF BEN_CMBN_PLIP_F ----------------------
5242: ---------------------------------------------------------------
5243: ---------------------------------------------------------------
5244: -- START OF BEN_CMBN_PTIP_F ----------------------
5245: ---------------------------------------------------------------