eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EVALUATE_PTNL_LF_EVT dependencies on BEN_LER_F

Line 78: ben_ler_f ler

74: pfl.trgr_table_pk_id, -- it is absence_attendance_id
75: ler.lf_evt_oper_cd, -- 9999 lf_evt_oper_cd,
76: ler.typ_cd
77: from ben_ptnl_ler_for_per pfl,
78: ben_ler_f ler
79: where pfl.ptnl_ler_for_per_stat_cd not in ('VOIDD','PROCD')
80: and pfl.person_id = p_person_id
81: and pfl.ler_id = ler.ler_id
82: and p_effective_date

Line 109: ben_ler_f ler

105: --
106: cursor c_get_min_ptnl is
107: select min(ptn.lf_evt_ocrd_dt)
108: from ben_ptnl_ler_for_per ptn,
109: ben_ler_f ler
110: where ptn.person_id = p_person_id
111: and ptn.ler_id = ler.ler_id
112: and p_effective_date
113: between ler.effective_start_date

Line 124: ben_ler_f ler

120: --
121: cursor c_get_ptnl_for_aba is
122: select ptn.ptnl_ler_for_per_id
123: from ben_ptnl_ler_for_per ptn,
124: ben_ler_f ler
125: where ptn.person_id = p_person_id
126: and ptn.business_group_id = p_business_group_id
127: and ptn.ptnl_ler_for_per_stat_cd not in ('PROCD','VOIDD')
128: and p_effective_date

Line 147: ben_ler_f ler

143: --
144: cursor c_winning_ptnl_of_same_type is
145: select ler.lf_evt_oper_cd,ptn.*
146: from ben_ptnl_ler_for_per ptn,
147: ben_ler_f ler
148: where ptn.person_id = p_person_id
149: and ptn.ptnl_ler_for_per_stat_cd <> 'VOIDD' -- 9999(it should work) not in ('PROCD','VOIDD')
150: and ptn.trgr_table_pk_id = l_potent.trgr_table_pk_id
151: -- not needed 9999 delete it and ptn.ptnl_ler_for_per_id <> l_potent.ptnl_ler_for_per_id

Line 199: ben_ler_f ler

195: --
196: cursor c_pils_to_backout(p_min_lf_evt_ocrd_dt date, p_ler_id number ) is
197: select pil.*
198: from ben_per_in_ler pil,
199: ben_ler_f ler
200: where pil.business_group_id = p_business_group_id
201: and pil.person_id = p_person_id
202: and pil.lf_evt_ocrd_dt >= p_min_lf_evt_ocrd_dt
203: and pil.ler_id <> ben_manage_life_events.g_ler_id -- 9999 what is this?

Line 679: ben_ler_f ler

675: pil.bckt_dt,
676: pil.clsd_dt,
677: pil.ntfn_dt
678: from ben_per_in_ler pil,
679: ben_ler_f ler
680: where pil.person_id = p_person_id
681: and pil.per_in_ler_stat_cd in ('STRTD','PROCD')
682: and pil.lf_evt_ocrd_dt >= cv_lf_evt_ocrd_dt
683: and pil.ler_id = ler.ler_id

Line 704: ben_ler_f ler

700: pil.bckt_dt,
701: pil.clsd_dt,
702: pil.ntfn_dt
703: from ben_per_in_ler pil,
704: ben_ler_f ler
705: where pil.person_id = p_person_id
706: and pil.per_in_ler_stat_cd in ('STRTD')
707: and pil.lf_evt_ocrd_dt < cv_lf_evt_ocrd_dt
708: and pil.ler_id = ler.ler_id

Line 970: ben_ler_f ler

966: ler.name,
967: pfl.person_id,
968: pfl.business_group_id
969: from ben_ptnl_ler_for_per pfl,
970: ben_ler_f ler
971: where pfl.ptnl_ler_for_per_stat_cd not in ('VOIDD','PROCD')
972: and pfl.person_id = p_person_id
973: and pfl.ler_id = ler.ler_id
974: and p_effective_date

Line 987: from ben_per_in_ler pil, ben_ler_f ler

983: -- Before we process GSP Rate Sync, ensure that one GSP Progression has been processed
984: -- for the person in the past
985: cursor c_gsp_prog_procd_exists is
986: select null
987: from ben_per_in_ler pil, ben_ler_f ler
988: where pil.person_id = p_person_id
989: and pil.ler_id = ler.ler_id
990: and p_effective_date between ler.effective_start_date and ler.effective_end_date
991: and ler.typ_cd = 'GSP';

