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: */

Line 858: ben_per_in_ler pil

854: pil.ws_mgr_id,
855: pil.person_id
856: from
857: ben_cwb_group_hrchy cwb,
858: ben_per_in_ler pil
859: where
860: cwb.mgr_per_in_ler_id = -1
861: and pil.per_in_ler_id = cwb.emp_per_in_ler_id
862: and pil.per_in_ler_stat_cd = 'STRTD'

Line 892: from ben_per_in_ler pil

888: p_ler_id number,
889: p_business_group_id number) is
890: select pil.ws_mgr_id,
891: pil.per_in_ler_id
892: from ben_per_in_ler pil
893: where pil.group_pl_id = p_pl_id
894: and pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
895: and pil.ler_id = p_ler_id
896: and pil.person_id = p_person_id

Line 966: from ben_per_in_ler pil

962: -- Bug 2541072 : Do not consider all per in ler's.
963: --
964: and exists
965: (select null
966: from ben_per_in_ler pil
967: where pil.per_in_ler_id = cwh.emp_per_in_ler_id
968: and pil.per_in_ler_stat_cd = 'STRTD'
969: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
970: and pil.group_pl_id = cv_pl_id

Line 997: from ben_per_in_ler pil

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

Line 1010: from ben_per_in_ler pil, ben_cwb_group_hrchy cwh

1006: -- delete, but waiting for GSI to validate it scales better.
1007: -- For bug 4587770
1008: --
1009: select cwh.rowid
1010: from ben_per_in_ler pil, ben_cwb_group_hrchy cwh
1011: where pil.per_in_ler_id = cwh.emp_per_in_ler_id
1012: and pil.per_in_ler_stat_cd = 'STRTD'
1013: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
1014: and pil.group_pl_id = cv_pl_id

Line 1218: from ben_per_in_ler pil

1214: --
1215: delete from ben_cwb_group_hrchy
1216: where emp_per_in_ler_id in (
1217: select pil.per_in_ler_id
1218: from ben_per_in_ler pil
1219: where pil.group_pl_id = lv_pl_id
1220: and pil.lf_evt_ocrd_dt = lv_lf_evt_ocrd_dt
1221: and pil.per_in_ler_stat_cd = 'BCKDT');
1222: --

Line 1226: from ben_per_in_ler pil

1222: --
1223: delete from ben_cwb_group_hrchy
1224: where mgr_per_in_ler_id in (
1225: select pil.per_in_ler_id
1226: from ben_per_in_ler pil
1227: where pil.group_pl_id = lv_pl_id
1228: and pil.lf_evt_ocrd_dt = lv_lf_evt_ocrd_dt
1229: and pil.per_in_ler_stat_cd = 'BCKDT');
1230: --

Line 1798: from ben_per_in_ler pil,

1794: pil.object_version_number pil_ovn,
1795: pil.business_group_id,
1796: ptnl.ptnl_ler_for_per_id,
1797: ptnl.object_version_number ptnl_ovn
1798: from ben_per_in_ler pil,
1799: ben_ptnl_ler_for_per ptnl,
1800: ben_cwb_person_info cpi
1801: where pil.group_pl_id = cv_group_pl_id
1802: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt

Line 1834: * ben_per_in_ler, ben_ptnl_ler_for_per, ben_pil_elctbl_chc_popl,

1830: * ELIG_FLAG = Y and only consider uncloned data
1831: * then
1832: *
1833: * Delete data from ben_cwb_person_rates, ben_cwb_person_groups,
1834: * ben_per_in_ler, ben_ptnl_ler_for_per, ben_pil_elctbl_chc_popl,
1835: * ben_elig_per_elctbl_chc, ben_group_heirarchy,
1836: * ben_cwb_person_tasks.
1837: */
1838: if g_debug then

Line 1997: from ben_per_in_ler

1993: cursor get_mgr_pil_id (cv_person_id in number,
1994: cv_lf_evt_ocrd_dt in date,
1995: cv_group_ler_id in number) is
1996: select per_in_ler_id
1997: from ben_per_in_ler
1998: where person_id = cv_person_id
1999: and lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
2000: and ler_id = cv_group_ler_id
2001: and per_in_ler_stat_cd = 'STRTD';

Line 2621: from ben_per_in_ler pil

2617: cv_lf_evt_ocrd_dt date,
2618: cv_ler_id number,
2619: cv_business_group_id number) is
2620: select pil.per_in_ler_id
2621: from ben_per_in_ler pil
2622: where pil.group_pl_id = cv_pl_id
2623: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
2624: and pil.ler_id = cv_ler_id
2625: and pil.person_id = cv_person_id

