APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_DSBLTY_RSN_PRTE_F

Line 3291: -- START OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------

3287: ---------------------------------------------------------------
3288: -- END OF BEN_ELIG_GNDR_PRTE_F ----------------------
3289: ---------------------------------------------------------------
3290: ---------------------------------------------------------------
3291: -- START OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------
3292: ---------------------------------------------------------------
3293: cursor c_edr_from_parent(c_ELIGY_PRFL_ID number) is
3294: select elig_dsblty_rsn_prte_id
3295: from BEN_ELIG_DSBLTY_RSN_PRTE_F

Line 3295: from BEN_ELIG_DSBLTY_RSN_PRTE_F

3291: -- START OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------
3292: ---------------------------------------------------------------
3293: cursor c_edr_from_parent(c_ELIGY_PRFL_ID number) is
3294: select elig_dsblty_rsn_prte_id
3295: from BEN_ELIG_DSBLTY_RSN_PRTE_F
3296: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3297: --
3298: cursor c_edr(c_elig_dsblty_rsn_prte_id number,c_mirror_src_entity_result_id number ,
3299: c_table_alias varchar2 ) is

Line 3301: from BEN_ELIG_DSBLTY_RSN_PRTE_F edr

3297: --
3298: cursor c_edr(c_elig_dsblty_rsn_prte_id number,c_mirror_src_entity_result_id number ,
3299: c_table_alias varchar2 ) is
3300: select edr.*
3301: from BEN_ELIG_DSBLTY_RSN_PRTE_F edr
3302: where edr.elig_dsblty_rsn_prte_id = c_elig_dsblty_rsn_prte_id
3303: -- and edr.business_group_id = p_business_group_id
3304: and not exists (
3305: select /* */ null

Line 3312: -- and trt.where_clause = 'BEN_ELIG_DSBLTY_RSN_PRTE_F'

3308: where copy_entity_txn_id = p_copy_entity_txn_id
3309: -- and trt.table_route_id = cpe.table_route_id
3310: and ( -- c_mirror_src_entity_result_id is null or
3311: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3312: -- and trt.where_clause = 'BEN_ELIG_DSBLTY_RSN_PRTE_F'
3313: and cpe.table_alias = c_table_alias
3314: and information1 = c_elig_dsblty_rsn_prte_id
3315: -- and information4 = edr.business_group_id
3316: and information2 = edr.effective_start_date

Line 3322: -- END OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------

3318: );
3319: l_elig_dsblty_rsn_prte_id number(15);
3320: l_out_edr_result_id number(15);
3321: ---------------------------------------------------------------
3322: -- END OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------
3323: ---------------------------------------------------------------
3324: ---------------------------------------------------------------
3325: -- START OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------
3326: ---------------------------------------------------------------

Line 10369: -- START OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------

10365: ---------------------------------------------------------------
10366: -- END OF BEN_ELIG_GNDR_PRTE_F ----------------------
10367: ---------------------------------------------------------------
10368: ---------------------------------------------------------------
10369: -- START OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------
10370: ---------------------------------------------------------------
10371: --
10372: for l_parent_rec in c_edr_from_parent(l_ELIGY_PRFL_ID) loop
10373: --

Line 10473: -- END OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------

10469: end loop;
10470: --
10471: end loop;
10472: ---------------------------------------------------------------
10473: -- END OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------
10474: ---------------------------------------------------------------
10475: ---------------------------------------------------------------
10476: -- START OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------
10477: ---------------------------------------------------------------