APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_FL_TM_PT_TM_PRTE_F

Line 2030: -- START OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------

2026: ---------------------------------------------------------------
2027: -- END OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------
2028: ---------------------------------------------------------------
2029: ---------------------------------------------------------------
2030: -- START OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------
2031: ---------------------------------------------------------------
2032: cursor c_efp_from_parent(c_ELIGY_PRFL_ID number) is
2033: select elig_fl_tm_pt_tm_prte_id
2034: from BEN_ELIG_FL_TM_PT_TM_PRTE_F

Line 2034: from BEN_ELIG_FL_TM_PT_TM_PRTE_F

2030: -- START OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------
2031: ---------------------------------------------------------------
2032: cursor c_efp_from_parent(c_ELIGY_PRFL_ID number) is
2033: select elig_fl_tm_pt_tm_prte_id
2034: from BEN_ELIG_FL_TM_PT_TM_PRTE_F
2035: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2036: --
2037: cursor c_efp(c_elig_fl_tm_pt_tm_prte_id number,c_mirror_src_entity_result_id number ,
2038: c_table_alias varchar2 ) is

Line 2040: from BEN_ELIG_FL_TM_PT_TM_PRTE_F efp

2036: --
2037: cursor c_efp(c_elig_fl_tm_pt_tm_prte_id number,c_mirror_src_entity_result_id number ,
2038: c_table_alias varchar2 ) is
2039: select efp.*
2040: from BEN_ELIG_FL_TM_PT_TM_PRTE_F efp
2041: where efp.elig_fl_tm_pt_tm_prte_id = c_elig_fl_tm_pt_tm_prte_id
2042: -- and efp.business_group_id = p_business_group_id
2043: and not exists (
2044: select /* */ null

Line 2051: -- and trt.where_clause = 'BEN_ELIG_FL_TM_PT_TM_PRTE_F'

2047: where copy_entity_txn_id = p_copy_entity_txn_id
2048: -- and trt.table_route_id = cpe.table_route_id
2049: and ( -- c_mirror_src_entity_result_id is null or
2050: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2051: -- and trt.where_clause = 'BEN_ELIG_FL_TM_PT_TM_PRTE_F'
2052: and cpe.table_alias = c_table_alias
2053: and information1 = c_elig_fl_tm_pt_tm_prte_id
2054: -- and information4 = efp.business_group_id
2055: and information2 = efp.effective_start_date

Line 2061: -- END OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------

2057: );
2058: l_elig_fl_tm_pt_tm_prte_id number(15);
2059: l_out_efp_result_id number(15);
2060: ---------------------------------------------------------------
2061: -- END OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------
2062: ---------------------------------------------------------------
2063: ---------------------------------------------------------------
2064: -- START OF BEN_ELIG_GRD_PRTE_F ----------------------
2065: ---------------------------------------------------------------

Line 6546: -- START OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------

6542: ---------------------------------------------------------------
6543: -- END OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------
6544: ---------------------------------------------------------------
6545: ---------------------------------------------------------------
6546: -- START OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------
6547: ---------------------------------------------------------------
6548: --
6549: for l_parent_rec in c_efp_from_parent(l_ELIGY_PRFL_ID) loop
6550: --

Line 6649: -- END OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------

6645: end loop;
6646: --
6647: end loop;
6648: ---------------------------------------------------------------
6649: -- END OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------
6650: ---------------------------------------------------------------
6651: ---------------------------------------------------------------
6652: -- START OF BEN_ELIG_GRD_PRTE_F ----------------------
6653: ---------------------------------------------------------------