APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_PERF_RTNG_RT_F

Line 7836: -- START OF BEN_PERF_RTNG_RT_F ----------------------

7832: ---------------------------------------------------------------
7833: -- END OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------
7834: ---------------------------------------------------------------
7835: ---------------------------------------------------------------
7836: -- START OF BEN_PERF_RTNG_RT_F ----------------------
7837: ---------------------------------------------------------------
7838: cursor c_prr_from_parent(c_VRBL_RT_PRFL_ID number) is
7839: select perf_rtng_rt_id
7840: from BEN_PERF_RTNG_RT_F

Line 7840: from BEN_PERF_RTNG_RT_F

7836: -- START OF BEN_PERF_RTNG_RT_F ----------------------
7837: ---------------------------------------------------------------
7838: cursor c_prr_from_parent(c_VRBL_RT_PRFL_ID number) is
7839: select perf_rtng_rt_id
7840: from BEN_PERF_RTNG_RT_F
7841: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7842: --
7843: cursor c_prr(c_perf_rtng_rt_id number,c_mirror_src_entity_result_id number,
7844: c_table_alias varchar2 ) is

Line 7846: from BEN_PERF_RTNG_RT_F prr

7842: --
7843: cursor c_prr(c_perf_rtng_rt_id number,c_mirror_src_entity_result_id number,
7844: c_table_alias varchar2 ) is
7845: select prr.*
7846: from BEN_PERF_RTNG_RT_F prr
7847: where prr.perf_rtng_rt_id = c_perf_rtng_rt_id
7848: --and prr.business_group_id = p_business_group_id
7849: and not exists (
7850: select /* */ null

Line 7857: -- and trt.where_clause = 'BEN_PERF_RTNG_RT_F'

7853: where copy_entity_txn_id = p_copy_entity_txn_id
7854: -- and trt.table_route_id = cpe.table_route_id
7855: and ( -- c_mirror_src_entity_result_id is null or
7856: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7857: -- and trt.where_clause = 'BEN_PERF_RTNG_RT_F'
7858: and cpe.table_alias = c_table_alias
7859: and information1 = c_perf_rtng_rt_id
7860: -- and information4 = prr.business_group_id
7861: and information2 = prr.effective_start_date

Line 7866: -- END OF BEN_PERF_RTNG_RT_F ----------------------

7862: and information3 = prr.effective_end_date);
7863: l_perf_rtng_rt_id number(15);
7864: l_out_prr_result_id number(15);
7865: ---------------------------------------------------------------
7866: -- END OF BEN_PERF_RTNG_RT_F ----------------------
7867: ---------------------------------------------------------------
7868: ---------------------------------------------------------------
7869: -- START OF BEN_QUA_IN_GR_RT_F ----------------------
7870: ---------------------------------------------------------------

Line 14762: -- START OF BEN_PERF_RTNG_RT_F ----------------------

14758: ---------------------------------------------------------------
14759: -- END OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------
14760: ---------------------------------------------------------------
14761: ---------------------------------------------------------------
14762: -- START OF BEN_PERF_RTNG_RT_F ----------------------
14763: ---------------------------------------------------------------
14764: --
14765: for l_parent_rec in c_prr_from_parent(l_VRBL_RT_PRFL_ID) loop
14766: --

Line 14863: -- END OF BEN_PERF_RTNG_RT_F ----------------------

14859: end loop;
14860: --
14861: end loop;
14862: ---------------------------------------------------------------
14863: -- END OF BEN_PERF_RTNG_RT_F ----------------------
14864: ---------------------------------------------------------------
14865: ---------------------------------------------------------------
14866: -- START OF BEN_QUA_IN_GR_RT_F ----------------------
14867: ---------------------------------------------------------------