APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_PSTN_PRTE_F

Line 3140: -- START OF BEN_ELIG_PSTN_PRTE_F ----------------------

3136: ---------------------------------------------------------------
3137: -- END OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------
3138: ---------------------------------------------------------------
3139: ---------------------------------------------------------------
3140: -- START OF BEN_ELIG_PSTN_PRTE_F ----------------------
3141: ---------------------------------------------------------------
3142: cursor c_eps_from_parent(c_ELIGY_PRFL_ID number) is
3143: select elig_pstn_prte_id
3144: from BEN_ELIG_PSTN_PRTE_F

Line 3144: from BEN_ELIG_PSTN_PRTE_F

3140: -- START OF BEN_ELIG_PSTN_PRTE_F ----------------------
3141: ---------------------------------------------------------------
3142: cursor c_eps_from_parent(c_ELIGY_PRFL_ID number) is
3143: select elig_pstn_prte_id
3144: from BEN_ELIG_PSTN_PRTE_F
3145: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3146: --
3147: cursor c_eps(c_elig_pstn_prte_id number,c_mirror_src_entity_result_id number ,
3148: c_table_alias varchar2 ) is

Line 3150: from BEN_ELIG_PSTN_PRTE_F eps

3146: --
3147: cursor c_eps(c_elig_pstn_prte_id number,c_mirror_src_entity_result_id number ,
3148: c_table_alias varchar2 ) is
3149: select eps.*
3150: from BEN_ELIG_PSTN_PRTE_F eps
3151: where eps.elig_pstn_prte_id = c_elig_pstn_prte_id
3152: -- and eps.business_group_id = p_business_group_id
3153: and not exists (
3154: select /* */ null

Line 3161: -- and trt.where_clause = 'BEN_ELIG_PSTN_PRTE_F'

3157: where copy_entity_txn_id = p_copy_entity_txn_id
3158: -- and trt.table_route_id = cpe.table_route_id
3159: and ( -- c_mirror_src_entity_result_id is null or
3160: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3161: -- and trt.where_clause = 'BEN_ELIG_PSTN_PRTE_F'
3162: and cpe.table_alias = c_table_alias
3163: and information1 = c_elig_pstn_prte_id
3164: -- and information4 = eps.business_group_id
3165: and information2 = eps.effective_start_date

Line 3186: -- END OF BEN_ELIG_PSTN_PRTE_F ----------------------

3182: where position_id = c_position_id;
3183:
3184: l_position_start_date per_positions.date_effective%type;
3185: ---------------------------------------------------------------
3186: -- END OF BEN_ELIG_PSTN_PRTE_F ----------------------
3187: ---------------------------------------------------------------
3188: ---------------------------------------------------------------
3189: -- START OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------
3190: ---------------------------------------------------------------

Line 9896: -- START OF BEN_ELIG_PSTN_PRTE_F ----------------------

9892: ---------------------------------------------------------------
9893: -- END OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------
9894: ---------------------------------------------------------------
9895: ---------------------------------------------------------------
9896: -- START OF BEN_ELIG_PSTN_PRTE_F ----------------------
9897: ---------------------------------------------------------------
9898: --
9899: for l_parent_rec in c_eps_from_parent(l_ELIGY_PRFL_ID) loop
9900: --

Line 10041: -- END OF BEN_ELIG_PSTN_PRTE_F ----------------------

10037: end loop;
10038: --
10039: end loop;
10040: ---------------------------------------------------------------
10041: -- END OF BEN_ELIG_PSTN_PRTE_F ----------------------
10042: ---------------------------------------------------------------
10043: ---------------------------------------------------------------
10044: -- START OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------
10045: ---------------------------------------------------------------