Line 996: ben_ler_f ler

992: --
993: cursor get_gs_proc_strt_le(p_lf_evt_ocrd_dt date) is
994: select pil.*
995: from ben_per_in_ler pil,
996: ben_ler_f ler
997: where pil.person_id = p_person_id
998: and (pil.per_in_ler_stat_cd = 'STRTD'
999: or
1000: (pil.per_in_ler_stat_cd = 'PROCD'

Line 1299: ben_ler_f ler

1295: pfl.dtctd_dt,
1296: pfl.voidd_dt,
1297: ler.name
1298: from ben_ptnl_ler_for_per pfl,
1299: ben_ler_f ler
1300: where pfl.ptnl_ler_for_per_stat_cd not in ('VOIDD','PROCD')
1301: and pfl.person_id = p_person_id
1302: and pfl.ler_id = ler.ler_id
1303: and p_effective_date

Line 1327: ben_ler_f ler

1323: --
1324: cursor get_all_per_in_ler(p_lf_evt_ocrd_dt date, p_curr_per_in_ler_id number) is
1325: select pil.*
1326: from ben_per_in_ler pil,
1327: ben_ler_f ler
1328: where pil.person_id = p_person_id
1329: and pil.per_in_ler_stat_cd in ('STRTD','PROCD')
1330: and pil.lf_evt_ocrd_dt >= p_lf_evt_ocrd_dt
1331: and pil.per_in_ler_id <> p_curr_per_in_ler_id

Line 1367: ben_ler_f ler

1363: pil.bckt_dt,
1364: pil.clsd_dt,
1365: pil.ntfn_dt
1366: from ben_per_in_ler pil,
1367: ben_ler_f ler
1368: where pil.person_id = p_person_id
1369: and pil.per_in_ler_stat_cd = 'STRTD'
1370: and pil.ler_id <> ben_manage_life_events.g_ler_id
1371: and pil.ler_id = ler.ler_id

Line 1391: ben_ler_f ler

1387: pil.bckt_dt,
1388: pil.clsd_dt,
1389: pil.ntfn_dt
1390: from ben_per_in_ler pil,
1391: ben_ler_f ler
1392: where pil.person_id = p_person_id
1393: and pil.per_in_ler_stat_cd = 'PROCD'
1394: and pil.lf_evt_ocrd_dt >= cv_lf_evt_ocrd_dt
1395: and pil.ler_id <> ben_manage_life_events.g_ler_id

Line 1410: -- CWB Changes : Cursor joined to ben_ler_f

1406: --
1407: -- Bug 3179 : pbodla
1408: --
1409: --
1410: -- CWB Changes : Cursor joined to ben_ler_f
1411: --
1412: cursor c_check_deadlock_pil(cv_lf_evt_ocrd_dt in date) is
1413: select pil.per_in_ler_id,
1414: pil.per_in_ler_stat_cd,

Line 1427: ben_ler_f ler

1423: pil.bckt_dt,
1424: pil.clsd_dt,
1425: pil.ntfn_dt
1426: from ben_per_in_ler pil,
1427: ben_ler_f ler
1428: where pil.person_id = p_person_id
1429: and pil.per_in_ler_stat_cd in ( 'PROCD', 'STRTD')
1430: and pil.ler_id <> ben_manage_life_events.g_ler_id
1431: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt

Line 1444: l_ovridg_le_flag BEN_LER_F.OVRIDG_LE_FLAG%TYPE;

1440: --
1441: l_deadlock_per_in_ler get_current_per_in_ler%rowtype;
1442: l_current_per_in_ler get_current_per_in_ler%rowtype;
1443: l_curr_per_in_ler_id number;
1444: l_ovridg_le_flag BEN_LER_F.OVRIDG_LE_FLAG%TYPE;
1445: l_ptnl_ler_for_per_id BEN_PTNL_LER_FOR_PER.PTNL_LER_FOR_PER_ID%TYPE;
1446: l_lf_evt_ocrd_dt BEN_PTNL_LER_FOR_PER.LF_EVT_OCRD_DT%TYPE;
1447: l_creation_date BEN_PTNL_LER_FOR_PER.CREATION_DATE%TYPE;
1448: l_ntfn_dt BEN_PTNL_LER_FOR_PER.NTFN_DT%TYPE;

Line 1449: l_win_ler_id BEN_LER_F.LER_ID%TYPE;

1445: l_ptnl_ler_for_per_id BEN_PTNL_LER_FOR_PER.PTNL_LER_FOR_PER_ID%TYPE;
1446: l_lf_evt_ocrd_dt BEN_PTNL_LER_FOR_PER.LF_EVT_OCRD_DT%TYPE;
1447: l_creation_date BEN_PTNL_LER_FOR_PER.CREATION_DATE%TYPE;
1448: l_ntfn_dt BEN_PTNL_LER_FOR_PER.NTFN_DT%TYPE;
1449: l_win_ler_id BEN_LER_F.LER_ID%TYPE;
1450: l_norm_ler_id BEN_LER_F.LER_ID%TYPE;
1451: l_ler_id BEN_LER_F.LER_ID%TYPE;
1452: l_ler_typ_cd BEN_LER_F.TYP_CD%TYPE;
1453: l_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;

Line 1450: l_norm_ler_id BEN_LER_F.LER_ID%TYPE;

1446: l_lf_evt_ocrd_dt BEN_PTNL_LER_FOR_PER.LF_EVT_OCRD_DT%TYPE;
1447: l_creation_date BEN_PTNL_LER_FOR_PER.CREATION_DATE%TYPE;
1448: l_ntfn_dt BEN_PTNL_LER_FOR_PER.NTFN_DT%TYPE;
1449: l_win_ler_id BEN_LER_F.LER_ID%TYPE;
1450: l_norm_ler_id BEN_LER_F.LER_ID%TYPE;
1451: l_ler_id BEN_LER_F.LER_ID%TYPE;
1452: l_ler_typ_cd BEN_LER_F.TYP_CD%TYPE;
1453: l_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1454: l_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;

Line 1451: l_ler_id BEN_LER_F.LER_ID%TYPE;

1447: l_creation_date BEN_PTNL_LER_FOR_PER.CREATION_DATE%TYPE;
1448: l_ntfn_dt BEN_PTNL_LER_FOR_PER.NTFN_DT%TYPE;
1449: l_win_ler_id BEN_LER_F.LER_ID%TYPE;
1450: l_norm_ler_id BEN_LER_F.LER_ID%TYPE;
1451: l_ler_id BEN_LER_F.LER_ID%TYPE;
1452: l_ler_typ_cd BEN_LER_F.TYP_CD%TYPE;
1453: l_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1454: l_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1455: l_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;

Line 1452: l_ler_typ_cd BEN_LER_F.TYP_CD%TYPE;

1448: l_ntfn_dt BEN_PTNL_LER_FOR_PER.NTFN_DT%TYPE;
1449: l_win_ler_id BEN_LER_F.LER_ID%TYPE;
1450: l_norm_ler_id BEN_LER_F.LER_ID%TYPE;
1451: l_ler_id BEN_LER_F.LER_ID%TYPE;
1452: l_ler_typ_cd BEN_LER_F.TYP_CD%TYPE;
1453: l_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1454: l_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1455: l_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1456: l_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;

Line 1453: l_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;

1449: l_win_ler_id BEN_LER_F.LER_ID%TYPE;
1450: l_norm_ler_id BEN_LER_F.LER_ID%TYPE;
1451: l_ler_id BEN_LER_F.LER_ID%TYPE;
1452: l_ler_typ_cd BEN_LER_F.TYP_CD%TYPE;
1453: l_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1454: l_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1455: l_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1456: l_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1457: l_min_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;

Line 1454: l_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;

1450: l_norm_ler_id BEN_LER_F.LER_ID%TYPE;
1451: l_ler_id BEN_LER_F.LER_ID%TYPE;
1452: l_ler_typ_cd BEN_LER_F.TYP_CD%TYPE;
1453: l_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1454: l_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1455: l_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1456: l_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1457: l_min_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1458: l_min_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;

Line 1455: l_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;

1451: l_ler_id BEN_LER_F.LER_ID%TYPE;
1452: l_ler_typ_cd BEN_LER_F.TYP_CD%TYPE;
1453: l_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1454: l_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1455: l_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1456: l_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1457: l_min_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1458: l_min_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1459: l_min_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;

Line 1456: l_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;

1452: l_ler_typ_cd BEN_LER_F.TYP_CD%TYPE;
1453: l_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1454: l_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1455: l_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1456: l_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1457: l_min_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1458: l_min_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1459: l_min_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1460: l_min_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;

Line 1457: l_min_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;

1453: l_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1454: l_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1455: l_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1456: l_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1457: l_min_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1458: l_min_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1459: l_min_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1460: l_min_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1461: l_min_creation_date BEN_PTNL_LER_FOR_PER.creation_date%type;

Line 1458: l_min_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;

1454: l_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1455: l_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1456: l_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1457: l_min_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1458: l_min_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1459: l_min_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1460: l_min_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1461: l_min_creation_date BEN_PTNL_LER_FOR_PER.creation_date%type;
1462: l_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;

Line 1459: l_min_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;

1455: l_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1456: l_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1457: l_min_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1458: l_min_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1459: l_min_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1460: l_min_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1461: l_min_creation_date BEN_PTNL_LER_FOR_PER.creation_date%type;
1462: l_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;
1463: l_proc varchar2(72) := g_package||'eval_ptnl_per_for_ler';

Line 1460: l_min_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;

1456: l_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1457: l_min_tmlns_eval_cd BEN_LER_F.tmlns_eval_cd%type;
1458: l_min_tmlns_dys_num BEN_LER_F.tmlns_dys_num%type;
1459: l_min_tmlns_perd_cd BEN_LER_F.tmlns_perd_cd%type;
1460: l_min_tmlns_perd_rl BEN_LER_F.tmlns_perd_rl%type;
1461: l_min_creation_date BEN_PTNL_LER_FOR_PER.creation_date%type;
1462: l_object_version_number BEN_PTNL_LER_FOR_PER.OBJECT_VERSION_NUMBER%TYPE;
1463: l_proc varchar2(72) := g_package||'eval_ptnl_per_for_ler';
1464: l_created_ler varchar(2) := 'N';

Line 1508: from ben_ler_f ler

1504: --
1505: cursor c_winner_ler_typ_cd (cv_ler_id number)
1506: is
1507: select typ_cd, name
1508: from ben_ler_f ler
1509: where ler_id = cv_ler_id;
1510: --
1511: l_typ_cd VARCHAR2(30);
1512: l_use_mode VARCHAR2(30);

Line 1572: l_ler_rec ben_ler_f%rowtype;

1568: l_rslt_object_version_number NUMBER;
1569: l_proc varchar2(72) := g_package||'insert_per_in_ler';
1570: l_assignment_id number;
1571: l_perhasmultptus boolean;
1572: l_ler_rec ben_ler_f%rowtype;
1573: l_procd_dt date;
1574: l_strtd_dt date;
1575: l_voidd_dt date;
1576: l_effective_start_date date;

Line 1655: ben_ler_f ler

1651: ptn.ptnl_ler_for_per_id,
1652: ptn.ler_id,
1653: ptn.object_version_number
1654: from ben_ptnl_ler_for_per ptn,
1655: ben_ler_f ler
1656: where ler.ler_id = ptn.ler_id
1657: and ler.business_group_id = p_business_group_id
1658: and ptn.ptnl_ler_for_per_stat_cd not in ('PROCD','VOIDD', 'MNLO')
1659: and ptn.mnlo_dt is null -- to fix the bug 1579642

Line 1693: l_mnl_ler_name ben_ler_f.name%type;

1689: l_npv_ptnl_cnt number := 0;
1690: l_curr_voidd_ptnl_cnt number := 0;
1691: -- 6129827 Added these 2 variables
1692: l_mnl_ptnl_cnt number := 0;
1693: l_mnl_ler_name ben_ler_f.name%type;
1694: --
1695: begin
1696: --
1697: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 2276: -- CWB Changes : Cursor joined to ben_ler_f

2272: --
2273: l_proc varchar2(72) := g_package||'check_earliest_potential';
2274: --
2275: --
2276: -- CWB Changes : Cursor joined to ben_ler_f
2277: --
2278: cursor c1 is
2279: select min(ptn.lf_evt_ocrd_dt)
2280: from ben_ptnl_ler_for_per ptn,

Line 2281: ben_ler_f ler

2277: --
2278: cursor c1 is
2279: select min(ptn.lf_evt_ocrd_dt)
2280: from ben_ptnl_ler_for_per ptn,
2281: ben_ler_f ler
2282: where ptn.person_id = p_person_id
2283: and ptn.ler_id = ler.ler_id
2284: and p_effective_date
2285: between ler.effective_start_date

Line 2300: FROM ben_ler_f

2296: and ptn.ptnl_ler_for_per_stat_cd not in ('PROCD','VOIDD');
2297:
2298: cursor c_ler(p_ler_id number) is
2299: SELECT name
2300: FROM ben_ler_f
2301: WHERE business_group_id = p_business_group_id
2302: AND ler_id = p_ler_id
2303: AND p_effective_date
2304: BETWEEN effective_start_date

Line 2707: ben_ler_f ler

2703: select ler.ovridg_le_flag,
2704: ppl.ptnl_ler_for_per_id,
2705: ler.name
2706: from ben_ptnl_ler_for_per ppl,
2707: ben_ler_f ler
2708: where ppl.person_id = p_person_id
2709: and ppl.ler_id = ler.ler_id
2710: and ppl.business_group_id = p_business_group_id
2711: and ppl.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 2724: l_win_ler_name ben_ler_f.name%TYPE; -- UTF8 varchar2(150);

2720: between ler.effective_start_date
2721: and ler.effective_end_date;
2722: --
2723: l_ovridg_le_flag varchar2(30);
2724: l_win_ler_name ben_ler_f.name%TYPE; -- UTF8 varchar2(150);
2725: l_ler_name ben_ler_f.name%TYPE; -- UTF8 varchar2(150);
2726: l_ptnl_ler_for_per_id number(15);
2727: l_win_ptnl_ler_for_per_id number(15);
2728: l_search_ptnl_ler_for_per_id number(15);

Line 2725: l_ler_name ben_ler_f.name%TYPE; -- UTF8 varchar2(150);

2721: and ler.effective_end_date;
2722: --
2723: l_ovridg_le_flag varchar2(30);
2724: l_win_ler_name ben_ler_f.name%TYPE; -- UTF8 varchar2(150);
2725: l_ler_name ben_ler_f.name%TYPE; -- UTF8 varchar2(150);
2726: l_ptnl_ler_for_per_id number(15);
2727: l_win_ptnl_ler_for_per_id number(15);
2728: l_search_ptnl_ler_for_per_id number(15);
2729: l_c1 c1%rowtype;

Line 2743: -- CWB Changes : Cursor joined to ben_ler_f

2739: -- Then loop around the potentials and void the ones which are not
2740: -- processed.
2741: --
2742: --
2743: -- CWB Changes : Cursor joined to ben_ler_f
2744: --
2745: cursor c_ptnl is
2746: select ppl.object_version_number,
2747: ppl.ptnl_ler_for_per_id

Line 2749: ben_ler_f ler

2745: cursor c_ptnl is
2746: select ppl.object_version_number,
2747: ppl.ptnl_ler_for_per_id
2748: from ben_ptnl_ler_for_per ppl,
2749: ben_ler_f ler
2750: where ppl.person_id = p_person_id
2751: and ppl.business_group_id = p_business_group_id
2752: and ppl.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
2753: and ppl.ler_id <> ben_manage_life_events.g_ler_id

Line 2772: -- CWB Changes : Cursor joined to ben_ler_f

2768: -- Bug 1146792 (4285) : Modified check_and_get_winner -
2769: -- Back out the per in ler's before determining
2770: -- the winner.
2771: --
2772: -- CWB Changes : Cursor joined to ben_ler_f
2773: --
2774: cursor c_pils_to_backout is
2775: select pil.*
2776: from ben_per_in_ler pil,

Line 2777: ben_ler_f ler

2773: --
2774: cursor c_pils_to_backout is
2775: select pil.*
2776: from ben_per_in_ler pil,
2777: ben_ler_f ler
2778: where pil.business_group_id = p_business_group_id
2779: and pil.person_id = p_person_id
2780: and (pil.lf_evt_ocrd_dt > p_lf_evt_ocrd_dt -- 5727737/5677090: Need to backout all Future LEs
2781: or (pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 2998: -- CWB Changes : Cursor joined to ben_ler_f

2994: --
2995: l_proc varchar2(72) := g_package||'get_earliest_potential';
2996: --
2997: --
2998: -- CWB Changes : Cursor joined to ben_ler_f
2999: --
3000: cursor c1 is
3001: select min(ptn.lf_evt_ocrd_dt)
3002: from ben_ptnl_ler_for_per ptn,

Line 3003: ben_ler_f ler

2999: --
3000: cursor c1 is
3001: select min(ptn.lf_evt_ocrd_dt)
3002: from ben_ptnl_ler_for_per ptn,
3003: ben_ler_f ler
3004: where ptn.person_id = p_person_id
3005: and ptn.ler_id = ler.ler_id
3006: and p_effective_date
3007: between ler.effective_start_date

Line 3594: ben_ler_f ler

3590: pil.clsd_dt,
3591: pil.ntfn_dt,
3592: pil.ptnl_ler_for_per_id
3593: from ben_per_in_ler pil,
3594: ben_ler_f ler
3595: where pil.person_id = cv_person_id
3596: and pil.per_in_ler_stat_cd in ('STRTD','PROCD')
3597: and pil.assignment_id = cv_assignment_id
3598: and pil.ler_id = ler.ler_id