APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_DSBLD_STAT_PRTE_F

Line 1769: -- START OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------

1765: ---------------------------------------------------------------
1766: -- END OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------
1767: ---------------------------------------------------------------
1768: ---------------------------------------------------------------
1769: -- START OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------
1770: ---------------------------------------------------------------
1771: cursor c_eds_from_parent(c_ELIGY_PRFL_ID number) is
1772: select elig_dsbld_stat_prte_id
1773: from BEN_ELIG_DSBLD_STAT_PRTE_F

Line 1773: from BEN_ELIG_DSBLD_STAT_PRTE_F

1769: -- START OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------
1770: ---------------------------------------------------------------
1771: cursor c_eds_from_parent(c_ELIGY_PRFL_ID number) is
1772: select elig_dsbld_stat_prte_id
1773: from BEN_ELIG_DSBLD_STAT_PRTE_F
1774: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1775: --
1776: cursor c_eds(c_elig_dsbld_stat_prte_id number,c_mirror_src_entity_result_id number ,
1777: c_table_alias varchar2 ) is

Line 1779: from BEN_ELIG_DSBLD_STAT_PRTE_F eds

1775: --
1776: cursor c_eds(c_elig_dsbld_stat_prte_id number,c_mirror_src_entity_result_id number ,
1777: c_table_alias varchar2 ) is
1778: select eds.*
1779: from BEN_ELIG_DSBLD_STAT_PRTE_F eds
1780: where eds.elig_dsbld_stat_prte_id = c_elig_dsbld_stat_prte_id
1781: -- and eds.business_group_id = p_business_group_id
1782: and not exists (
1783: select /* */ null

Line 1790: -- and trt.where_clause = 'BEN_ELIG_DSBLD_STAT_PRTE_F'

1786: where copy_entity_txn_id = p_copy_entity_txn_id
1787: -- and trt.table_route_id = cpe.table_route_id
1788: and ( -- c_mirror_src_entity_result_id is null or
1789: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1790: -- and trt.where_clause = 'BEN_ELIG_DSBLD_STAT_PRTE_F'
1791: and cpe.table_alias = c_table_alias
1792: and information1 = c_elig_dsbld_stat_prte_id
1793: -- and information4 = eds.business_group_id
1794: and information2 = eds.effective_start_date

Line 1800: -- END OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------

1796: );
1797: l_elig_dsbld_stat_prte_id number(15);
1798: l_out_eds_result_id number(15);
1799: ---------------------------------------------------------------
1800: -- END OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------
1801: ---------------------------------------------------------------
1802: ---------------------------------------------------------------
1803: -- START OF BEN_ELIG_EE_STAT_PRTE_F ----------------------
1804: ---------------------------------------------------------------

Line 5754: -- START OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------

5750: ---------------------------------------------------------------
5751: -- END OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------
5752: ---------------------------------------------------------------
5753: ---------------------------------------------------------------
5754: -- START OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------
5755: ---------------------------------------------------------------
5756: --
5757: for l_parent_rec in c_eds_from_parent(l_ELIGY_PRFL_ID) loop
5758: --

Line 5855: -- END OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------

5851: end loop;
5852: --
5853: end loop;
5854: ---------------------------------------------------------------
5855: -- END OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------
5856: ---------------------------------------------------------------
5857: ---------------------------------------------------------------
5858: -- START OF BEN_ELIG_EE_STAT_PRTE_F ----------------------
5859: ---------------------------------------------------------------