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_MANAGE_CWB_LIFE_EVENTS dependencies on BEN_PER_IN_LER

Line 206: ben_per_in_ler.

202: 01-dec-06 ssarkar 115.77 5124534 : modified popu_missing_person_pil
203: 13-dec-06 ssarkar 115.78 5124534/5702794 : populate cwb_group_persons with pl_id/oipl_id
204: 20-Feb-07 maagrawa 115.79 Further tuned c_no_0_hrchy. Use
205: ben_cwb_person_info instead of
206: ben_per_in_ler.
207: 04-Jun-07 maagrawa 115.80 Further tuned c_no_0_hrchy. Check only
208: level 1 hierarchy.
209: 24-Sep-08 sgnanama 115.81 7393142: process for terminated employee
210: 19-Feb-09 sgnanama 120.31.12010000.3 ER: added logic to copy integrator

Line 888: ben_per_in_ler pil

884: pil.ws_mgr_id,
885: pil.person_id
886: from
887: ben_cwb_group_hrchy cwb,
888: ben_per_in_ler pil
889: where
890: cwb.mgr_per_in_ler_id = -1
891: and pil.per_in_ler_id = cwb.emp_per_in_ler_id
892: and pil.per_in_ler_stat_cd = 'STRTD'

Line 922: from ben_per_in_ler pil

918: p_ler_id number,
919: p_business_group_id number) is
920: select pil.ws_mgr_id,
921: pil.per_in_ler_id
922: from ben_per_in_ler pil
923: where pil.group_pl_id = p_pl_id
924: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
925: and pil.ler_id = p_ler_id
926: and pil.person_id = p_person_id

Line 996: from ben_per_in_ler pil

992: -- Bug 2541072 : Do not consider all per in ler's.
993: --
994: and exists
995: (select null
996: from ben_per_in_ler pil
997: where pil.per_in_ler_id = cwh.emp_per_in_ler_id
998: and pil.per_in_ler_stat_cd = 'STRTD'
999: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
1000: and pil.group_pl_id = cv_pl_id

Line 1027: from ben_per_in_ler pil

1023: -- Bug 2541072 : Do not consider all per in ler's.
1024: --
1025: and exists
1026: (select null
1027: from ben_per_in_ler pil
1028: where pil.per_in_ler_id = cwh.emp_per_in_ler_id
1029: and pil.per_in_ler_stat_cd = 'STRTD'
1030: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
1031: and pil.group_pl_id = cv_pl_id

Line 1040: from ben_per_in_ler pil, ben_cwb_group_hrchy cwh

1036: -- delete, but waiting for GSI to validate it scales better.
1037: -- For bug 4587770
1038: --
1039: select cwh.rowid
1040: from ben_per_in_ler pil, ben_cwb_group_hrchy cwh
1041: where pil.per_in_ler_id = cwh.emp_per_in_ler_id
1042: and pil.per_in_ler_stat_cd = 'STRTD'
1043: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
1044: and pil.group_pl_id = cv_pl_id

Line 1248: from ben_per_in_ler pil

1244: --
1245: delete from ben_cwb_group_hrchy
1246: where emp_per_in_ler_id in (
1247: select pil.per_in_ler_id
1248: from ben_per_in_ler pil
1249: where pil.group_pl_id = lv_pl_id
1250: and pil.lf_evt_ocrd_dt = lv_lf_evt_ocrd_dt
1251: and pil.per_in_ler_stat_cd = 'BCKDT');
1252: --

Line 1256: from ben_per_in_ler pil

1252: --
1253: delete from ben_cwb_group_hrchy
1254: where mgr_per_in_ler_id in (
1255: select pil.per_in_ler_id
1256: from ben_per_in_ler pil
1257: where pil.group_pl_id = lv_pl_id
1258: and pil.lf_evt_ocrd_dt = lv_lf_evt_ocrd_dt
1259: and pil.per_in_ler_stat_cd = 'BCKDT');
1260: --

Line 1843: from ben_per_in_ler pil,

1839: pil.object_version_number pil_ovn,
1840: pil.business_group_id,
1841: ptnl.ptnl_ler_for_per_id,
1842: ptnl.object_version_number ptnl_ovn
1843: from ben_per_in_ler pil,
1844: ben_ptnl_ler_for_per ptnl,
1845: ben_cwb_person_info cpi
1846: where pil.group_pl_id = cv_group_pl_id
1847: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt

Line 1879: * ben_per_in_ler, ben_ptnl_ler_for_per, ben_pil_elctbl_chc_popl,

1875: * ELIG_FLAG = Y and only consider uncloned data
1876: * then
1877: *
1878: * Delete data from ben_cwb_person_rates, ben_cwb_person_groups,
1879: * ben_per_in_ler, ben_ptnl_ler_for_per, ben_pil_elctbl_chc_popl,
1880: * ben_elig_per_elctbl_chc, ben_group_heirarchy,
1881: * ben_cwb_person_tasks.
1882: */
1883: if g_debug then

Line 2042: from ben_per_in_ler

2038: cursor get_mgr_pil_id (cv_person_id in number,
2039: cv_lf_evt_ocrd_dt in date,
2040: cv_group_ler_id in number) is
2041: select per_in_ler_id
2042: from ben_per_in_ler
2043: where person_id = cv_person_id
2044: and lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
2045: and ler_id = cv_group_ler_id
2046: and per_in_ler_stat_cd = 'STRTD';

Line 2666: from ben_per_in_ler pil

2662: cv_lf_evt_ocrd_dt date,
2663: cv_ler_id number,
2664: cv_business_group_id number) is
2665: select pil.per_in_ler_id
2666: from ben_per_in_ler pil
2667: where pil.group_pl_id = cv_pl_id
2668: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
2669: and pil.ler_id = cv_ler_id
2670: and pil.person_id = cv_person_id

Line 3729: from ben_per_in_ler pil

3725: select pil.group_pl_id,
3726: pil.lf_evt_ocrd_dt,
3727: pil.business_group_id,
3728: pil.ler_id
3729: from ben_per_in_ler pil
3730: where pil.per_in_ler_id = p_group_per_in_ler_id ;
3731: --
3732: l_ler_id number ;
3733: begin

Line 4468: from ben_per_in_ler all_pils

4464: p_effective_date in date default null) is
4465: --
4466: cursor c_missing_group_pils is
4467: select person_id
4468: from ben_per_in_ler all_pils
4469: where group_pl_id = p_group_pl_id
4470: and lf_evt_ocrd_dt = p_group_lf_evt_ocrd_dt
4471: and per_in_ler_stat_cd = 'STRTD'
4472: union

