APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_GNDR_PRTE_F

Line 3257: -- START OF BEN_ELIG_GNDR_PRTE_F ----------------------

3253: ---------------------------------------------------------------
3254: -- END OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------
3255: ---------------------------------------------------------------
3256: ---------------------------------------------------------------
3257: -- START OF BEN_ELIG_GNDR_PRTE_F ----------------------
3258: ---------------------------------------------------------------
3259: cursor c_egn_from_parent(c_ELIGY_PRFL_ID number) is
3260: select elig_gndr_prte_id
3261: from BEN_ELIG_GNDR_PRTE_F

Line 3261: from BEN_ELIG_GNDR_PRTE_F

3257: -- START OF BEN_ELIG_GNDR_PRTE_F ----------------------
3258: ---------------------------------------------------------------
3259: cursor c_egn_from_parent(c_ELIGY_PRFL_ID number) is
3260: select elig_gndr_prte_id
3261: from BEN_ELIG_GNDR_PRTE_F
3262: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3263: --
3264: cursor c_egn(c_elig_gndr_prte_id number,c_mirror_src_entity_result_id number ,
3265: c_table_alias varchar2 ) is

Line 3267: from BEN_ELIG_GNDR_PRTE_F egn

3263: --
3264: cursor c_egn(c_elig_gndr_prte_id number,c_mirror_src_entity_result_id number ,
3265: c_table_alias varchar2 ) is
3266: select egn.*
3267: from BEN_ELIG_GNDR_PRTE_F egn
3268: where egn.elig_gndr_prte_id = c_elig_gndr_prte_id
3269: -- and egn.business_group_id = p_business_group_id
3270: and not exists (
3271: select /* */ null

Line 3278: -- and trt.where_clause = 'BEN_ELIG_GNDR_PRTE_F'

3274: where copy_entity_txn_id = p_copy_entity_txn_id
3275: -- and trt.table_route_id = cpe.table_route_id
3276: and ( -- c_mirror_src_entity_result_id is null or
3277: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3278: -- and trt.where_clause = 'BEN_ELIG_GNDR_PRTE_F'
3279: and cpe.table_alias = c_table_alias
3280: and information1 = c_elig_gndr_prte_id
3281: -- and information4 = egn.business_group_id
3282: and information2 = egn.effective_start_date

Line 3288: -- END OF BEN_ELIG_GNDR_PRTE_F ----------------------

3284: );
3285: l_elig_gndr_prte_id number(15);
3286: l_out_egn_result_id number(15);
3287: ---------------------------------------------------------------
3288: -- END OF BEN_ELIG_GNDR_PRTE_F ----------------------
3289: ---------------------------------------------------------------
3290: ---------------------------------------------------------------
3291: -- START OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------
3292: ---------------------------------------------------------------

Line 10262: -- START OF BEN_ELIG_GNDR_PRTE_F ----------------------

10258: ---------------------------------------------------------------
10259: -- END OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------
10260: ---------------------------------------------------------------
10261: ---------------------------------------------------------------
10262: -- START OF BEN_ELIG_GNDR_PRTE_F ----------------------
10263: ---------------------------------------------------------------
10264: --
10265: for l_parent_rec in c_egn_from_parent(l_ELIGY_PRFL_ID) loop
10266: --

Line 10366: -- END OF BEN_ELIG_GNDR_PRTE_F ----------------------

10362: end loop;
10363: --
10364: end loop;
10365: ---------------------------------------------------------------
10366: -- END OF BEN_ELIG_GNDR_PRTE_F ----------------------
10367: ---------------------------------------------------------------
10368: ---------------------------------------------------------------
10369: -- START OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------
10370: ---------------------------------------------------------------