DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_PPL_GRP_RT_F

Line 6701: -- START OF BEN_PPL_GRP_RT_F ----------------------

6697: ---------------------------------------------------------------
6698: -- END OF BEN_POE_RT_F ----------------------
6699: ---------------------------------------------------------------
6700: ---------------------------------------------------------------
6701: -- START OF BEN_PPL_GRP_RT_F ----------------------
6702: ---------------------------------------------------------------
6703: cursor c_pgr_from_parent(c_VRBL_RT_PRFL_ID number) is
6704: select ppl_grp_rt_id
6705: from BEN_PPL_GRP_RT_F

Line 6705: from BEN_PPL_GRP_RT_F

6701: -- START OF BEN_PPL_GRP_RT_F ----------------------
6702: ---------------------------------------------------------------
6703: cursor c_pgr_from_parent(c_VRBL_RT_PRFL_ID number) is
6704: select ppl_grp_rt_id
6705: from BEN_PPL_GRP_RT_F
6706: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
6707: --
6708: cursor c_pgr(c_ppl_grp_rt_id number,c_mirror_src_entity_result_id number,
6709: c_table_alias varchar2 ) is

Line 6711: from BEN_PPL_GRP_RT_F pgr

6707: --
6708: cursor c_pgr(c_ppl_grp_rt_id number,c_mirror_src_entity_result_id number,
6709: c_table_alias varchar2 ) is
6710: select pgr.*
6711: from BEN_PPL_GRP_RT_F pgr
6712: where pgr.ppl_grp_rt_id = c_ppl_grp_rt_id
6713: -- and pgr.business_group_id = p_business_group_id
6714: and not exists (
6715: select /* */ null

Line 6722: -- and trt.where_clause = 'BEN_PPL_GRP_RT_F'

6718: where copy_entity_txn_id = p_copy_entity_txn_id
6719: -- and trt.table_route_id = cpe.table_route_id
6720: and ( -- c_mirror_src_entity_result_id is null or
6721: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6722: -- and trt.where_clause = 'BEN_PPL_GRP_RT_F'
6723: and cpe.table_alias = c_table_alias
6724: and information1 = c_ppl_grp_rt_id
6725: -- and information4 = pgr.business_group_id
6726: and information2 = pgr.effective_start_date

Line 6731: -- END OF BEN_PPL_GRP_RT_F ----------------------

6727: and information3 = pgr.effective_end_date);
6728: l_ppl_grp_rt_id number(15);
6729: l_out_pgr_result_id number(15);
6730: ---------------------------------------------------------------
6731: -- END OF BEN_PPL_GRP_RT_F ----------------------
6732: ---------------------------------------------------------------
6733: ---------------------------------------------------------------
6734: -- START OF BEN_PSTL_ZIP_RT_F ----------------------
6735: ---------------------------------------------------------------

Line 11049: -- START OF BEN_PPL_GRP_RT_F ----------------------

11045: ---------------------------------------------------------------
11046: -- END OF BEN_POE_RT_F ----------------------
11047: ---------------------------------------------------------------
11048: ---------------------------------------------------------------
11049: -- START OF BEN_PPL_GRP_RT_F ----------------------
11050: ---------------------------------------------------------------
11051: --
11052: for l_parent_rec in c_pgr_from_parent(l_VRBL_RT_PRFL_ID) loop
11053: --

Line 11149: -- END OF BEN_PPL_GRP_RT_F ----------------------

11145: end loop;
11146: --
11147: end loop;
11148: ---------------------------------------------------------------
11149: -- END OF BEN_PPL_GRP_RT_F ----------------------
11150: ---------------------------------------------------------------
11151: ---------------------------------------------------------------
11152: -- START OF BEN_PSTL_ZIP_RT_F ----------------------
11153: ---------------------------------------------------------------