APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_EE_STAT_PRTE_F

Line 1803: -- START OF BEN_ELIG_EE_STAT_PRTE_F ----------------------

1799: ---------------------------------------------------------------
1800: -- END OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------
1801: ---------------------------------------------------------------
1802: ---------------------------------------------------------------
1803: -- START OF BEN_ELIG_EE_STAT_PRTE_F ----------------------
1804: ---------------------------------------------------------------
1805: cursor c_ees_from_parent(c_ELIGY_PRFL_ID number) is
1806: select elig_ee_stat_prte_id
1807: from BEN_ELIG_EE_STAT_PRTE_F

Line 1807: from BEN_ELIG_EE_STAT_PRTE_F

1803: -- START OF BEN_ELIG_EE_STAT_PRTE_F ----------------------
1804: ---------------------------------------------------------------
1805: cursor c_ees_from_parent(c_ELIGY_PRFL_ID number) is
1806: select elig_ee_stat_prte_id
1807: from BEN_ELIG_EE_STAT_PRTE_F
1808: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1809: --
1810: cursor c_ees(c_elig_ee_stat_prte_id number,c_mirror_src_entity_result_id number ,
1811: c_table_alias varchar2 ) is

Line 1813: from BEN_ELIG_EE_STAT_PRTE_F ees

1809: --
1810: cursor c_ees(c_elig_ee_stat_prte_id number,c_mirror_src_entity_result_id number ,
1811: c_table_alias varchar2 ) is
1812: select ees.*
1813: from BEN_ELIG_EE_STAT_PRTE_F ees
1814: where ees.elig_ee_stat_prte_id = c_elig_ee_stat_prte_id
1815: -- and ees.business_group_id = p_business_group_id
1816: and not exists (
1817: select /* */ null

Line 1824: -- and trt.where_clause = 'BEN_ELIG_EE_STAT_PRTE_F'

1820: where copy_entity_txn_id = p_copy_entity_txn_id
1821: -- and trt.table_route_id = cpe.table_route_id
1822: and ( -- c_mirror_src_entity_result_id is null or
1823: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1824: -- and trt.where_clause = 'BEN_ELIG_EE_STAT_PRTE_F'
1825: and cpe.table_alias = c_table_alias
1826: and information1 = c_elig_ee_stat_prte_id
1827: -- and information4 = ees.business_group_id
1828: and information2 = ees.effective_start_date

Line 1857: -- END OF BEN_ELIG_EE_STAT_PRTE_F ----------------------

1853: and stl.assignment_status_type_id = s.assignment_status_type_id
1854: and stl.language = userenv('LANG');
1855: --
1856: ---------------------------------------------------------------
1857: -- END OF BEN_ELIG_EE_STAT_PRTE_F ----------------------
1858: ---------------------------------------------------------------
1859: ---------------------------------------------------------------
1860: -- START OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------
1861: ---------------------------------------------------------------

Line 5858: -- START OF BEN_ELIG_EE_STAT_PRTE_F ----------------------

5854: ---------------------------------------------------------------
5855: -- END OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------
5856: ---------------------------------------------------------------
5857: ---------------------------------------------------------------
5858: -- START OF BEN_ELIG_EE_STAT_PRTE_F ----------------------
5859: ---------------------------------------------------------------
5860: --
5861: for l_parent_rec in c_ees_from_parent(l_ELIGY_PRFL_ID) loop
5862: --

Line 5990: -- END OF BEN_ELIG_EE_STAT_PRTE_F ----------------------

5986: end loop;
5987: --
5988: end loop;
5989: ---------------------------------------------------------------
5990: -- END OF BEN_ELIG_EE_STAT_PRTE_F ----------------------
5991: ---------------------------------------------------------------
5992: ---------------------------------------------------------------
5993: -- START OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------
5994: ---------------------------------------------------------------