DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_QUA_IN_GR_RT_F

Line 7869: -- START OF BEN_QUA_IN_GR_RT_F ----------------------

7865: ---------------------------------------------------------------
7866: -- END OF BEN_PERF_RTNG_RT_F ----------------------
7867: ---------------------------------------------------------------
7868: ---------------------------------------------------------------
7869: -- START OF BEN_QUA_IN_GR_RT_F ----------------------
7870: ---------------------------------------------------------------
7871: cursor c_qig_from_parent(c_VRBL_RT_PRFL_ID number) is
7872: select qua_in_gr_rt_id
7873: from BEN_QUA_IN_GR_RT_F

Line 7873: from BEN_QUA_IN_GR_RT_F

7869: -- START OF BEN_QUA_IN_GR_RT_F ----------------------
7870: ---------------------------------------------------------------
7871: cursor c_qig_from_parent(c_VRBL_RT_PRFL_ID number) is
7872: select qua_in_gr_rt_id
7873: from BEN_QUA_IN_GR_RT_F
7874: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7875: --
7876: cursor c_qig(c_qua_in_gr_rt_id number,c_mirror_src_entity_result_id number,
7877: c_table_alias varchar2 ) is

Line 7879: from BEN_QUA_IN_GR_RT_F qig

7875: --
7876: cursor c_qig(c_qua_in_gr_rt_id number,c_mirror_src_entity_result_id number,
7877: c_table_alias varchar2 ) is
7878: select qig.*
7879: from BEN_QUA_IN_GR_RT_F qig
7880: where qig.qua_in_gr_rt_id = c_qua_in_gr_rt_id
7881: --and qig.business_group_id = p_business_group_id
7882: and not exists (
7883: select /* */ null

Line 7890: -- and trt.where_clause = 'BEN_QUA_IN_GR_RT_F'

7886: where copy_entity_txn_id = p_copy_entity_txn_id
7887: -- and trt.table_route_id = cpe.table_route_id
7888: and ( -- c_mirror_src_entity_result_id is null or
7889: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7890: -- and trt.where_clause = 'BEN_QUA_IN_GR_RT_F'
7891: and cpe.table_alias = c_table_alias
7892: and information1 = c_qua_in_gr_rt_id
7893: -- and information4 = qig.business_group_id
7894: and information2 = qig.effective_start_date

Line 7899: -- END OF BEN_QUA_IN_GR_RT_F ----------------------

7895: and information3 = qig.effective_end_date);
7896: l_qua_in_gr_rt_id number(15);
7897: l_out_qig_result_id number(15);
7898: ---------------------------------------------------------------
7899: -- END OF BEN_QUA_IN_GR_RT_F ----------------------
7900: ---------------------------------------------------------------
7901: ---------------------------------------------------------------
7902: -- START OF BEN_OTHR_PTIP_RT_F ----------------------
7903: ---------------------------------------------------------------

Line 14866: -- START OF BEN_QUA_IN_GR_RT_F ----------------------

14862: ---------------------------------------------------------------
14863: -- END OF BEN_PERF_RTNG_RT_F ----------------------
14864: ---------------------------------------------------------------
14865: ---------------------------------------------------------------
14866: -- START OF BEN_QUA_IN_GR_RT_F ----------------------
14867: ---------------------------------------------------------------
14868: --
14869: for l_parent_rec in c_qig_from_parent(l_VRBL_RT_PRFL_ID) loop
14870: --

Line 14965: -- END OF BEN_QUA_IN_GR_RT_F ----------------------

14961: end loop;
14962: --
14963: end loop;
14964: ---------------------------------------------------------------
14965: -- END OF BEN_QUA_IN_GR_RT_F ----------------------
14966: ---------------------------------------------------------------
14967: ---------------------------------------------------------------
14968: -- START OF BEN_OTHR_PTIP_RT_F ----------------------
14969: ---------------------------------------------------------------