APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_MRTL_STS_PRTE_F

Line 3223: -- START OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------

3219: ---------------------------------------------------------------
3220: -- END OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------
3221: ---------------------------------------------------------------
3222: ---------------------------------------------------------------
3223: -- START OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------
3224: ---------------------------------------------------------------
3225: cursor c_emp_from_parent(c_ELIGY_PRFL_ID number) is
3226: select elig_mrtl_sts_prte_id
3227: from BEN_ELIG_MRTL_STS_PRTE_F

Line 3227: from BEN_ELIG_MRTL_STS_PRTE_F

3223: -- START OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------
3224: ---------------------------------------------------------------
3225: cursor c_emp_from_parent(c_ELIGY_PRFL_ID number) is
3226: select elig_mrtl_sts_prte_id
3227: from BEN_ELIG_MRTL_STS_PRTE_F
3228: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3229: --
3230: cursor c_emp(c_elig_mrtl_sts_prte_id number,c_mirror_src_entity_result_id number ,
3231: c_table_alias varchar2 ) is

Line 3233: from BEN_ELIG_MRTL_STS_PRTE_F emp

3229: --
3230: cursor c_emp(c_elig_mrtl_sts_prte_id number,c_mirror_src_entity_result_id number ,
3231: c_table_alias varchar2 ) is
3232: select emp.*
3233: from BEN_ELIG_MRTL_STS_PRTE_F emp
3234: where emp.elig_mrtl_sts_prte_id = c_elig_mrtl_sts_prte_id
3235: -- and emp.business_group_id = p_business_group_id
3236: and not exists (
3237: select /* */ null

Line 3244: -- and trt.where_clause = 'BEN_ELIG_MRTL_STS_PRTE_F'

3240: where copy_entity_txn_id = p_copy_entity_txn_id
3241: -- and trt.table_route_id = cpe.table_route_id
3242: and ( -- c_mirror_src_entity_result_id is null or
3243: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3244: -- and trt.where_clause = 'BEN_ELIG_MRTL_STS_PRTE_F'
3245: and cpe.table_alias = c_table_alias
3246: and information1 = c_elig_mrtl_sts_prte_id
3247: -- and information4 = emp.business_group_id
3248: and information2 = emp.effective_start_date

Line 3254: -- END OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------

3250: );
3251: l_elig_mrtl_sts_prte_id number(15);
3252: l_out_emp_result_id number(15);
3253: ---------------------------------------------------------------
3254: -- END OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------
3255: ---------------------------------------------------------------
3256: ---------------------------------------------------------------
3257: -- START OF BEN_ELIG_GNDR_PRTE_F ----------------------
3258: ---------------------------------------------------------------

Line 10155: -- START OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------

10151: ---------------------------------------------------------------
10152: -- END OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------
10153: ---------------------------------------------------------------
10154: ---------------------------------------------------------------
10155: -- START OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------
10156: ---------------------------------------------------------------
10157: --
10158: for l_parent_rec in c_emp_from_parent(l_ELIGY_PRFL_ID) loop
10159: --

Line 10259: -- END OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------

10255: end loop;
10256: --
10257: end loop;
10258: ---------------------------------------------------------------
10259: -- END OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------
10260: ---------------------------------------------------------------
10261: ---------------------------------------------------------------
10262: -- START OF BEN_ELIG_GNDR_PRTE_F ----------------------
10263: ---------------------------------------------------------------