APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_PRBTN_PERD_PRTE_F

Line 3189: -- START OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------

3185: ---------------------------------------------------------------
3186: -- END OF BEN_ELIG_PSTN_PRTE_F ----------------------
3187: ---------------------------------------------------------------
3188: ---------------------------------------------------------------
3189: -- START OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------
3190: ---------------------------------------------------------------
3191: cursor c_epn_from_parent(c_ELIGY_PRFL_ID number) is
3192: select elig_prbtn_perd_prte_id
3193: from BEN_ELIG_PRBTN_PERD_PRTE_F

Line 3193: from BEN_ELIG_PRBTN_PERD_PRTE_F

3189: -- START OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------
3190: ---------------------------------------------------------------
3191: cursor c_epn_from_parent(c_ELIGY_PRFL_ID number) is
3192: select elig_prbtn_perd_prte_id
3193: from BEN_ELIG_PRBTN_PERD_PRTE_F
3194: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3195: --
3196: cursor c_epn(c_elig_prbtn_perd_prte_id number,c_mirror_src_entity_result_id number ,
3197: c_table_alias varchar2 ) is

Line 3199: from BEN_ELIG_PRBTN_PERD_PRTE_F epn

3195: --
3196: cursor c_epn(c_elig_prbtn_perd_prte_id number,c_mirror_src_entity_result_id number ,
3197: c_table_alias varchar2 ) is
3198: select epn.*
3199: from BEN_ELIG_PRBTN_PERD_PRTE_F epn
3200: where epn.elig_prbtn_perd_prte_id = c_elig_prbtn_perd_prte_id
3201: -- and epn.business_group_id = p_business_group_id
3202: and not exists (
3203: select /* */ null

Line 3210: -- and trt.where_clause = 'BEN_ELIG_PRBTN_PERD_PRTE_F'

3206: where copy_entity_txn_id = p_copy_entity_txn_id
3207: -- and trt.table_route_id = cpe.table_route_id
3208: and ( -- c_mirror_src_entity_result_id is null or
3209: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3210: -- and trt.where_clause = 'BEN_ELIG_PRBTN_PERD_PRTE_F'
3211: and cpe.table_alias = c_table_alias
3212: and information1 = c_elig_prbtn_perd_prte_id
3213: -- and information4 = epn.business_group_id
3214: and information2 = epn.effective_start_date

Line 3220: -- END OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------

3216: );
3217: l_elig_prbtn_perd_prte_id number(15);
3218: l_out_epn_result_id number(15);
3219: ---------------------------------------------------------------
3220: -- END OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------
3221: ---------------------------------------------------------------
3222: ---------------------------------------------------------------
3223: -- START OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------
3224: ---------------------------------------------------------------

Line 10044: -- START OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------

10040: ---------------------------------------------------------------
10041: -- END OF BEN_ELIG_PSTN_PRTE_F ----------------------
10042: ---------------------------------------------------------------
10043: ---------------------------------------------------------------
10044: -- START OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------
10045: ---------------------------------------------------------------
10046: --
10047: for l_parent_rec in c_epn_from_parent(l_ELIGY_PRFL_ID) loop
10048: --

Line 10152: -- END OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------

10148: end loop;
10149: --
10150: end loop;
10151: ---------------------------------------------------------------
10152: -- END OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------
10153: ---------------------------------------------------------------
10154: ---------------------------------------------------------------
10155: -- START OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------
10156: ---------------------------------------------------------------