APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_DSBLTY_DGR_PRTE_F

Line 3325: -- START OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------

3321: ---------------------------------------------------------------
3322: -- END OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------
3323: ---------------------------------------------------------------
3324: ---------------------------------------------------------------
3325: -- START OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------
3326: ---------------------------------------------------------------
3327: cursor c_edd_from_parent(c_ELIGY_PRFL_ID number) is
3328: select elig_dsblty_dgr_prte_id
3329: from BEN_ELIG_DSBLTY_DGR_PRTE_F

Line 3329: from BEN_ELIG_DSBLTY_DGR_PRTE_F

3325: -- START OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------
3326: ---------------------------------------------------------------
3327: cursor c_edd_from_parent(c_ELIGY_PRFL_ID number) is
3328: select elig_dsblty_dgr_prte_id
3329: from BEN_ELIG_DSBLTY_DGR_PRTE_F
3330: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3331: --
3332: cursor c_edd(c_elig_dsblty_dgr_prte_id number,c_mirror_src_entity_result_id number ,
3333: c_table_alias varchar2 ) is

Line 3335: from BEN_ELIG_DSBLTY_DGR_PRTE_F edd

3331: --
3332: cursor c_edd(c_elig_dsblty_dgr_prte_id number,c_mirror_src_entity_result_id number ,
3333: c_table_alias varchar2 ) is
3334: select edd.*
3335: from BEN_ELIG_DSBLTY_DGR_PRTE_F edd
3336: where edd.elig_dsblty_dgr_prte_id = c_elig_dsblty_dgr_prte_id
3337: -- and edd.business_group_id = p_business_group_id
3338: and not exists (
3339: select /* */ null

Line 3346: -- and trt.where_clause = 'BEN_ELIG_DSBLTY_DGR_PRTE_F'

3342: where copy_entity_txn_id = p_copy_entity_txn_id
3343: -- and trt.table_route_id = cpe.table_route_id
3344: and ( -- c_mirror_src_entity_result_id is null or
3345: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3346: -- and trt.where_clause = 'BEN_ELIG_DSBLTY_DGR_PRTE_F'
3347: and cpe.table_alias = c_table_alias
3348: and information1 = c_elig_dsblty_dgr_prte_id
3349: -- and information4 = edd.business_group_id
3350: and information2 = edd.effective_start_date

Line 3356: -- END OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------

3352: );
3353: l_elig_dsblty_dgr_prte_id number(15);
3354: l_out_edd_result_id number(15);
3355: ---------------------------------------------------------------
3356: -- END OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------
3357: ---------------------------------------------------------------
3358: ---------------------------------------------------------------
3359: -- START OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------
3360: ---------------------------------------------------------------

Line 10476: -- START OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------

10472: ---------------------------------------------------------------
10473: -- END OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------
10474: ---------------------------------------------------------------
10475: ---------------------------------------------------------------
10476: -- START OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------
10477: ---------------------------------------------------------------
10478: --
10479: for l_parent_rec in c_edd_from_parent(l_ELIGY_PRFL_ID) loop
10480: --

Line 10579: -- END OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------

10575: end loop;
10576: --
10577: end loop;
10578: ---------------------------------------------------------------
10579: -- END OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------
10580: ---------------------------------------------------------------
10581: ---------------------------------------------------------------
10582: -- START OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------
10583: ---------------------------------------------------------------