DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_OTHR_PTIP_RT_F

Line 7902: -- START OF BEN_OTHR_PTIP_RT_F ----------------------

7898: ---------------------------------------------------------------
7899: -- END OF BEN_QUA_IN_GR_RT_F ----------------------
7900: ---------------------------------------------------------------
7901: ---------------------------------------------------------------
7902: -- START OF BEN_OTHR_PTIP_RT_F ----------------------
7903: ---------------------------------------------------------------
7904: cursor c_opr_from_parent(c_VRBL_RT_PRFL_ID number) is
7905: select othr_ptip_rt_id
7906: from BEN_OTHR_PTIP_RT_F

Line 7906: from BEN_OTHR_PTIP_RT_F

7902: -- START OF BEN_OTHR_PTIP_RT_F ----------------------
7903: ---------------------------------------------------------------
7904: cursor c_opr_from_parent(c_VRBL_RT_PRFL_ID number) is
7905: select othr_ptip_rt_id
7906: from BEN_OTHR_PTIP_RT_F
7907: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7908: --
7909: cursor c_opr(c_othr_ptip_rt_id number,c_mirror_src_entity_result_id number,
7910: c_table_alias varchar2 ) is

Line 7912: from BEN_OTHR_PTIP_RT_F opr

7908: --
7909: cursor c_opr(c_othr_ptip_rt_id number,c_mirror_src_entity_result_id number,
7910: c_table_alias varchar2 ) is
7911: select opr.*
7912: from BEN_OTHR_PTIP_RT_F opr
7913: where opr.othr_ptip_rt_id = c_othr_ptip_rt_id
7914: --and opr.business_group_id = p_business_group_id
7915: and not exists (
7916: select /* */ null

Line 7923: -- and trt.where_clause = 'BEN_OTHR_PTIP_RT_F'

7919: where copy_entity_txn_id = p_copy_entity_txn_id
7920: -- and trt.table_route_id = cpe.table_route_id
7921: and ( -- c_mirror_src_entity_result_id is null or
7922: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7923: -- and trt.where_clause = 'BEN_OTHR_PTIP_RT_F'
7924: and cpe.table_alias = c_table_alias
7925: and information1 = c_othr_ptip_rt_id
7926: -- and information4 = opr.business_group_id
7927: and information2 = opr.effective_start_date

Line 7932: -- END OF BEN_OTHR_PTIP_RT_F ----------------------

7928: and information3 = opr.effective_end_date);
7929: l_othr_ptip_rt_id number(15);
7930: l_out_opr_result_id number(15);
7931: ---------------------------------------------------------------
7932: -- END OF BEN_OTHR_PTIP_RT_F ----------------------
7933: ---------------------------------------------------------------
7934:
7935: cursor c_object_exists(c_pk_id number,
7936: c_table_alias varchar2) is

Line 14968: -- START OF BEN_OTHR_PTIP_RT_F ----------------------

14964: ---------------------------------------------------------------
14965: -- END OF BEN_QUA_IN_GR_RT_F ----------------------
14966: ---------------------------------------------------------------
14967: ---------------------------------------------------------------
14968: -- START OF BEN_OTHR_PTIP_RT_F ----------------------
14969: ---------------------------------------------------------------
14970: --
14971: for l_parent_rec in c_opr_from_parent(l_VRBL_RT_PRFL_ID) loop
14972: --

Line 15068: -- END OF BEN_OTHR_PTIP_RT_F ----------------------

15064: end loop;
15065: --
15066: end loop;
15067: ---------------------------------------------------------------
15068: -- END OF BEN_OTHR_PTIP_RT_F ----------------------
15069: ---------------------------------------------------------------
15070: ---------------------------------------------------------------
15071: -- END OF BEN_VRBL_RT_PRFL_F ----------------------
15072: ---------------------------------------------------------------