APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_LGL_ENTY_PRTE_F

Line 2281: -- START OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------

2277: ---------------------------------------------------------------
2278: -- END OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------
2279: ---------------------------------------------------------------
2280: ---------------------------------------------------------------
2281: -- START OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------
2282: ---------------------------------------------------------------
2283: cursor c_eln_from_parent(c_ELIGY_PRFL_ID number) is
2284: select elig_lgl_enty_prte_id
2285: from BEN_ELIG_LGL_ENTY_PRTE_F

Line 2285: from BEN_ELIG_LGL_ENTY_PRTE_F

2281: -- START OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------
2282: ---------------------------------------------------------------
2283: cursor c_eln_from_parent(c_ELIGY_PRFL_ID number) is
2284: select elig_lgl_enty_prte_id
2285: from BEN_ELIG_LGL_ENTY_PRTE_F
2286: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2287: --
2288: cursor c_eln(c_elig_lgl_enty_prte_id number,c_mirror_src_entity_result_id number ,
2289: c_table_alias varchar2 ) is

Line 2291: from BEN_ELIG_LGL_ENTY_PRTE_F eln

2287: --
2288: cursor c_eln(c_elig_lgl_enty_prte_id number,c_mirror_src_entity_result_id number ,
2289: c_table_alias varchar2 ) is
2290: select eln.*
2291: from BEN_ELIG_LGL_ENTY_PRTE_F eln
2292: where eln.elig_lgl_enty_prte_id = c_elig_lgl_enty_prte_id
2293: -- and eln.business_group_id = p_business_group_id
2294: and not exists (
2295: select /* */ null

Line 2302: -- and trt.where_clause = 'BEN_ELIG_LGL_ENTY_PRTE_F'

2298: where copy_entity_txn_id = p_copy_entity_txn_id
2299: -- and trt.table_route_id = cpe.table_route_id
2300: and ( -- c_mirror_src_entity_result_id is null or
2301: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2302: -- and trt.where_clause = 'BEN_ELIG_LGL_ENTY_PRTE_F'
2303: and cpe.table_alias = c_table_alias
2304: and information1 = c_elig_lgl_enty_prte_id
2305: -- and information4 = eln.business_group_id
2306: and information2 = eln.effective_start_date

Line 2333: -- END OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------

2329: where organization_id = c_organization_id;
2330:
2331: l_organization_start_date hr_all_organization_units.date_from%type;
2332: ---------------------------------------------------------------
2333: -- END OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------
2334: ---------------------------------------------------------------
2335: ---------------------------------------------------------------
2336: -- START OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------
2337: ---------------------------------------------------------------

Line 7281: -- START OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------

7277: ---------------------------------------------------------------
7278: -- END OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------
7279: ---------------------------------------------------------------
7280: ---------------------------------------------------------------
7281: -- START OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------
7282: ---------------------------------------------------------------
7283: --
7284: for l_parent_rec in c_eln_from_parent(l_ELIGY_PRFL_ID) loop
7285: --

Line 7426: -- END OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------

7422: end loop;
7423: --
7424: end loop;
7425: ---------------------------------------------------------------
7426: -- END OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------
7427: ---------------------------------------------------------------
7428: ---------------------------------------------------------------
7429: -- START OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------
7430: ---------------------------------------------------------------