APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_PERF_RTNG_PRTE_F

Line 3544: -- START OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------

3540: -- END OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------
3541: ---------------------------------------------------------------
3542:
3543: ---------------------------------------------------------------
3544: -- START OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------
3545: ---------------------------------------------------------------
3546: cursor c_erg_from_parent(c_ELIGY_PRFL_ID number) is
3547: select elig_perf_rtng_prte_id
3548: from BEN_ELIG_PERF_RTNG_PRTE_F

Line 3548: from BEN_ELIG_PERF_RTNG_PRTE_F

3544: -- START OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------
3545: ---------------------------------------------------------------
3546: cursor c_erg_from_parent(c_ELIGY_PRFL_ID number) is
3547: select elig_perf_rtng_prte_id
3548: from BEN_ELIG_PERF_RTNG_PRTE_F
3549: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3550: --
3551: cursor c_erg(c_elig_perf_rtng_prte_id number,c_mirror_src_entity_result_id number ,
3552: c_table_alias varchar2 ) is

Line 3554: from BEN_ELIG_PERF_RTNG_PRTE_F erg

3550: --
3551: cursor c_erg(c_elig_perf_rtng_prte_id number,c_mirror_src_entity_result_id number ,
3552: c_table_alias varchar2 ) is
3553: select erg.*
3554: from BEN_ELIG_PERF_RTNG_PRTE_F erg
3555: where erg.elig_perf_rtng_prte_id = c_elig_perf_rtng_prte_id
3556: -- and erg.business_group_id = p_business_group_id
3557: and not exists (
3558: select /* */ null

Line 3565: -- and trt.where_clause = 'BEN_ELIG_PERF_RTNG_PRTE_F'

3561: where copy_entity_txn_id = p_copy_entity_txn_id
3562: -- and trt.table_route_id = cpe.table_route_id
3563: and ( -- c_mirror_src_entity_result_id is null or
3564: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3565: -- and trt.where_clause = 'BEN_ELIG_PERF_RTNG_PRTE_F'
3566: and cpe.table_alias = c_table_alias
3567: and information1 = c_elig_perf_rtng_prte_id
3568: -- and information4 = erg.business_group_id
3569: and information2 = erg.effective_start_date

Line 3575: -- END OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------

3571: );
3572: l_elig_perf_rtng_prte_id number(15);
3573: l_out_erg_result_id number(15);
3574: ---------------------------------------------------------------
3575: -- END OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------
3576: ---------------------------------------------------------------
3577: ---------------------------------------------------------------
3578: -- START OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------
3579: ---------------------------------------------------------------

Line 10984: -- START OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------

10980: -- END OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------
10981: ---------------------------------------------------------------
10982:
10983: ---------------------------------------------------------------
10984: -- START OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------
10985: ---------------------------------------------------------------
10986: --
10987: for l_parent_rec in c_erg_from_parent(l_ELIGY_PRFL_ID) loop
10988: --

Line 11088: -- END OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------

11084: end loop;
11085: --
11086: end loop;
11087: ---------------------------------------------------------------
11088: -- END OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------
11089: ---------------------------------------------------------------
11090: ---------------------------------------------------------------
11091: -- START OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------
11092: ---------------------------------------------------------------