APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_CMBN_PTIP_F

Line 707: -- START OF BEN_CMBN_PTIP_F ----------------------

703: ---------------------------------------------------------------
704: -- END OF BEN_CMBN_PLIP_F ----------------------
705: ---------------------------------------------------------------
706: ---------------------------------------------------------------
707: -- START OF BEN_CMBN_PTIP_F ----------------------
708: ---------------------------------------------------------------
709: cursor c_cbp1_from_parent(c_PGM_ID number) is
710: select distinct cp.cmbn_ptip_id
711: from ben_cmbn_ptip_f cp

Line 711: from ben_cmbn_ptip_f cp

707: -- START OF BEN_CMBN_PTIP_F ----------------------
708: ---------------------------------------------------------------
709: cursor c_cbp1_from_parent(c_PGM_ID number) is
710: select distinct cp.cmbn_ptip_id
711: from ben_cmbn_ptip_f cp
712: where cp.pgm_id = c_pgm_id;
713:
714: --
715: cursor c_cbp1(c_cmbn_ptip_id number,c_mirror_src_entity_result_id number ,

Line 718: from BEN_CMBN_PTIP_F cbp

714: --
715: cursor c_cbp1(c_cmbn_ptip_id number,c_mirror_src_entity_result_id number ,
716: c_table_alias varchar2) is
717: select cbp.*
718: from BEN_CMBN_PTIP_F cbp
719: where cbp.cmbn_ptip_id = c_cmbn_ptip_id
720: and not exists (
721: select /* */ null
722: from ben_copy_entity_results cpe

Line 735: -- END OF BEN_CMBN_PTIP_F ----------------------

731: );
732: l_cmbn_ptip_id number(15);
733: l_out_cbp_result_id number(15);
734: ---------------------------------------------------------------
735: -- END OF BEN_CMBN_PTIP_F ----------------------
736: ---------------------------------------------------------------
737: ---------------------------------------------------------------
738: -- START OF BEN_CMBN_PTIP_OPT_F ----------------------
739: ---------------------------------------------------------------

Line 5244: -- START OF BEN_CMBN_PTIP_F ----------------------

5240: ---------------------------------------------------------------
5241: -- END OF BEN_CMBN_PLIP_F ----------------------
5242: ---------------------------------------------------------------
5243: ---------------------------------------------------------------
5244: -- START OF BEN_CMBN_PTIP_F ----------------------
5245: ---------------------------------------------------------------
5246: --
5247: for l_parent_rec in c_cbp1_from_parent(l_PGM_ID) loop
5248: --

Line 5337: -- Standard Rates ,Flex Credits at BEN_CMBN_PTIP_F level

5333: --
5334: end loop;
5335: --
5336: -- ------------------------------------------------------------------------
5337: -- Standard Rates ,Flex Credits at BEN_CMBN_PTIP_F level
5338: -- ------------------------------------------------------------------------
5339: ben_pd_rate_and_cvg_module.create_rate_results
5340: (
5341: p_validate => p_validate

Line 5359: -- Benefit Pools BEN_CMBN_PTIP_F level

5355: ,p_effective_date => p_effective_date
5356: ,p_parent_entity_result_id => l_out_cbp_result_id
5357: ) ;
5358: -- ------------------------------------------------------------------------
5359: -- Benefit Pools BEN_CMBN_PTIP_F level
5360: -- ------------------------------------------------------------------------
5361: ben_pd_rate_and_cvg_module.create_bnft_pool_results
5362: (
5363: p_validate =>p_validate

Line 5382: -- END OF BEN_CMBN_PTIP_F ----------------------

5378: ) ;
5379:
5380: end loop;
5381: ---------------------------------------------------------------
5382: -- END OF BEN_CMBN_PTIP_F ----------------------
5383: ---------------------------------------------------------------
5384: ---------------------------------------------------------------
5385: -- START OF BEN_CMBN_PTIP_OPT_F ----------------------
5386: ---------------------------------------------------------------