APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_OIPL_F

Line 1763: from ben_oipl_f oipl

1759: abr.effective_start_date and abr.effective_end_date
1760: and (abr.pl_id = p_pl_id or
1761: abr.oipl_id in
1762: (select oipl.oipl_id
1763: from ben_oipl_f oipl
1764: where oipl.pl_id = p_pl_id
1765: and oipl.business_group_id = p_business_group_id
1766: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1767: oipl.effective_start_date and oipl.effective_end_date

Line 1784: from ben_oipl_f oipl

1780: abr1.effective_start_date and abr1.effective_end_date
1781: and (abr1.pl_id = p_pl_id or
1782: abr1.oipl_id in
1783: (select oipl.oipl_id
1784: from ben_oipl_f oipl
1785: where oipl.pl_id = p_pl_id
1786: and oipl.business_group_id = p_business_group_id
1787: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1788: oipl.effective_start_date and oipl.effective_end_date

Line 1812: from ben_oipl_f oipl

1808: abr1.effective_start_date and abr1.effective_end_date
1809: and (abr1.pl_id = p_pl_id or
1810: abr1.oipl_id in
1811: (select oipl.oipl_id
1812: from ben_oipl_f oipl
1813: where oipl.pl_id = p_pl_id
1814: and oipl.business_group_id = p_business_group_id
1815: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1816: oipl.effective_start_date and oipl.effective_end_date

Line 1844: from ben_oipl_f oipl

1840: abr1.effective_start_date and abr1.effective_end_date
1841: and (abr1.pl_id = p_pl_id or
1842: abr1.oipl_id in
1843: (select oipl.oipl_id
1844: from ben_oipl_f oipl
1845: where oipl.pl_id = p_pl_id
1846: and oipl.business_group_id = p_business_group_id
1847: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1848: oipl.effective_start_date and oipl.effective_end_date

Line 1871: from ben_oipl_f oipl

1867: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1868: opt.effective_start_date and opt.effective_end_date
1869: and opt.opt_id in
1870: (select oipl.opt_id
1871: from ben_oipl_f oipl
1872: where oipl.pl_id = p_pl_id
1873: and oipl.business_group_id = p_business_group_id
1874: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1875: oipl.effective_start_date and oipl.effective_end_date);

Line 1891: from ben_oipl_f oipl

1887: and pt.opt_typ_cd = 'CWB'
1888: and (ccm.pl_id = pl.pl_id or
1889: ccm.oipl_id in
1890: (select oipl.oipl_id
1891: from ben_oipl_f oipl
1892: where oipl.pl_id = pl.pl_id
1893: and oipl.business_group_id = p_business_group_id
1894: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1895: oipl.effective_start_date and oipl.effective_end_date

Line 1915: from ben_oipl_f oipl

1911:
1912: -- to find wheether there is any option
1913: cursor c10 is
1914: select 'x' found
1915: from ben_oipl_f oipl
1916: where oipl.pl_id = p_pl_id
1917: and oipl.business_group_id = p_business_group_id
1918: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1919: oipl.effective_start_date and oipl.effective_end_date ;

Line 5285: from ben_oipl_f oipl

5281: pl.effective_end_date;
5282:
5283: cursor c_pln_opt is
5284: select 'x'
5285: from ben_oipl_f oipl
5286: where oipl.pl_id = l_pl_id
5287: and p_effective_date between oipl.effective_start_date and
5288: oipl.effective_end_date;
5289:

Line 8770: l_oipl_rec ben_oipl_f%rowtype;

8766: l_package varchar2(80);
8767: l_comp_object_name varchar2(80);
8768: l_pgm_rec ben_pgm_f%rowtype;
8769: l_pl_rec ben_pl_f%rowtype;
8770: l_oipl_rec ben_oipl_f%rowtype;
8771: l_opt_rec ben_opt_f%rowtype;
8772: l_plip_rec ben_plip_f%rowtype;
8773: l_ptip_rec ben_ptip_f%rowtype;
8774: --

Line 10580: from ben_oiplip_f opp, ben_oipl_f cop

10576: --
10577: cursor c_get_oiplip_opt_id (cv_oipl_id number,
10578: cv_plip_id number) is
10579: select opp.oiplip_id, opt_id
10580: from ben_oiplip_f opp, ben_oipl_f cop
10581: where opp.oipl_id = cv_oipl_id
10582: and opp.plip_id = cv_plip_id
10583: and p_effective_date between opp.effective_start_date and opp.effective_end_date
10584: and cop.oipl_id = opp.oipl_id