APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_ENRLD_ANTHR_OIPL_F

Line 1860: -- START OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------

1856: ---------------------------------------------------------------
1857: -- END OF BEN_ELIG_EE_STAT_PRTE_F ----------------------
1858: ---------------------------------------------------------------
1859: ---------------------------------------------------------------
1860: -- START OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------
1861: ---------------------------------------------------------------
1862: cursor c_eei_from_parent(c_ELIGY_PRFL_ID number) is
1863: select elig_enrld_anthr_oipl_id
1864: from BEN_ELIG_ENRLD_ANTHR_OIPL_F

Line 1864: from BEN_ELIG_ENRLD_ANTHR_OIPL_F

1860: -- START OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------
1861: ---------------------------------------------------------------
1862: cursor c_eei_from_parent(c_ELIGY_PRFL_ID number) is
1863: select elig_enrld_anthr_oipl_id
1864: from BEN_ELIG_ENRLD_ANTHR_OIPL_F
1865: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1866: --
1867: cursor c_eei(c_elig_enrld_anthr_oipl_id number,c_mirror_src_entity_result_id number ,
1868: c_table_alias varchar2 ) is

Line 1870: from BEN_ELIG_ENRLD_ANTHR_OIPL_F eei

1866: --
1867: cursor c_eei(c_elig_enrld_anthr_oipl_id number,c_mirror_src_entity_result_id number ,
1868: c_table_alias varchar2 ) is
1869: select eei.*
1870: from BEN_ELIG_ENRLD_ANTHR_OIPL_F eei
1871: where eei.elig_enrld_anthr_oipl_id = c_elig_enrld_anthr_oipl_id
1872: -- and eei.business_group_id = p_business_group_id
1873: and not exists (
1874: select /* */ null

Line 1881: -- and trt.where_clause = 'BEN_ELIG_ENRLD_ANTHR_OIPL_F'

1877: where copy_entity_txn_id = p_copy_entity_txn_id
1878: -- and trt.table_route_id = cpe.table_route_id
1879: and ( -- c_mirror_src_entity_result_id is null or
1880: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1881: -- and trt.where_clause = 'BEN_ELIG_ENRLD_ANTHR_OIPL_F'
1882: and cpe.table_alias = c_table_alias
1883: and information1 = c_elig_enrld_anthr_oipl_id
1884: -- and information4 = eei.business_group_id
1885: and information2 = eei.effective_start_date

Line 1891: -- END OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------

1887: );
1888: l_elig_enrld_anthr_oipl_id number(15);
1889: l_out_eei_result_id number(15);
1890: ---------------------------------------------------------------
1891: -- END OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------
1892: ---------------------------------------------------------------
1893: ---------------------------------------------------------------
1894: -- START OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------
1895: ---------------------------------------------------------------

Line 5993: -- START OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------

5989: ---------------------------------------------------------------
5990: -- END OF BEN_ELIG_EE_STAT_PRTE_F ----------------------
5991: ---------------------------------------------------------------
5992: ---------------------------------------------------------------
5993: -- START OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------
5994: ---------------------------------------------------------------
5995: --
5996: for l_parent_rec in c_eei_from_parent(l_ELIGY_PRFL_ID) loop
5997: --

Line 6100: -- END OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------

6096: end loop;
6097: --
6098: end loop;
6099: ---------------------------------------------------------------
6100: -- END OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------
6101: ---------------------------------------------------------------
6102: ---------------------------------------------------------------
6103: -- START OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------
6104: ---------------------------------------------------------------