APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_SUPPL_ROLE_PRTE_F

Line 3401: -- START OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------

3397: ---------------------------------------------------------------
3398: -- END OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------
3399: ---------------------------------------------------------------
3400: ---------------------------------------------------------------
3401: -- START OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------
3402: ---------------------------------------------------------------
3403: cursor c_est_from_parent(c_ELIGY_PRFL_ID number) is
3404: select elig_suppl_role_prte_id
3405: from BEN_ELIG_SUPPL_ROLE_PRTE_F

Line 3405: from BEN_ELIG_SUPPL_ROLE_PRTE_F

3401: -- START OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------
3402: ---------------------------------------------------------------
3403: cursor c_est_from_parent(c_ELIGY_PRFL_ID number) is
3404: select elig_suppl_role_prte_id
3405: from BEN_ELIG_SUPPL_ROLE_PRTE_F
3406: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3407: --
3408: cursor c_est(c_elig_suppl_role_prte_id number,c_mirror_src_entity_result_id number ,
3409: c_table_alias varchar2 ) is

Line 3411: from BEN_ELIG_SUPPL_ROLE_PRTE_F est

3407: --
3408: cursor c_est(c_elig_suppl_role_prte_id number,c_mirror_src_entity_result_id number ,
3409: c_table_alias varchar2 ) is
3410: select est.*
3411: from BEN_ELIG_SUPPL_ROLE_PRTE_F est
3412: where est.elig_suppl_role_prte_id = c_elig_suppl_role_prte_id
3413: -- and est.business_group_id = p_business_group_id
3414: and not exists (
3415: select /* */ null

Line 3422: -- and trt.where_clause = 'BEN_ELIG_SUPPL_ROLE_PRTE_F'

3418: where copy_entity_txn_id = p_copy_entity_txn_id
3419: -- and trt.table_route_id = cpe.table_route_id
3420: and ( -- c_mirror_src_entity_result_id is null or
3421: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3422: -- and trt.where_clause = 'BEN_ELIG_SUPPL_ROLE_PRTE_F'
3423: and cpe.table_alias = c_table_alias
3424: and information1 = c_elig_suppl_role_prte_id
3425: -- and information4 = est.business_group_id
3426: and information2 = est.effective_start_date

Line 3450: -- END OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------

3446: and job_id = p_id
3447: and job_group_id = p_id1;
3448:
3449: ---------------------------------------------------------------
3450: -- END OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------
3451: ---------------------------------------------------------------
3452: ---------------------------------------------------------------
3453: -- START OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------
3454: ---------------------------------------------------------------

Line 10718: -- START OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------

10714: ---------------------------------------------------------------
10715: -- END OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------
10716: ---------------------------------------------------------------
10717: ---------------------------------------------------------------
10718: -- START OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------
10719: ---------------------------------------------------------------
10720: --
10721: for l_parent_rec in c_est_from_parent(l_ELIGY_PRFL_ID) loop
10722: --

Line 10874: -- END OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------

10870: end loop;
10871: --
10872: end loop;
10873: ---------------------------------------------------------------
10874: -- END OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------
10875: ---------------------------------------------------------------
10876: --------------------------------------------------------------
10877: -- START OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------
10878: ---------------------------------------------------------------