[Home] [Help]
125: where pln.pl_id = pl.pl_id
126: and pln.lf_evt_ocrd_dt = enp.asnd_lf_evt_dt)
127: and exists (select 'Y'
128: from ben_per_in_ler pil
129: ,ben_pil_elctbl_chc_popl popl
130: where pil.lf_evt_ocrd_dt = enp.asnd_lf_evt_dt
131: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
132: and pil.group_pl_id is null
133: and pil.per_in_ler_id = popl.per_in_ler_id
318: ,last_update_login
319: ,created_by
320: ,creation_date
321: ,object_version_number)
322: select /*+INDEX(emp_popl,ben_pil_elctbl_chc_popl_pk) INDEX(mgr_popl,ben_pil_elctbl_chc_popl_pk)*/
323: mgr_popl.per_in_ler_id
324: ,emp_popl.per_in_ler_id
325: ,hrchy.lvl_num
326: ,hrchy.last_update_date
329: ,hrchy.created_by
330: ,hrchy.creation_date
331: ,1
332: from ben_cwb_hrchy hrchy
333: ,ben_pil_elctbl_chc_popl emp_popl
334: ,ben_pil_elctbl_chc_popl mgr_popl
335: where nvl(hrchy.object_version_number,1) < 9999
336: and lvl_num > -1
337: and hrchy.emp_pil_elctbl_chc_popl_id = emp_popl.pil_elctbl_chc_popl_id
330: ,hrchy.creation_date
331: ,1
332: from ben_cwb_hrchy hrchy
333: ,ben_pil_elctbl_chc_popl emp_popl
334: ,ben_pil_elctbl_chc_popl mgr_popl
335: where nvl(hrchy.object_version_number,1) < 9999
336: and lvl_num > -1
337: and hrchy.emp_pil_elctbl_chc_popl_id = emp_popl.pil_elctbl_chc_popl_id
338: and hrchy.mgr_pil_elctbl_chc_popl_id = mgr_popl.pil_elctbl_chc_popl_id;
424: ,db.val_last_upd_person_id dist_bdgt_val_last_upd_by
425: ,rs.val_last_upd_person_id rsrv_val_last_upd_by
426: ,1
427: from ben_per_in_ler pil
428: ,ben_pil_elctbl_chc_popl popl
429: ,ben_elig_per_elctbl_chc epe
430: ,ben_cwb_person_groups grp
431: ,ben_enrt_rt db
432: ,ben_enrt_rt wb
523: ,nvl(prv.rt_strt_dt, ws.rt_strt_dt)
524: ,1
525: ,popl.uom
526: from ben_per_in_ler pil
527: ,ben_pil_elctbl_chc_popl popl
528: ,ben_elig_per_elctbl_chc epe
529: ,ben_cwb_person_rates rate
530: ,ben_enrt_rt ws
531: ,ben_enrt_rt es
618: ,popl.pel_attribute28
619: ,popl.pel_attribute29
620: ,popl.pel_attribute30
621: from ben_per_in_ler pil
622: ,ben_pil_elctbl_chc_popl popl
623: ,ben_cwb_person_info per
624: where pil.group_pl_id is null
625: and pil.assignment_id is null
626: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
855: ) status_cd
856: ,1
857: from ben_cwb_wksht_grp tk
858: ,ben_per_in_ler pil
859: ,ben_pil_elctbl_chc_popl popl
860: where pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
861: and pil.group_pl_id is null
862: and pil.assignment_id is null
863: and pil.per_in_ler_id = popl.per_in_ler_id
1540: cursor c_pel_rsgn_appr is
1541: select pil.per_in_ler_id
1542: ,tx.transaction_id
1543: from ben_transaction tx
1544: ,ben_pil_elctbl_chc_popl pel
1545: ,ben_per_in_ler pil
1546: where tx.transaction_type = 'CWBEMPRSGN'
1547: and tx.attribute1 = 'APPR'
1548: and pel.pil_elctbl_chc_popl_id = to_number(tx.attribute10)
1582: ,prop_mgr_pil.per_in_ler_id
1583: ,emp.pl_id
1584: ,tx.transaction_id
1585: from ben_transaction tx
1586: ,ben_pil_elctbl_chc_popl emp
1587: ,ben_per_in_ler emp_pil
1588: ,ben_pil_elctbl_chc_popl curr_mgr
1589: ,ben_per_in_ler curr_mgr_pil
1590: ,ben_pil_elctbl_chc_popl prop_mgr
1584: ,tx.transaction_id
1585: from ben_transaction tx
1586: ,ben_pil_elctbl_chc_popl emp
1587: ,ben_per_in_ler emp_pil
1588: ,ben_pil_elctbl_chc_popl curr_mgr
1589: ,ben_per_in_ler curr_mgr_pil
1590: ,ben_pil_elctbl_chc_popl prop_mgr
1591: ,ben_per_in_ler prop_mgr_pil
1592: where tx.transaction_type = 'CWBEMPRSGN'
1586: ,ben_pil_elctbl_chc_popl emp
1587: ,ben_per_in_ler emp_pil
1588: ,ben_pil_elctbl_chc_popl curr_mgr
1589: ,ben_per_in_ler curr_mgr_pil
1590: ,ben_pil_elctbl_chc_popl prop_mgr
1591: ,ben_per_in_ler prop_mgr_pil
1592: where tx.transaction_type = 'CWBEMPRSGN'
1593: and tx.attribute1 = 'EMP'
1594: and tx.attribute21 is null
1675: ,tx.attribute1
1676: ,enp.emp_interview_type_cd
1677: ,tx.attribute3
1678: from ben_transaction tx
1679: ,ben_pil_elctbl_chc_popl popl
1680: ,ben_enrt_perd enp
1681: where tx.transaction_type = 'CWBWSASG'
1682: and tx.attribute1 is not null
1683: and tx.attribute3 is not null
1768: ,tx.attribute38
1769: ,tx.attribute39
1770: ,tx.attribute40
1771: from ben_transaction tx
1772: ,ben_pil_elctbl_chc_popl popl
1773: where tx.transaction_type = 'CWBWSASG'
1774: and tx.attribute2 is not null
1775: and tx.transaction_id = popl.pil_elctbl_chc_popl_id;
1776: