APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_TTL_CVG_VOL_RT_F

Line 6981: -- START OF BEN_TTL_CVG_VOL_RT_F ----------------------

6977: ---------------------------------------------------------------
6978: -- END OF BEN_TBCO_USE_RT_F ----------------------
6979: ---------------------------------------------------------------
6980: ---------------------------------------------------------------
6981: -- START OF BEN_TTL_CVG_VOL_RT_F ----------------------
6982: ---------------------------------------------------------------
6983: cursor c_tcv_from_parent(c_VRBL_RT_PRFL_ID number) is
6984: select ttl_cvg_vol_rt_id
6985: from BEN_TTL_CVG_VOL_RT_F

Line 6985: from BEN_TTL_CVG_VOL_RT_F

6981: -- START OF BEN_TTL_CVG_VOL_RT_F ----------------------
6982: ---------------------------------------------------------------
6983: cursor c_tcv_from_parent(c_VRBL_RT_PRFL_ID number) is
6984: select ttl_cvg_vol_rt_id
6985: from BEN_TTL_CVG_VOL_RT_F
6986: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6987: --
6988: cursor c_tcv(c_ttl_cvg_vol_rt_id number,c_mirror_src_entity_result_id number,
6989: c_table_alias varchar2 ) is

Line 6991: from BEN_TTL_CVG_VOL_RT_F tcv

6987: --
6988: cursor c_tcv(c_ttl_cvg_vol_rt_id number,c_mirror_src_entity_result_id number,
6989: c_table_alias varchar2 ) is
6990: select tcv.*
6991: from BEN_TTL_CVG_VOL_RT_F tcv
6992: where tcv.ttl_cvg_vol_rt_id = c_ttl_cvg_vol_rt_id
6993: -- and tcv.business_group_id = p_business_group_id
6994: and not exists (
6995: select /* */ null

Line 7002: -- and trt.where_clause = 'BEN_TTL_CVG_VOL_RT_F'

6998: where copy_entity_txn_id = p_copy_entity_txn_id
6999: -- and trt.table_route_id = cpe.table_route_id
7000: and ( -- c_mirror_src_entity_result_id is null or
7001: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7002: -- and trt.where_clause = 'BEN_TTL_CVG_VOL_RT_F'
7003: and cpe.table_alias = c_table_alias
7004: and information1 = c_ttl_cvg_vol_rt_id
7005: -- and information4 = tcv.business_group_id
7006: and information2 = tcv.effective_start_date

Line 7011: -- END OF BEN_TTL_CVG_VOL_RT_F ----------------------

7007: and information3 = tcv.effective_end_date);
7008: l_ttl_cvg_vol_rt_id number(15);
7009: l_out_tcv_result_id number(15);
7010: ---------------------------------------------------------------
7011: -- END OF BEN_TTL_CVG_VOL_RT_F ----------------------
7012: ---------------------------------------------------------------
7013: ---------------------------------------------------------------
7014: -- START OF BEN_TTL_PRTT_RT_F ----------------------
7015: ---------------------------------------------------------------

Line 11950: -- START OF BEN_TTL_CVG_VOL_RT_F ----------------------

11946: ---------------------------------------------------------------
11947: -- END OF BEN_TBCO_USE_RT_F ----------------------
11948: ---------------------------------------------------------------
11949: ---------------------------------------------------------------
11950: -- START OF BEN_TTL_CVG_VOL_RT_F ----------------------
11951: ---------------------------------------------------------------
11952: --
11953: for l_parent_rec in c_tcv_from_parent(l_VRBL_RT_PRFL_ID) loop
11954: --

Line 12077: -- END OF BEN_TTL_CVG_VOL_RT_F ----------------------

12073: end loop;
12074: --
12075: end loop;
12076: ---------------------------------------------------------------
12077: -- END OF BEN_TTL_CVG_VOL_RT_F ----------------------
12078: ---------------------------------------------------------------
12079: ---------------------------------------------------------------
12080: -- START OF BEN_TTL_PRTT_RT_F ----------------------
12081: ---------------------------------------------------------------