APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_CMBN_PTIP_OPT_F

Line 738: -- START OF BEN_CMBN_PTIP_OPT_F ----------------------

734: ---------------------------------------------------------------
735: -- END OF BEN_CMBN_PTIP_F ----------------------
736: ---------------------------------------------------------------
737: ---------------------------------------------------------------
738: -- START OF BEN_CMBN_PTIP_OPT_F ----------------------
739: ---------------------------------------------------------------
740: cursor c_cpt1_from_parent(c_PGM_ID number) is
741: select distinct cp.cmbn_ptip_opt_id
742: from ben_cmbn_ptip_opt_f cp

Line 742: from ben_cmbn_ptip_opt_f cp

738: -- START OF BEN_CMBN_PTIP_OPT_F ----------------------
739: ---------------------------------------------------------------
740: cursor c_cpt1_from_parent(c_PGM_ID number) is
741: select distinct cp.cmbn_ptip_opt_id
742: from ben_cmbn_ptip_opt_f cp
743: where cp.pgm_id = c_pgm_id;
744: --
745: cursor c_cpt1(c_cmbn_ptip_opt_id number,c_mirror_src_entity_result_id number ,
746: c_table_alias varchar2) is

Line 748: from BEN_CMBN_PTIP_OPT_F cpt

744: --
745: cursor c_cpt1(c_cmbn_ptip_opt_id number,c_mirror_src_entity_result_id number ,
746: c_table_alias varchar2) is
747: select cpt.*
748: from BEN_CMBN_PTIP_OPT_F cpt
749: where cpt.cmbn_ptip_opt_id = c_cmbn_ptip_opt_id
750: and not exists (
751: select /* */ null
752: from ben_copy_entity_results cpe

Line 765: -- END OF BEN_CMBN_PTIP_OPT_F ----------------------

761: );
762: l_cmbn_ptip_opt_id number(15);
763: l_out_cpt_result_id number(15);
764: ---------------------------------------------------------------
765: -- END OF BEN_CMBN_PTIP_OPT_F ----------------------
766: ---------------------------------------------------------------
767: ---------------------------------------------------------------
768: -- START OF BEN_OIPLIP_F ----------------------
769: ---------------------------------------------------------------

Line 5385: -- START OF BEN_CMBN_PTIP_OPT_F ----------------------

5381: ---------------------------------------------------------------
5382: -- END OF BEN_CMBN_PTIP_F ----------------------
5383: ---------------------------------------------------------------
5384: ---------------------------------------------------------------
5385: -- START OF BEN_CMBN_PTIP_OPT_F ----------------------
5386: ---------------------------------------------------------------
5387: --
5388: for l_parent_rec in c_cpt1_from_parent(l_PGM_ID) loop
5389: --

Line 5480: -- Standard Rates ,Flex Credits at BEN_CMBN_PTIP_OPT_F level

5476: --
5477: end loop;
5478: --
5479: -- ------------------------------------------------------------------------
5480: -- Standard Rates ,Flex Credits at BEN_CMBN_PTIP_OPT_F level
5481: -- ------------------------------------------------------------------------
5482: ben_pd_rate_and_cvg_module.create_rate_results
5483: (
5484: p_validate => p_validate

Line 5502: -- Benefit Pools BEN_CMBN_PTIP_OPT_F level

5498: ,p_effective_date => p_effective_date
5499: ,p_parent_entity_result_id => l_out_cpt_result_id
5500: ) ;
5501: -- ------------------------------------------------------------------------
5502: -- Benefit Pools BEN_CMBN_PTIP_OPT_F level
5503: -- ------------------------------------------------------------------------
5504: ben_pd_rate_and_cvg_module.create_bnft_pool_results
5505: (
5506: p_validate =>p_validate

Line 5525: -- END OF BEN_CMBN_PTIP_OPT_F ----------------------

5521: ) ;
5522:
5523: end loop;
5524: ---------------------------------------------------------------
5525: -- END OF BEN_CMBN_PTIP_OPT_F ----------------------
5526: ---------------------------------------------------------------
5527: ---------------------------------------------------------------
5528: -- START OF BEN_OIPLIP_F ----------------------
5529: ---------------------------------------------------------------