APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_TTL_PRTT_RT_F

Line 7014: -- START OF BEN_TTL_PRTT_RT_F ----------------------

7010: ---------------------------------------------------------------
7011: -- END OF BEN_TTL_CVG_VOL_RT_F ----------------------
7012: ---------------------------------------------------------------
7013: ---------------------------------------------------------------
7014: -- START OF BEN_TTL_PRTT_RT_F ----------------------
7015: ---------------------------------------------------------------
7016: cursor c_ttp_from_parent(c_VRBL_RT_PRFL_ID number) is
7017: select ttl_prtt_rt_id
7018: from BEN_TTL_PRTT_RT_F

Line 7018: from BEN_TTL_PRTT_RT_F

7014: -- START OF BEN_TTL_PRTT_RT_F ----------------------
7015: ---------------------------------------------------------------
7016: cursor c_ttp_from_parent(c_VRBL_RT_PRFL_ID number) is
7017: select ttl_prtt_rt_id
7018: from BEN_TTL_PRTT_RT_F
7019: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7020: --
7021: cursor c_ttp(c_ttl_prtt_rt_id number,c_mirror_src_entity_result_id number,
7022: c_table_alias varchar2 ) is

Line 7024: from BEN_TTL_PRTT_RT_F ttp

7020: --
7021: cursor c_ttp(c_ttl_prtt_rt_id number,c_mirror_src_entity_result_id number,
7022: c_table_alias varchar2 ) is
7023: select ttp.*
7024: from BEN_TTL_PRTT_RT_F ttp
7025: where ttp.ttl_prtt_rt_id = c_ttl_prtt_rt_id
7026: -- and ttp.business_group_id = p_business_group_id
7027: and not exists (
7028: select /* */ null

Line 7035: -- and trt.where_clause = 'BEN_TTL_PRTT_RT_F'

7031: where copy_entity_txn_id = p_copy_entity_txn_id
7032: -- and trt.table_route_id = cpe.table_route_id
7033: and ( -- c_mirror_src_entity_result_id is null or
7034: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7035: -- and trt.where_clause = 'BEN_TTL_PRTT_RT_F'
7036: and cpe.table_alias = c_table_alias
7037: and information1 = c_ttl_prtt_rt_id
7038: -- and information4 = ttp.business_group_id
7039: and information2 = ttp.effective_start_date

Line 7044: -- END OF BEN_TTL_PRTT_RT_F ----------------------

7040: and information3 = ttp.effective_end_date);
7041: l_ttl_prtt_rt_id number(15);
7042: l_out_ttp_result_id number(15);
7043: ---------------------------------------------------------------
7044: -- END OF BEN_TTL_PRTT_RT_F ----------------------
7045: ---------------------------------------------------------------
7046: ---------------------------------------------------------------
7047: -- START OF BEN_VRBL_MTCHG_RT_F ----------------------
7048: ---------------------------------------------------------------

Line 12080: -- START OF BEN_TTL_PRTT_RT_F ----------------------

12076: ---------------------------------------------------------------
12077: -- END OF BEN_TTL_CVG_VOL_RT_F ----------------------
12078: ---------------------------------------------------------------
12079: ---------------------------------------------------------------
12080: -- START OF BEN_TTL_PRTT_RT_F ----------------------
12081: ---------------------------------------------------------------
12082: --
12083: for l_parent_rec in c_ttp_from_parent(l_VRBL_RT_PRFL_ID) loop
12084: --

Line 12207: -- END OF BEN_TTL_PRTT_RT_F ----------------------

12203: end loop;
12204: --
12205: end loop;
12206: ---------------------------------------------------------------
12207: -- END OF BEN_TTL_PRTT_RT_F ----------------------
12208: ---------------------------------------------------------------
12209: ---------------------------------------------------------------
12210: -- START OF BEN_VRBL_MTCHG_RT_F ----------------------
12211: ---------------------------------------------------------------