APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_TTL_PRTT_PRTE_F

Line 3680: -- START OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------

3676: ---------------------------------------------------------------
3677: -- END OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------
3678: ---------------------------------------------------------------
3679: ---------------------------------------------------------------
3680: -- START OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------
3681: ---------------------------------------------------------------
3682: cursor c_etp_from_parent(c_ELIGY_PRFL_ID number) is
3683: select elig_ttl_prtt_prte_id
3684: from BEN_ELIG_TTL_PRTT_PRTE_F

Line 3684: from BEN_ELIG_TTL_PRTT_PRTE_F

3680: -- START OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------
3681: ---------------------------------------------------------------
3682: cursor c_etp_from_parent(c_ELIGY_PRFL_ID number) is
3683: select elig_ttl_prtt_prte_id
3684: from BEN_ELIG_TTL_PRTT_PRTE_F
3685: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3686: --
3687: cursor c_etp(c_elig_ttl_prtt_prte_id number,c_mirror_src_entity_result_id number ,
3688: c_table_alias varchar2 ) is

Line 3690: from BEN_ELIG_TTL_PRTT_PRTE_F etp

3686: --
3687: cursor c_etp(c_elig_ttl_prtt_prte_id number,c_mirror_src_entity_result_id number ,
3688: c_table_alias varchar2 ) is
3689: select etp.*
3690: from BEN_ELIG_TTL_PRTT_PRTE_F etp
3691: where etp.elig_ttl_prtt_prte_id = c_elig_ttl_prtt_prte_id
3692: -- and etp.business_group_id = p_business_group_id
3693: and not exists (
3694: select /* */ null

Line 3701: -- and trt.where_clause = 'BEN_ELIG_TTL_PRTT_PRTE_F'

3697: where copy_entity_txn_id = p_copy_entity_txn_id
3698: -- and trt.table_route_id = cpe.table_route_id
3699: and ( -- c_mirror_src_entity_result_id is null or
3700: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3701: -- and trt.where_clause = 'BEN_ELIG_TTL_PRTT_PRTE_F'
3702: and cpe.table_alias = c_table_alias
3703: and information1 = c_elig_ttl_prtt_prte_id
3704: -- and information4 = etp.business_group_id
3705: and information2 = etp.effective_start_date

Line 3711: -- END OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------

3707: );
3708: l_elig_ttl_prtt_prte_id number(15);
3709: l_out_etp_result_id number(15);
3710: ---------------------------------------------------------------
3711: -- END OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------
3712: ---------------------------------------------------------------
3713: ---------------------------------------------------------------
3714: -- START OF BEN_ELIG_DSBLD_PRTE_F ----------------------
3715: ---------------------------------------------------------------

Line 11422: -- START OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------

11418: ---------------------------------------------------------------
11419: -- END OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------
11420: ---------------------------------------------------------------
11421: ---------------------------------------------------------------
11422: -- START OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------
11423: ---------------------------------------------------------------
11424: --
11425: for l_parent_rec in c_etp_from_parent(l_ELIGY_PRFL_ID) loop
11426: --

Line 11540: -- END OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------

11536: end loop;
11537: --
11538: end loop;
11539: ---------------------------------------------------------------
11540: -- END OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------
11541: ---------------------------------------------------------------
11542: ---------------------------------------------------------------
11543: -- START OF BEN_ELIG_DSBLD_PRTE_F ----------------------
11544: ---------------------------------------------------------------