Line 4474: from ben_per_in_ler all_pils

4470: and lf_evt_ocrd_dt = p_group_lf_evt_ocrd_dt
4471: and per_in_ler_stat_cd = 'STRTD'
4472: union
4473: select ws_mgr_id
4474: from ben_per_in_ler all_pils
4475: where group_pl_id = p_group_pl_id
4476: and lf_evt_ocrd_dt = p_group_lf_evt_ocrd_dt
4477: and per_in_ler_stat_cd = 'STRTD'
4478: and ws_mgr_id is not null

Line 4481: from ben_per_in_ler all_pils

4477: and per_in_ler_stat_cd = 'STRTD'
4478: and ws_mgr_id is not null
4479: minus
4480: select person_id
4481: from ben_per_in_ler all_pils
4482: where group_pl_id = p_group_pl_id
4483: and lf_evt_ocrd_dt = p_group_lf_evt_ocrd_dt
4484: and per_in_ler_stat_cd in ('STRTD', 'PROCD') -- GSI If a person is already processed but his reportee
4485: -- is processed then data should not be created for manager.

Line 4503: from ben_per_in_ler

4499: cursor get_gpil_id (cv_person_id in number,
4500: cv_lf_evt_ocrd_dt in date,
4501: cv_group_ler_id in number) is
4502: select per_in_ler_id
4503: from ben_per_in_ler
4504: where person_id = cv_person_id
4505: and lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
4506: and ler_id = cv_group_ler_id
4507: and per_in_ler_stat_cd = 'STRTD';

Line 4525: For each person in( ((select person_id from ben_per_in_ler all_pils)

4521: popu_missing_pil(p_mode, p_group_pl_business_group_id, p_group_pl_id,
4522: p_group_ler_id, p_effective_date, p_lf_evt_ocrd_dt)
4523: Loop
4524: L_exit_loop = TRUE;
4525: For each person in( ((select person_id from ben_per_in_ler all_pils)
4526: union
4527: (select ws_mgr_id from ben_per_in_ler all_pils)
4528: ) minus
4529: (select person_id from ben_per_in_ler group_plan_pils)

Line 4527: (select ws_mgr_id from ben_per_in_ler all_pils)

4523: Loop
4524: L_exit_loop = TRUE;
4525: For each person in( ((select person_id from ben_per_in_ler all_pils)
4526: union
4527: (select ws_mgr_id from ben_per_in_ler all_pils)
4528: ) minus
4529: (select person_id from ben_per_in_ler group_plan_pils)
4530: )
4531: Loop

Line 4529: (select person_id from ben_per_in_ler group_plan_pils)

4525: For each person in( ((select person_id from ben_per_in_ler all_pils)
4526: union
4527: (select ws_mgr_id from ben_per_in_ler all_pils)
4528: ) minus
4529: (select person_id from ben_per_in_ler group_plan_pils)
4530: )
4531: Loop
4532: popu_missing_person_pil(p_mode, p_person_id,
4533: p_group_pl_business_group_id,