APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_LBR_MMBR_PRTE_F

Line 2247: -- START OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------

2243: ---------------------------------------------------------------
2244: -- END OF BEN_ELIG_JOB_PRTE_F ----------------------
2245: ---------------------------------------------------------------
2246: ---------------------------------------------------------------
2247: -- START OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------
2248: ---------------------------------------------------------------
2249: cursor c_elu_from_parent(c_ELIGY_PRFL_ID number) is
2250: select elig_lbr_mmbr_prte_id
2251: from BEN_ELIG_LBR_MMBR_PRTE_F

Line 2251: from BEN_ELIG_LBR_MMBR_PRTE_F

2247: -- START OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------
2248: ---------------------------------------------------------------
2249: cursor c_elu_from_parent(c_ELIGY_PRFL_ID number) is
2250: select elig_lbr_mmbr_prte_id
2251: from BEN_ELIG_LBR_MMBR_PRTE_F
2252: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2253: --
2254: cursor c_elu(c_elig_lbr_mmbr_prte_id number,c_mirror_src_entity_result_id number ,
2255: c_table_alias varchar2 ) is

Line 2257: from BEN_ELIG_LBR_MMBR_PRTE_F elu

2253: --
2254: cursor c_elu(c_elig_lbr_mmbr_prte_id number,c_mirror_src_entity_result_id number ,
2255: c_table_alias varchar2 ) is
2256: select elu.*
2257: from BEN_ELIG_LBR_MMBR_PRTE_F elu
2258: where elu.elig_lbr_mmbr_prte_id = c_elig_lbr_mmbr_prte_id
2259: -- and elu.business_group_id = p_business_group_id
2260: and not exists (
2261: select /* */ null

Line 2268: -- and trt.where_clause = 'BEN_ELIG_LBR_MMBR_PRTE_F'

2264: where copy_entity_txn_id = p_copy_entity_txn_id
2265: -- and trt.table_route_id = cpe.table_route_id
2266: and ( -- c_mirror_src_entity_result_id is null or
2267: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2268: -- and trt.where_clause = 'BEN_ELIG_LBR_MMBR_PRTE_F'
2269: and cpe.table_alias = c_table_alias
2270: and information1 = c_elig_lbr_mmbr_prte_id
2271: -- and information4 = elu.business_group_id
2272: and information2 = elu.effective_start_date

Line 2278: -- END OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------

2274: );
2275: l_elig_lbr_mmbr_prte_id number(15);
2276: l_out_elu_result_id number(15);
2277: ---------------------------------------------------------------
2278: -- END OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------
2279: ---------------------------------------------------------------
2280: ---------------------------------------------------------------
2281: -- START OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------
2282: ---------------------------------------------------------------

Line 7175: -- START OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------

7171: ---------------------------------------------------------------
7172: -- END OF BEN_ELIG_JOB_PRTE_F ----------------------
7173: ---------------------------------------------------------------
7174: ---------------------------------------------------------------
7175: -- START OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------
7176: ---------------------------------------------------------------
7177: --
7178: for l_parent_rec in c_elu_from_parent(l_ELIGY_PRFL_ID) loop
7179: --

Line 7278: -- END OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------

7274: end loop;
7275: --
7276: end loop;
7277: ---------------------------------------------------------------
7278: -- END OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------
7279: ---------------------------------------------------------------
7280: ---------------------------------------------------------------
7281: -- START OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------
7282: ---------------------------------------------------------------