APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_GRD_PRTE_F

Line 2064: -- START OF BEN_ELIG_GRD_PRTE_F ----------------------

2060: ---------------------------------------------------------------
2061: -- END OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------
2062: ---------------------------------------------------------------
2063: ---------------------------------------------------------------
2064: -- START OF BEN_ELIG_GRD_PRTE_F ----------------------
2065: ---------------------------------------------------------------
2066: cursor c_egr_from_parent(c_ELIGY_PRFL_ID number) is
2067: select elig_grd_prte_id
2068: from BEN_ELIG_GRD_PRTE_F

Line 2068: from BEN_ELIG_GRD_PRTE_F

2064: -- START OF BEN_ELIG_GRD_PRTE_F ----------------------
2065: ---------------------------------------------------------------
2066: cursor c_egr_from_parent(c_ELIGY_PRFL_ID number) is
2067: select elig_grd_prte_id
2068: from BEN_ELIG_GRD_PRTE_F
2069: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2070: --
2071: cursor c_egr(c_elig_grd_prte_id number,c_mirror_src_entity_result_id number ,
2072: c_table_alias varchar2 ) is

Line 2074: from BEN_ELIG_GRD_PRTE_F egr

2070: --
2071: cursor c_egr(c_elig_grd_prte_id number,c_mirror_src_entity_result_id number ,
2072: c_table_alias varchar2 ) is
2073: select egr.*
2074: from BEN_ELIG_GRD_PRTE_F egr
2075: where egr.elig_grd_prte_id = c_elig_grd_prte_id
2076: -- and egr.business_group_id = p_business_group_id
2077: and not exists (
2078: select /* */ null

Line 2085: -- and trt.where_clause = 'BEN_ELIG_GRD_PRTE_F'

2081: where copy_entity_txn_id = p_copy_entity_txn_id
2082: -- and trt.table_route_id = cpe.table_route_id
2083: and ( -- c_mirror_src_entity_result_id is null or
2084: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2085: -- and trt.where_clause = 'BEN_ELIG_GRD_PRTE_F'
2086: and cpe.table_alias = c_table_alias
2087: and information1 = c_elig_grd_prte_id
2088: -- and information4 = egr.business_group_id
2089: and information2 = egr.effective_start_date

Line 2111: -- END OF BEN_ELIG_GRD_PRTE_F ----------------------

2107: where grade_id = c_grade_id;
2108:
2109: l_grade_start_date per_grades.date_from%type;
2110: ---------------------------------------------------------------
2111: -- END OF BEN_ELIG_GRD_PRTE_F ----------------------
2112: ---------------------------------------------------------------
2113: ---------------------------------------------------------------
2114: -- START OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------
2115: ---------------------------------------------------------------

Line 6652: -- START OF BEN_ELIG_GRD_PRTE_F ----------------------

6648: ---------------------------------------------------------------
6649: -- END OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------
6650: ---------------------------------------------------------------
6651: ---------------------------------------------------------------
6652: -- START OF BEN_ELIG_GRD_PRTE_F ----------------------
6653: ---------------------------------------------------------------
6654: --
6655: for l_parent_rec in c_egr_from_parent(l_ELIGY_PRFL_ID) loop
6656: --

Line 6798: -- END OF BEN_ELIG_GRD_PRTE_F ----------------------

6794: end loop;
6795: --
6796: end loop;
6797: ---------------------------------------------------------------
6798: -- END OF BEN_ELIG_GRD_PRTE_F ----------------------
6799: ---------------------------------------------------------------
6800: ---------------------------------------------------------------
6801: -- START OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------
6802: ---------------------------------------------------------------