APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_LOA_RSN_PRTE_F

Line 2336: -- START OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------

2332: ---------------------------------------------------------------
2333: -- END OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------
2334: ---------------------------------------------------------------
2335: ---------------------------------------------------------------
2336: -- START OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------
2337: ---------------------------------------------------------------
2338: cursor c_elr_from_parent(c_ELIGY_PRFL_ID number) is
2339: select elig_loa_rsn_prte_id
2340: from BEN_ELIG_LOA_RSN_PRTE_F

Line 2340: from BEN_ELIG_LOA_RSN_PRTE_F

2336: -- START OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------
2337: ---------------------------------------------------------------
2338: cursor c_elr_from_parent(c_ELIGY_PRFL_ID number) is
2339: select elig_loa_rsn_prte_id
2340: from BEN_ELIG_LOA_RSN_PRTE_F
2341: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2342: --
2343: cursor c_elr(c_elig_loa_rsn_prte_id number,c_mirror_src_entity_result_id number ,
2344: c_table_alias varchar2 ) is

Line 2346: from BEN_ELIG_LOA_RSN_PRTE_F elr

2342: --
2343: cursor c_elr(c_elig_loa_rsn_prte_id number,c_mirror_src_entity_result_id number ,
2344: c_table_alias varchar2 ) is
2345: select elr.*
2346: from BEN_ELIG_LOA_RSN_PRTE_F elr
2347: where elr.elig_loa_rsn_prte_id = c_elig_loa_rsn_prte_id
2348: -- and elr.business_group_id = p_business_group_id
2349: and not exists (
2350: select /* */ null

Line 2357: -- and trt.where_clause = 'BEN_ELIG_LOA_RSN_PRTE_F'

2353: where copy_entity_txn_id = p_copy_entity_txn_id
2354: -- and trt.table_route_id = cpe.table_route_id
2355: and ( -- c_mirror_src_entity_result_id is null or
2356: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2357: -- and trt.where_clause = 'BEN_ELIG_LOA_RSN_PRTE_F'
2358: and cpe.table_alias = c_table_alias
2359: and information1 = c_elig_loa_rsn_prte_id
2360: -- and information4 = elr.business_group_id
2361: and information2 = elr.effective_start_date

Line 2404: -- END OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------

2400: --l_mapping_column_name1 pqh_attributes.attribute_name%type;
2401: --l_mapping_column_name2 pqh_attributes.attribute_name%type;
2402: l_information175 varchar2(600);
2403: ---------------------------------------------------------------
2404: -- END OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------
2405: ---------------------------------------------------------------
2406: ---------------------------------------------------------------
2407: -- START OF BEN_ELIG_LOS_PRTE_F ----------------------
2408: ---------------------------------------------------------------

Line 7599: -- START OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------

7595: ---------------------------------------------------------------
7596: -- END OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------
7597: ---------------------------------------------------------------
7598: ---------------------------------------------------------------
7599: -- START OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------
7600: ---------------------------------------------------------------
7601: --
7602: for l_parent_rec in c_elr_from_parent(l_ELIGY_PRFL_ID) loop
7603: --

Line 7758: -- END OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------

7754: end loop;
7755: --
7756: end loop;
7757: ---------------------------------------------------------------
7758: -- END OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------
7759: ---------------------------------------------------------------
7760: ---------------------------------------------------------------
7761: -- START OF BEN_ELIG_LOS_PRTE_F ----------------------
7762: ---------------------------------------------------------------