APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_TTL_CVG_VOL_PRTE_F

Line 3646: -- START OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------

3642: ---------------------------------------------------------------
3643: -- END OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------
3644: ---------------------------------------------------------------
3645: ---------------------------------------------------------------
3646: -- START OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------
3647: ---------------------------------------------------------------
3648: cursor c_etc_from_parent(c_ELIGY_PRFL_ID number) is
3649: select elig_ttl_cvg_vol_prte_id
3650: from BEN_ELIG_TTL_CVG_VOL_PRTE_F

Line 3650: from BEN_ELIG_TTL_CVG_VOL_PRTE_F

3646: -- START OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------
3647: ---------------------------------------------------------------
3648: cursor c_etc_from_parent(c_ELIGY_PRFL_ID number) is
3649: select elig_ttl_cvg_vol_prte_id
3650: from BEN_ELIG_TTL_CVG_VOL_PRTE_F
3651: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3652: --
3653: cursor c_etc(c_elig_ttl_cvg_vol_prte_id number,c_mirror_src_entity_result_id number ,
3654: c_table_alias varchar2 ) is

Line 3656: from BEN_ELIG_TTL_CVG_VOL_PRTE_F etc

3652: --
3653: cursor c_etc(c_elig_ttl_cvg_vol_prte_id number,c_mirror_src_entity_result_id number ,
3654: c_table_alias varchar2 ) is
3655: select etc.*
3656: from BEN_ELIG_TTL_CVG_VOL_PRTE_F etc
3657: where etc.elig_ttl_cvg_vol_prte_id = c_elig_ttl_cvg_vol_prte_id
3658: -- and etc.business_group_id = p_business_group_id
3659: and not exists (
3660: select /* */ null

Line 3667: -- and trt.where_clause = 'BEN_ELIG_TTL_CVG_VOL_PRTE_F'

3663: where copy_entity_txn_id = p_copy_entity_txn_id
3664: -- and trt.table_route_id = cpe.table_route_id
3665: and ( -- c_mirror_src_entity_result_id is null or
3666: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3667: -- and trt.where_clause = 'BEN_ELIG_TTL_CVG_VOL_PRTE_F'
3668: and cpe.table_alias = c_table_alias
3669: and information1 = c_elig_ttl_cvg_vol_prte_id
3670: -- and information4 = etc.business_group_id
3671: and information2 = etc.effective_start_date

Line 3677: -- END OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------

3673: );
3674: l_elig_ttl_cvg_vol_prte_id number(15);
3675: l_out_etc_result_id number(15);
3676: ---------------------------------------------------------------
3677: -- END OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------
3678: ---------------------------------------------------------------
3679: ---------------------------------------------------------------
3680: -- START OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------
3681: ---------------------------------------------------------------

Line 11302: -- START OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------

11298: ---------------------------------------------------------------
11299: -- END OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------
11300: ---------------------------------------------------------------
11301: ---------------------------------------------------------------
11302: -- START OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------
11303: ---------------------------------------------------------------
11304: --
11305: for l_parent_rec in c_etc_from_parent(l_ELIGY_PRFL_ID) loop
11306: --

Line 11419: -- END OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------

11415: end loop;
11416: --
11417: end loop;
11418: ---------------------------------------------------------------
11419: -- END OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------
11420: ---------------------------------------------------------------
11421: ---------------------------------------------------------------
11422: -- START OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------
11423: ---------------------------------------------------------------