APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_DSBLTY_CTG_PRTE_F

Line 3453: -- START OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------

3449: ---------------------------------------------------------------
3450: -- END OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------
3451: ---------------------------------------------------------------
3452: ---------------------------------------------------------------
3453: -- START OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------
3454: ---------------------------------------------------------------
3455: cursor c_ect_from_parent(c_ELIGY_PRFL_ID number) is
3456: select elig_dsblty_ctg_prte_id
3457: from BEN_ELIG_DSBLTY_CTG_PRTE_F

Line 3457: from BEN_ELIG_DSBLTY_CTG_PRTE_F

3453: -- START OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------
3454: ---------------------------------------------------------------
3455: cursor c_ect_from_parent(c_ELIGY_PRFL_ID number) is
3456: select elig_dsblty_ctg_prte_id
3457: from BEN_ELIG_DSBLTY_CTG_PRTE_F
3458: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3459: --
3460: cursor c_ect(c_elig_dsblty_ctg_prte_id number,c_mirror_src_entity_result_id number ,
3461: c_table_alias varchar2 ) is

Line 3463: from BEN_ELIG_DSBLTY_CTG_PRTE_F ect

3459: --
3460: cursor c_ect(c_elig_dsblty_ctg_prte_id number,c_mirror_src_entity_result_id number ,
3461: c_table_alias varchar2 ) is
3462: select ect.*
3463: from BEN_ELIG_DSBLTY_CTG_PRTE_F ect
3464: where ect.elig_dsblty_ctg_prte_id = c_elig_dsblty_ctg_prte_id
3465: -- and ect.business_group_id = p_business_group_id
3466: and not exists (
3467: select /* */ null

Line 3474: -- and trt.where_clause = 'BEN_ELIG_DSBLTY_CTG_PRTE_F'

3470: where copy_entity_txn_id = p_copy_entity_txn_id
3471: -- and trt.table_route_id = cpe.table_route_id
3472: and ( -- c_mirror_src_entity_result_id is null or
3473: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3474: -- and trt.where_clause = 'BEN_ELIG_DSBLTY_CTG_PRTE_F'
3475: and cpe.table_alias = c_table_alias
3476: and information1 = c_elig_dsblty_ctg_prte_id
3477: -- and information4 = ect.business_group_id
3478: and information2 = ect.effective_start_date

Line 3484: -- END OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------

3480: );
3481: l_elig_dsblty_ctg_prte_id number(15);
3482: l_out_ect_result_id number(15);
3483: ---------------------------------------------------------------
3484: -- END OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------
3485: ---------------------------------------------------------------
3486: ---------------------------------------------------------------
3487: -- START OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------
3488: ---------------------------------------------------------------

Line 10877: -- START OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------

10873: ---------------------------------------------------------------
10874: -- END OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------
10875: ---------------------------------------------------------------
10876: --------------------------------------------------------------
10877: -- START OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------
10878: ---------------------------------------------------------------
10879: --
10880: for l_parent_rec in c_ect_from_parent(l_ELIGY_PRFL_ID) loop
10881: --

Line 10980: -- END OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------

10976: end loop;
10977: --
10978: end loop;
10979: ---------------------------------------------------------------
10980: -- END OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------
10981: ---------------------------------------------------------------
10982:
10983: ---------------------------------------------------------------
10984: -- START OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------