[Home] [Help]
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
433: ,ben_enrt_rt rs
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
532: ,ben_enrt_rt ss
1528: cursor c_epe_rsgn_appr is
1529: select pil.per_in_ler_id
1530: ,tx.transaction_id
1531: from ben_transaction tx
1532: ,ben_elig_per_elctbl_chc epe
1533: ,ben_per_in_ler pil
1534: where tx.transaction_type = 'CWBEMPRSGN'
1535: and tx.attribute1 = 'APPR'
1536: and epe.elig_per_elctbl_chc_id = to_number(tx.attribute10)
1555: ,prop_mgr_pil.per_in_ler_id
1556: ,emp.pl_id
1557: ,tx.transaction_id
1558: from ben_transaction tx
1559: ,ben_elig_per_elctbl_chc emp
1560: ,ben_per_in_ler emp_pil
1561: ,ben_elig_per_elctbl_chc curr_mgr
1562: ,ben_per_in_ler curr_mgr_pil
1563: ,ben_elig_per_elctbl_chc prop_mgr
1557: ,tx.transaction_id
1558: from ben_transaction tx
1559: ,ben_elig_per_elctbl_chc emp
1560: ,ben_per_in_ler emp_pil
1561: ,ben_elig_per_elctbl_chc curr_mgr
1562: ,ben_per_in_ler curr_mgr_pil
1563: ,ben_elig_per_elctbl_chc prop_mgr
1564: ,ben_per_in_ler prop_mgr_pil
1565: where tx.transaction_type = 'CWBEMPRSGN'
1559: ,ben_elig_per_elctbl_chc emp
1560: ,ben_per_in_ler emp_pil
1561: ,ben_elig_per_elctbl_chc curr_mgr
1562: ,ben_per_in_ler curr_mgr_pil
1563: ,ben_elig_per_elctbl_chc prop_mgr
1564: ,ben_per_in_ler prop_mgr_pil
1565: where tx.transaction_type = 'CWBEMPRSGN'
1566: and tx.attribute1 = 'EMP'
1567: and tx.attribute21 is null