Line 3677: from ben_per_in_ler pil

3673: select pil.group_pl_id,
3674: pil.lf_evt_ocrd_dt,
3675: pil.business_group_id,
3676: pil.ler_id
3677: from ben_per_in_ler pil
3678: where pil.per_in_ler_id = p_group_per_in_ler_id ;
3679: --
3680: l_ler_id number ;
3681: begin

Line 4416: from ben_per_in_ler all_pils

4412: p_effective_date in date default null) is
4413: --
4414: cursor c_missing_group_pils is
4415: select person_id
4416: from ben_per_in_ler all_pils
4417: where group_pl_id = p_group_pl_id
4418: and lf_evt_ocrd_dt = p_group_lf_evt_ocrd_dt
4419: and per_in_ler_stat_cd = 'STRTD'
4420: union

Line 4422: from ben_per_in_ler all_pils

4418: and lf_evt_ocrd_dt = p_group_lf_evt_ocrd_dt
4419: and per_in_ler_stat_cd = 'STRTD'
4420: union
4421: select ws_mgr_id
4422: from ben_per_in_ler all_pils
4423: where group_pl_id = p_group_pl_id
4424: and lf_evt_ocrd_dt = p_group_lf_evt_ocrd_dt
4425: and per_in_ler_stat_cd = 'STRTD'
4426: and ws_mgr_id is not null

Line 4429: from ben_per_in_ler all_pils

4425: and per_in_ler_stat_cd = 'STRTD'
4426: and ws_mgr_id is not null
4427: minus
4428: select person_id
4429: from ben_per_in_ler all_pils
4430: where group_pl_id = p_group_pl_id
4431: and lf_evt_ocrd_dt = p_group_lf_evt_ocrd_dt
4432: and per_in_ler_stat_cd in ('STRTD', 'PROCD') -- GSI If a person is already processed but his reportee
4433: -- is processed then data should not be created for manager.

Line 4451: from ben_per_in_ler

4447: cursor get_gpil_id (cv_person_id in number,
4448: cv_lf_evt_ocrd_dt in date,
4449: cv_group_ler_id in number) is
4450: select per_in_ler_id
4451: from ben_per_in_ler
4452: where person_id = cv_person_id
4453: and lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
4454: and ler_id = cv_group_ler_id
4455: and per_in_ler_stat_cd = 'STRTD';

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

4469: popu_missing_pil(p_mode, p_group_pl_business_group_id, p_group_pl_id,
4470: p_group_ler_id, p_effective_date, p_lf_evt_ocrd_dt)
4471: Loop
4472: L_exit_loop = TRUE;
4473: For each person in( ((select person_id from ben_per_in_ler all_pils)
4474: union
4475: (select ws_mgr_id from ben_per_in_ler all_pils)
4476: ) minus
4477: (select person_id from ben_per_in_ler group_plan_pils)

Line 4475: (select ws_mgr_id from ben_per_in_ler all_pils)

4471: Loop
4472: L_exit_loop = TRUE;
4473: For each person in( ((select person_id from ben_per_in_ler all_pils)
4474: union
4475: (select ws_mgr_id from ben_per_in_ler all_pils)
4476: ) minus
4477: (select person_id from ben_per_in_ler group_plan_pils)
4478: )
4479: Loop

Line 4477: (select person_id from ben_per_in_ler group_plan_pils)

4473: For each person in( ((select person_id from ben_per_in_ler all_pils)
4474: union
4475: (select ws_mgr_id from ben_per_in_ler all_pils)
4476: ) minus
4477: (select person_id from ben_per_in_ler group_plan_pils)
4478: )
4479: Loop
4480: popu_missing_person_pil(p_mode, p_person_id,
4481: p_group_pl_business_group_id,