APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_POE_RT_F

Line 6668: -- START OF BEN_POE_RT_F ----------------------

6664: ---------------------------------------------------------------
6665: -- END OF BEN_PER_TYP_RT_F ----------------------
6666: ---------------------------------------------------------------
6667: ---------------------------------------------------------------
6668: -- START OF BEN_POE_RT_F ----------------------
6669: ---------------------------------------------------------------
6670: cursor c_prt_from_parent(c_VRBL_RT_PRFL_ID number) is
6671: select poe_rt_id
6672: from BEN_POE_RT_F

Line 6672: from BEN_POE_RT_F

6668: -- START OF BEN_POE_RT_F ----------------------
6669: ---------------------------------------------------------------
6670: cursor c_prt_from_parent(c_VRBL_RT_PRFL_ID number) is
6671: select poe_rt_id
6672: from BEN_POE_RT_F
6673: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6674: --
6675: cursor c_prt(c_poe_rt_id number,c_mirror_src_entity_result_id number,
6676: c_table_alias varchar2 ) is

Line 6678: from BEN_POE_RT_F prt

6674: --
6675: cursor c_prt(c_poe_rt_id number,c_mirror_src_entity_result_id number,
6676: c_table_alias varchar2 ) is
6677: select prt.*
6678: from BEN_POE_RT_F prt
6679: where prt.poe_rt_id = c_poe_rt_id
6680: -- and prt.business_group_id = p_business_group_id
6681: and not exists (
6682: select /* */ null

Line 6689: -- and trt.where_clause = 'BEN_POE_RT_F'

6685: where copy_entity_txn_id = p_copy_entity_txn_id
6686: -- and trt.table_route_id = cpe.table_route_id
6687: and ( -- c_mirror_src_entity_result_id is null or
6688: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6689: -- and trt.where_clause = 'BEN_POE_RT_F'
6690: and cpe.table_alias = c_table_alias
6691: and information1 = c_poe_rt_id
6692: -- and information4 = prt.business_group_id
6693: and information2 = prt.effective_start_date

Line 6698: -- END OF BEN_POE_RT_F ----------------------

6694: and information3 = prt.effective_end_date);
6695: l_poe_rt_id number(15);
6696: l_out_prt_result_id number(15);
6697: ---------------------------------------------------------------
6698: -- END OF BEN_POE_RT_F ----------------------
6699: ---------------------------------------------------------------
6700: ---------------------------------------------------------------
6701: -- START OF BEN_PPL_GRP_RT_F ----------------------
6702: ---------------------------------------------------------------

Line 10918: -- START OF BEN_POE_RT_F ----------------------

10914: ---------------------------------------------------------------
10915: -- END OF BEN_PER_TYP_RT_F ----------------------
10916: ---------------------------------------------------------------
10917: ---------------------------------------------------------------
10918: -- START OF BEN_POE_RT_F ----------------------
10919: ---------------------------------------------------------------
10920: --
10921: for l_parent_rec in c_prt_from_parent(l_VRBL_RT_PRFL_ID) loop
10922: --

Line 11046: -- END OF BEN_POE_RT_F ----------------------

11042: end loop;
11043: --
11044: end loop;
11045: ---------------------------------------------------------------
11046: -- END OF BEN_POE_RT_F ----------------------
11047: ---------------------------------------------------------------
11048: ---------------------------------------------------------------
11049: -- START OF BEN_PPL_GRP_RT_F ----------------------
11050: ---------------------------------------------------------------