20: --
21: hr_utility.set_location('Entering'||l_proc, 5);
22: --
23: /* Start of Changes for WWBUG: 1828349: addition */
24: ben_ext_person.g_enrt_prtt_enrt_rslt_id := null;
25: /* End of Changes for WWBUG: 1828349 */
26: ben_ext_person.g_enrt_pl_name := null;
27: ben_ext_person.g_enrt_opt_name := null;
28: ben_ext_person.g_enrt_orgcovg_strdt := null;
22: --
23: /* Start of Changes for WWBUG: 1828349: addition */
24: ben_ext_person.g_enrt_prtt_enrt_rslt_id := null;
25: /* End of Changes for WWBUG: 1828349 */
26: ben_ext_person.g_enrt_pl_name := null;
27: ben_ext_person.g_enrt_opt_name := null;
28: ben_ext_person.g_enrt_orgcovg_strdt := null;
29: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
30: ben_ext_person.g_enrt_status_cd := null;
23: /* Start of Changes for WWBUG: 1828349: addition */
24: ben_ext_person.g_enrt_prtt_enrt_rslt_id := null;
25: /* End of Changes for WWBUG: 1828349 */
26: ben_ext_person.g_enrt_pl_name := null;
27: ben_ext_person.g_enrt_opt_name := null;
28: ben_ext_person.g_enrt_orgcovg_strdt := null;
29: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
30: ben_ext_person.g_enrt_status_cd := null;
31: ben_ext_person.g_enrt_pl_id := null;
24: ben_ext_person.g_enrt_prtt_enrt_rslt_id := null;
25: /* End of Changes for WWBUG: 1828349 */
26: ben_ext_person.g_enrt_pl_name := null;
27: ben_ext_person.g_enrt_opt_name := null;
28: ben_ext_person.g_enrt_orgcovg_strdt := null;
29: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
30: ben_ext_person.g_enrt_status_cd := null;
31: ben_ext_person.g_enrt_pl_id := null;
32: ben_ext_person.g_enrt_pl_seq_num := null;
25: /* End of Changes for WWBUG: 1828349 */
26: ben_ext_person.g_enrt_pl_name := null;
27: ben_ext_person.g_enrt_opt_name := null;
28: ben_ext_person.g_enrt_orgcovg_strdt := null;
29: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
30: ben_ext_person.g_enrt_status_cd := null;
31: ben_ext_person.g_enrt_pl_id := null;
32: ben_ext_person.g_enrt_pl_seq_num := null;
33: ben_ext_person.g_enrt_pip_seq_num := null;
26: ben_ext_person.g_enrt_pl_name := null;
27: ben_ext_person.g_enrt_opt_name := null;
28: ben_ext_person.g_enrt_orgcovg_strdt := null;
29: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
30: ben_ext_person.g_enrt_status_cd := null;
31: ben_ext_person.g_enrt_pl_id := null;
32: ben_ext_person.g_enrt_pl_seq_num := null;
33: ben_ext_person.g_enrt_pip_seq_num := null;
34: ben_ext_person.g_enrt_ptp_seq_num := null;
27: ben_ext_person.g_enrt_opt_name := null;
28: ben_ext_person.g_enrt_orgcovg_strdt := null;
29: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
30: ben_ext_person.g_enrt_status_cd := null;
31: ben_ext_person.g_enrt_pl_id := null;
32: ben_ext_person.g_enrt_pl_seq_num := null;
33: ben_ext_person.g_enrt_pip_seq_num := null;
34: ben_ext_person.g_enrt_ptp_seq_num := null;
35: ben_ext_person.g_enrt_oip_seq_num := null;
28: ben_ext_person.g_enrt_orgcovg_strdt := null;
29: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
30: ben_ext_person.g_enrt_status_cd := null;
31: ben_ext_person.g_enrt_pl_id := null;
32: ben_ext_person.g_enrt_pl_seq_num := null;
33: ben_ext_person.g_enrt_pip_seq_num := null;
34: ben_ext_person.g_enrt_ptp_seq_num := null;
35: ben_ext_person.g_enrt_oip_seq_num := null;
36: ben_ext_person.g_enrt_opt_id := null;
29: ben_ext_person.g_enrt_prt_orgcovg_strdt := null;
30: ben_ext_person.g_enrt_status_cd := null;
31: ben_ext_person.g_enrt_pl_id := null;
32: ben_ext_person.g_enrt_pl_seq_num := null;
33: ben_ext_person.g_enrt_pip_seq_num := null;
34: ben_ext_person.g_enrt_ptp_seq_num := null;
35: ben_ext_person.g_enrt_oip_seq_num := null;
36: ben_ext_person.g_enrt_opt_id := null;
37: ben_ext_person.g_enrt_cvg_strt_dt := null;
30: ben_ext_person.g_enrt_status_cd := null;
31: ben_ext_person.g_enrt_pl_id := null;
32: ben_ext_person.g_enrt_pl_seq_num := null;
33: ben_ext_person.g_enrt_pip_seq_num := null;
34: ben_ext_person.g_enrt_ptp_seq_num := null;
35: ben_ext_person.g_enrt_oip_seq_num := null;
36: ben_ext_person.g_enrt_opt_id := null;
37: ben_ext_person.g_enrt_cvg_strt_dt := null;
38: ben_ext_person.g_enrt_cvg_thru_dt := null;
31: ben_ext_person.g_enrt_pl_id := null;
32: ben_ext_person.g_enrt_pl_seq_num := null;
33: ben_ext_person.g_enrt_pip_seq_num := null;
34: ben_ext_person.g_enrt_ptp_seq_num := null;
35: ben_ext_person.g_enrt_oip_seq_num := null;
36: ben_ext_person.g_enrt_opt_id := null;
37: ben_ext_person.g_enrt_cvg_strt_dt := null;
38: ben_ext_person.g_enrt_cvg_thru_dt := null;
39: ben_ext_person.g_enrt_method := null;
32: ben_ext_person.g_enrt_pl_seq_num := null;
33: ben_ext_person.g_enrt_pip_seq_num := null;
34: ben_ext_person.g_enrt_ptp_seq_num := null;
35: ben_ext_person.g_enrt_oip_seq_num := null;
36: ben_ext_person.g_enrt_opt_id := null;
37: ben_ext_person.g_enrt_cvg_strt_dt := null;
38: ben_ext_person.g_enrt_cvg_thru_dt := null;
39: ben_ext_person.g_enrt_method := null;
40: ben_ext_person.g_enrt_ovrd_flag := null;
33: ben_ext_person.g_enrt_pip_seq_num := null;
34: ben_ext_person.g_enrt_ptp_seq_num := null;
35: ben_ext_person.g_enrt_oip_seq_num := null;
36: ben_ext_person.g_enrt_opt_id := null;
37: ben_ext_person.g_enrt_cvg_strt_dt := null;
38: ben_ext_person.g_enrt_cvg_thru_dt := null;
39: ben_ext_person.g_enrt_method := null;
40: ben_ext_person.g_enrt_ovrd_flag := null;
41: ben_ext_person.g_enrt_ovrd_thru_dt := null;
34: ben_ext_person.g_enrt_ptp_seq_num := null;
35: ben_ext_person.g_enrt_oip_seq_num := null;
36: ben_ext_person.g_enrt_opt_id := null;
37: ben_ext_person.g_enrt_cvg_strt_dt := null;
38: ben_ext_person.g_enrt_cvg_thru_dt := null;
39: ben_ext_person.g_enrt_method := null;
40: ben_ext_person.g_enrt_ovrd_flag := null;
41: ben_ext_person.g_enrt_ovrd_thru_dt := null;
42: ben_ext_person.g_enrt_ovrd_reason := null;
35: ben_ext_person.g_enrt_oip_seq_num := null;
36: ben_ext_person.g_enrt_opt_id := null;
37: ben_ext_person.g_enrt_cvg_strt_dt := null;
38: ben_ext_person.g_enrt_cvg_thru_dt := null;
39: ben_ext_person.g_enrt_method := null;
40: ben_ext_person.g_enrt_ovrd_flag := null;
41: ben_ext_person.g_enrt_ovrd_thru_dt := null;
42: ben_ext_person.g_enrt_ovrd_reason := null;
43: ben_ext_person.g_enrt_suspended_flag := null;
36: ben_ext_person.g_enrt_opt_id := null;
37: ben_ext_person.g_enrt_cvg_strt_dt := null;
38: ben_ext_person.g_enrt_cvg_thru_dt := null;
39: ben_ext_person.g_enrt_method := null;
40: ben_ext_person.g_enrt_ovrd_flag := null;
41: ben_ext_person.g_enrt_ovrd_thru_dt := null;
42: ben_ext_person.g_enrt_ovrd_reason := null;
43: ben_ext_person.g_enrt_suspended_flag := null;
44: ben_ext_person.g_enrt_rslt_effct_strdt := null;
37: ben_ext_person.g_enrt_cvg_strt_dt := null;
38: ben_ext_person.g_enrt_cvg_thru_dt := null;
39: ben_ext_person.g_enrt_method := null;
40: ben_ext_person.g_enrt_ovrd_flag := null;
41: ben_ext_person.g_enrt_ovrd_thru_dt := null;
42: ben_ext_person.g_enrt_ovrd_reason := null;
43: ben_ext_person.g_enrt_suspended_flag := null;
44: ben_ext_person.g_enrt_rslt_effct_strdt := null;
45: ben_ext_person.g_enrt_total_premium_amt := null;
38: ben_ext_person.g_enrt_cvg_thru_dt := null;
39: ben_ext_person.g_enrt_method := null;
40: ben_ext_person.g_enrt_ovrd_flag := null;
41: ben_ext_person.g_enrt_ovrd_thru_dt := null;
42: ben_ext_person.g_enrt_ovrd_reason := null;
43: ben_ext_person.g_enrt_suspended_flag := null;
44: ben_ext_person.g_enrt_rslt_effct_strdt := null;
45: ben_ext_person.g_enrt_total_premium_amt := null;
46: ben_ext_person.g_enrt_total_premium_uom := null;
39: ben_ext_person.g_enrt_method := null;
40: ben_ext_person.g_enrt_ovrd_flag := null;
41: ben_ext_person.g_enrt_ovrd_thru_dt := null;
42: ben_ext_person.g_enrt_ovrd_reason := null;
43: ben_ext_person.g_enrt_suspended_flag := null;
44: ben_ext_person.g_enrt_rslt_effct_strdt := null;
45: ben_ext_person.g_enrt_total_premium_amt := null;
46: ben_ext_person.g_enrt_total_premium_uom := null;
47: ben_ext_person.g_enrt_mntot_prem_amt := null;
40: ben_ext_person.g_enrt_ovrd_flag := null;
41: ben_ext_person.g_enrt_ovrd_thru_dt := null;
42: ben_ext_person.g_enrt_ovrd_reason := null;
43: ben_ext_person.g_enrt_suspended_flag := null;
44: ben_ext_person.g_enrt_rslt_effct_strdt := null;
45: ben_ext_person.g_enrt_total_premium_amt := null;
46: ben_ext_person.g_enrt_total_premium_uom := null;
47: ben_ext_person.g_enrt_mntot_prem_amt := null;
48: ben_ext_person.g_enrt_mntot_prem_cramt := null;
41: ben_ext_person.g_enrt_ovrd_thru_dt := null;
42: ben_ext_person.g_enrt_ovrd_reason := null;
43: ben_ext_person.g_enrt_suspended_flag := null;
44: ben_ext_person.g_enrt_rslt_effct_strdt := null;
45: ben_ext_person.g_enrt_total_premium_amt := null;
46: ben_ext_person.g_enrt_total_premium_uom := null;
47: ben_ext_person.g_enrt_mntot_prem_amt := null;
48: ben_ext_person.g_enrt_mntot_prem_cramt := null;
49: ben_ext_person.g_enrt_cvg_amt := null;
42: ben_ext_person.g_enrt_ovrd_reason := null;
43: ben_ext_person.g_enrt_suspended_flag := null;
44: ben_ext_person.g_enrt_rslt_effct_strdt := null;
45: ben_ext_person.g_enrt_total_premium_amt := null;
46: ben_ext_person.g_enrt_total_premium_uom := null;
47: ben_ext_person.g_enrt_mntot_prem_amt := null;
48: ben_ext_person.g_enrt_mntot_prem_cramt := null;
49: ben_ext_person.g_enrt_cvg_amt := null;
50: ben_ext_person.g_enrt_benefit_order_num := null;
43: ben_ext_person.g_enrt_suspended_flag := null;
44: ben_ext_person.g_enrt_rslt_effct_strdt := null;
45: ben_ext_person.g_enrt_total_premium_amt := null;
46: ben_ext_person.g_enrt_total_premium_uom := null;
47: ben_ext_person.g_enrt_mntot_prem_amt := null;
48: ben_ext_person.g_enrt_mntot_prem_cramt := null;
49: ben_ext_person.g_enrt_cvg_amt := null;
50: ben_ext_person.g_enrt_benefit_order_num := null;
51: ben_ext_person.g_enrt_pgm_id := null;
44: ben_ext_person.g_enrt_rslt_effct_strdt := null;
45: ben_ext_person.g_enrt_total_premium_amt := null;
46: ben_ext_person.g_enrt_total_premium_uom := null;
47: ben_ext_person.g_enrt_mntot_prem_amt := null;
48: ben_ext_person.g_enrt_mntot_prem_cramt := null;
49: ben_ext_person.g_enrt_cvg_amt := null;
50: ben_ext_person.g_enrt_benefit_order_num := null;
51: ben_ext_person.g_enrt_pgm_id := null;
52: ben_ext_person.g_enrt_pgm_name := null;
45: ben_ext_person.g_enrt_total_premium_amt := null;
46: ben_ext_person.g_enrt_total_premium_uom := null;
47: ben_ext_person.g_enrt_mntot_prem_amt := null;
48: ben_ext_person.g_enrt_mntot_prem_cramt := null;
49: ben_ext_person.g_enrt_cvg_amt := null;
50: ben_ext_person.g_enrt_benefit_order_num := null;
51: ben_ext_person.g_enrt_pgm_id := null;
52: ben_ext_person.g_enrt_pgm_name := null;
53: ben_ext_person.g_enrt_pl_typ_id := null;
46: ben_ext_person.g_enrt_total_premium_uom := null;
47: ben_ext_person.g_enrt_mntot_prem_amt := null;
48: ben_ext_person.g_enrt_mntot_prem_cramt := null;
49: ben_ext_person.g_enrt_cvg_amt := null;
50: ben_ext_person.g_enrt_benefit_order_num := null;
51: ben_ext_person.g_enrt_pgm_id := null;
52: ben_ext_person.g_enrt_pgm_name := null;
53: ben_ext_person.g_enrt_pl_typ_id := null;
54: ben_ext_person.g_enrt_pl_typ_name := null;
47: ben_ext_person.g_enrt_mntot_prem_amt := null;
48: ben_ext_person.g_enrt_mntot_prem_cramt := null;
49: ben_ext_person.g_enrt_cvg_amt := null;
50: ben_ext_person.g_enrt_benefit_order_num := null;
51: ben_ext_person.g_enrt_pgm_id := null;
52: ben_ext_person.g_enrt_pgm_name := null;
53: ben_ext_person.g_enrt_pl_typ_id := null;
54: ben_ext_person.g_enrt_pl_typ_name := null;
55: ben_ext_person.g_enrt_rpt_group_name := null;
48: ben_ext_person.g_enrt_mntot_prem_cramt := null;
49: ben_ext_person.g_enrt_cvg_amt := null;
50: ben_ext_person.g_enrt_benefit_order_num := null;
51: ben_ext_person.g_enrt_pgm_id := null;
52: ben_ext_person.g_enrt_pgm_name := null;
53: ben_ext_person.g_enrt_pl_typ_id := null;
54: ben_ext_person.g_enrt_pl_typ_name := null;
55: ben_ext_person.g_enrt_rpt_group_name := null;
56: ben_ext_person.g_enrt_rpt_group_id := null;
49: ben_ext_person.g_enrt_cvg_amt := null;
50: ben_ext_person.g_enrt_benefit_order_num := null;
51: ben_ext_person.g_enrt_pgm_id := null;
52: ben_ext_person.g_enrt_pgm_name := null;
53: ben_ext_person.g_enrt_pl_typ_id := null;
54: ben_ext_person.g_enrt_pl_typ_name := null;
55: ben_ext_person.g_enrt_rpt_group_name := null;
56: ben_ext_person.g_enrt_rpt_group_id := null;
57: ben_ext_person.g_enrt_pl_yr_strdt := null;
50: ben_ext_person.g_enrt_benefit_order_num := null;
51: ben_ext_person.g_enrt_pgm_id := null;
52: ben_ext_person.g_enrt_pgm_name := null;
53: ben_ext_person.g_enrt_pl_typ_id := null;
54: ben_ext_person.g_enrt_pl_typ_name := null;
55: ben_ext_person.g_enrt_rpt_group_name := null;
56: ben_ext_person.g_enrt_rpt_group_id := null;
57: ben_ext_person.g_enrt_pl_yr_strdt := null;
58: ben_ext_person.g_enrt_pl_yr_enddt := null;
51: ben_ext_person.g_enrt_pgm_id := null;
52: ben_ext_person.g_enrt_pgm_name := null;
53: ben_ext_person.g_enrt_pl_typ_id := null;
54: ben_ext_person.g_enrt_pl_typ_name := null;
55: ben_ext_person.g_enrt_rpt_group_name := null;
56: ben_ext_person.g_enrt_rpt_group_id := null;
57: ben_ext_person.g_enrt_pl_yr_strdt := null;
58: ben_ext_person.g_enrt_pl_yr_enddt := null;
59: ben_ext_person.g_enrt_elec_made_dt := null;
52: ben_ext_person.g_enrt_pgm_name := null;
53: ben_ext_person.g_enrt_pl_typ_id := null;
54: ben_ext_person.g_enrt_pl_typ_name := null;
55: ben_ext_person.g_enrt_rpt_group_name := null;
56: ben_ext_person.g_enrt_rpt_group_id := null;
57: ben_ext_person.g_enrt_pl_yr_strdt := null;
58: ben_ext_person.g_enrt_pl_yr_enddt := null;
59: ben_ext_person.g_enrt_elec_made_dt := null;
60: ben_ext_person.g_enrt_intrcovg_flag := null;
53: ben_ext_person.g_enrt_pl_typ_id := null;
54: ben_ext_person.g_enrt_pl_typ_name := null;
55: ben_ext_person.g_enrt_rpt_group_name := null;
56: ben_ext_person.g_enrt_rpt_group_id := null;
57: ben_ext_person.g_enrt_pl_yr_strdt := null;
58: ben_ext_person.g_enrt_pl_yr_enddt := null;
59: ben_ext_person.g_enrt_elec_made_dt := null;
60: ben_ext_person.g_enrt_intrcovg_flag := null;
61: ben_ext_person.g_enrt_attr_1 := null;
54: ben_ext_person.g_enrt_pl_typ_name := null;
55: ben_ext_person.g_enrt_rpt_group_name := null;
56: ben_ext_person.g_enrt_rpt_group_id := null;
57: ben_ext_person.g_enrt_pl_yr_strdt := null;
58: ben_ext_person.g_enrt_pl_yr_enddt := null;
59: ben_ext_person.g_enrt_elec_made_dt := null;
60: ben_ext_person.g_enrt_intrcovg_flag := null;
61: ben_ext_person.g_enrt_attr_1 := null;
62: ben_ext_person.g_enrt_attr_2 := null;
55: ben_ext_person.g_enrt_rpt_group_name := null;
56: ben_ext_person.g_enrt_rpt_group_id := null;
57: ben_ext_person.g_enrt_pl_yr_strdt := null;
58: ben_ext_person.g_enrt_pl_yr_enddt := null;
59: ben_ext_person.g_enrt_elec_made_dt := null;
60: ben_ext_person.g_enrt_intrcovg_flag := null;
61: ben_ext_person.g_enrt_attr_1 := null;
62: ben_ext_person.g_enrt_attr_2 := null;
63: ben_ext_person.g_enrt_attr_3 := null;
56: ben_ext_person.g_enrt_rpt_group_id := null;
57: ben_ext_person.g_enrt_pl_yr_strdt := null;
58: ben_ext_person.g_enrt_pl_yr_enddt := null;
59: ben_ext_person.g_enrt_elec_made_dt := null;
60: ben_ext_person.g_enrt_intrcovg_flag := null;
61: ben_ext_person.g_enrt_attr_1 := null;
62: ben_ext_person.g_enrt_attr_2 := null;
63: ben_ext_person.g_enrt_attr_3 := null;
64: ben_ext_person.g_enrt_attr_4 := null;
57: ben_ext_person.g_enrt_pl_yr_strdt := null;
58: ben_ext_person.g_enrt_pl_yr_enddt := null;
59: ben_ext_person.g_enrt_elec_made_dt := null;
60: ben_ext_person.g_enrt_intrcovg_flag := null;
61: ben_ext_person.g_enrt_attr_1 := null;
62: ben_ext_person.g_enrt_attr_2 := null;
63: ben_ext_person.g_enrt_attr_3 := null;
64: ben_ext_person.g_enrt_attr_4 := null;
65: ben_ext_person.g_enrt_attr_5 := null;
58: ben_ext_person.g_enrt_pl_yr_enddt := null;
59: ben_ext_person.g_enrt_elec_made_dt := null;
60: ben_ext_person.g_enrt_intrcovg_flag := null;
61: ben_ext_person.g_enrt_attr_1 := null;
62: ben_ext_person.g_enrt_attr_2 := null;
63: ben_ext_person.g_enrt_attr_3 := null;
64: ben_ext_person.g_enrt_attr_4 := null;
65: ben_ext_person.g_enrt_attr_5 := null;
66: ben_ext_person.g_enrt_attr_6 := null;
59: ben_ext_person.g_enrt_elec_made_dt := null;
60: ben_ext_person.g_enrt_intrcovg_flag := null;
61: ben_ext_person.g_enrt_attr_1 := null;
62: ben_ext_person.g_enrt_attr_2 := null;
63: ben_ext_person.g_enrt_attr_3 := null;
64: ben_ext_person.g_enrt_attr_4 := null;
65: ben_ext_person.g_enrt_attr_5 := null;
66: ben_ext_person.g_enrt_attr_6 := null;
67: ben_ext_person.g_enrt_attr_7 := null;
60: ben_ext_person.g_enrt_intrcovg_flag := null;
61: ben_ext_person.g_enrt_attr_1 := null;
62: ben_ext_person.g_enrt_attr_2 := null;
63: ben_ext_person.g_enrt_attr_3 := null;
64: ben_ext_person.g_enrt_attr_4 := null;
65: ben_ext_person.g_enrt_attr_5 := null;
66: ben_ext_person.g_enrt_attr_6 := null;
67: ben_ext_person.g_enrt_attr_7 := null;
68: ben_ext_person.g_enrt_attr_8 := null;
61: ben_ext_person.g_enrt_attr_1 := null;
62: ben_ext_person.g_enrt_attr_2 := null;
63: ben_ext_person.g_enrt_attr_3 := null;
64: ben_ext_person.g_enrt_attr_4 := null;
65: ben_ext_person.g_enrt_attr_5 := null;
66: ben_ext_person.g_enrt_attr_6 := null;
67: ben_ext_person.g_enrt_attr_7 := null;
68: ben_ext_person.g_enrt_attr_8 := null;
69: ben_ext_person.g_enrt_attr_9 := null;
62: ben_ext_person.g_enrt_attr_2 := null;
63: ben_ext_person.g_enrt_attr_3 := null;
64: ben_ext_person.g_enrt_attr_4 := null;
65: ben_ext_person.g_enrt_attr_5 := null;
66: ben_ext_person.g_enrt_attr_6 := null;
67: ben_ext_person.g_enrt_attr_7 := null;
68: ben_ext_person.g_enrt_attr_8 := null;
69: ben_ext_person.g_enrt_attr_9 := null;
70: ben_ext_person.g_enrt_attr_10 := null;
63: ben_ext_person.g_enrt_attr_3 := null;
64: ben_ext_person.g_enrt_attr_4 := null;
65: ben_ext_person.g_enrt_attr_5 := null;
66: ben_ext_person.g_enrt_attr_6 := null;
67: ben_ext_person.g_enrt_attr_7 := null;
68: ben_ext_person.g_enrt_attr_8 := null;
69: ben_ext_person.g_enrt_attr_9 := null;
70: ben_ext_person.g_enrt_attr_10 := null;
71: ben_ext_person.g_enrt_ler_id := null;
64: ben_ext_person.g_enrt_attr_4 := null;
65: ben_ext_person.g_enrt_attr_5 := null;
66: ben_ext_person.g_enrt_attr_6 := null;
67: ben_ext_person.g_enrt_attr_7 := null;
68: ben_ext_person.g_enrt_attr_8 := null;
69: ben_ext_person.g_enrt_attr_9 := null;
70: ben_ext_person.g_enrt_attr_10 := null;
71: ben_ext_person.g_enrt_ler_id := null;
72: ben_ext_person.g_enrt_assignment_id := null;
65: ben_ext_person.g_enrt_attr_5 := null;
66: ben_ext_person.g_enrt_attr_6 := null;
67: ben_ext_person.g_enrt_attr_7 := null;
68: ben_ext_person.g_enrt_attr_8 := null;
69: ben_ext_person.g_enrt_attr_9 := null;
70: ben_ext_person.g_enrt_attr_10 := null;
71: ben_ext_person.g_enrt_ler_id := null;
72: ben_ext_person.g_enrt_assignment_id := null;
73: ben_ext_person.g_enrt_uom := null;
66: ben_ext_person.g_enrt_attr_6 := null;
67: ben_ext_person.g_enrt_attr_7 := null;
68: ben_ext_person.g_enrt_attr_8 := null;
69: ben_ext_person.g_enrt_attr_9 := null;
70: ben_ext_person.g_enrt_attr_10 := null;
71: ben_ext_person.g_enrt_ler_id := null;
72: ben_ext_person.g_enrt_assignment_id := null;
73: ben_ext_person.g_enrt_uom := null;
74: ben_ext_person.g_pl_attr_1 := null;
67: ben_ext_person.g_enrt_attr_7 := null;
68: ben_ext_person.g_enrt_attr_8 := null;
69: ben_ext_person.g_enrt_attr_9 := null;
70: ben_ext_person.g_enrt_attr_10 := null;
71: ben_ext_person.g_enrt_ler_id := null;
72: ben_ext_person.g_enrt_assignment_id := null;
73: ben_ext_person.g_enrt_uom := null;
74: ben_ext_person.g_pl_attr_1 := null;
75: ben_ext_person.g_pl_attr_2 := null;
68: ben_ext_person.g_enrt_attr_8 := null;
69: ben_ext_person.g_enrt_attr_9 := null;
70: ben_ext_person.g_enrt_attr_10 := null;
71: ben_ext_person.g_enrt_ler_id := null;
72: ben_ext_person.g_enrt_assignment_id := null;
73: ben_ext_person.g_enrt_uom := null;
74: ben_ext_person.g_pl_attr_1 := null;
75: ben_ext_person.g_pl_attr_2 := null;
76: ben_ext_person.g_pl_attr_3 := null;
69: ben_ext_person.g_enrt_attr_9 := null;
70: ben_ext_person.g_enrt_attr_10 := null;
71: ben_ext_person.g_enrt_ler_id := null;
72: ben_ext_person.g_enrt_assignment_id := null;
73: ben_ext_person.g_enrt_uom := null;
74: ben_ext_person.g_pl_attr_1 := null;
75: ben_ext_person.g_pl_attr_2 := null;
76: ben_ext_person.g_pl_attr_3 := null;
77: ben_ext_person.g_pl_attr_4 := null;
70: ben_ext_person.g_enrt_attr_10 := null;
71: ben_ext_person.g_enrt_ler_id := null;
72: ben_ext_person.g_enrt_assignment_id := null;
73: ben_ext_person.g_enrt_uom := null;
74: ben_ext_person.g_pl_attr_1 := null;
75: ben_ext_person.g_pl_attr_2 := null;
76: ben_ext_person.g_pl_attr_3 := null;
77: ben_ext_person.g_pl_attr_4 := null;
78: ben_ext_person.g_pl_attr_5 := null;
71: ben_ext_person.g_enrt_ler_id := null;
72: ben_ext_person.g_enrt_assignment_id := null;
73: ben_ext_person.g_enrt_uom := null;
74: ben_ext_person.g_pl_attr_1 := null;
75: ben_ext_person.g_pl_attr_2 := null;
76: ben_ext_person.g_pl_attr_3 := null;
77: ben_ext_person.g_pl_attr_4 := null;
78: ben_ext_person.g_pl_attr_5 := null;
79: ben_ext_person.g_pl_attr_6 := null;
72: ben_ext_person.g_enrt_assignment_id := null;
73: ben_ext_person.g_enrt_uom := null;
74: ben_ext_person.g_pl_attr_1 := null;
75: ben_ext_person.g_pl_attr_2 := null;
76: ben_ext_person.g_pl_attr_3 := null;
77: ben_ext_person.g_pl_attr_4 := null;
78: ben_ext_person.g_pl_attr_5 := null;
79: ben_ext_person.g_pl_attr_6 := null;
80: ben_ext_person.g_pl_attr_7 := null;
73: ben_ext_person.g_enrt_uom := null;
74: ben_ext_person.g_pl_attr_1 := null;
75: ben_ext_person.g_pl_attr_2 := null;
76: ben_ext_person.g_pl_attr_3 := null;
77: ben_ext_person.g_pl_attr_4 := null;
78: ben_ext_person.g_pl_attr_5 := null;
79: ben_ext_person.g_pl_attr_6 := null;
80: ben_ext_person.g_pl_attr_7 := null;
81: ben_ext_person.g_pl_attr_8 := null;
74: ben_ext_person.g_pl_attr_1 := null;
75: ben_ext_person.g_pl_attr_2 := null;
76: ben_ext_person.g_pl_attr_3 := null;
77: ben_ext_person.g_pl_attr_4 := null;
78: ben_ext_person.g_pl_attr_5 := null;
79: ben_ext_person.g_pl_attr_6 := null;
80: ben_ext_person.g_pl_attr_7 := null;
81: ben_ext_person.g_pl_attr_8 := null;
82: ben_ext_person.g_pl_attr_9 := null;
75: ben_ext_person.g_pl_attr_2 := null;
76: ben_ext_person.g_pl_attr_3 := null;
77: ben_ext_person.g_pl_attr_4 := null;
78: ben_ext_person.g_pl_attr_5 := null;
79: ben_ext_person.g_pl_attr_6 := null;
80: ben_ext_person.g_pl_attr_7 := null;
81: ben_ext_person.g_pl_attr_8 := null;
82: ben_ext_person.g_pl_attr_9 := null;
83: ben_ext_person.g_pl_attr_10 := null;
76: ben_ext_person.g_pl_attr_3 := null;
77: ben_ext_person.g_pl_attr_4 := null;
78: ben_ext_person.g_pl_attr_5 := null;
79: ben_ext_person.g_pl_attr_6 := null;
80: ben_ext_person.g_pl_attr_7 := null;
81: ben_ext_person.g_pl_attr_8 := null;
82: ben_ext_person.g_pl_attr_9 := null;
83: ben_ext_person.g_pl_attr_10 := null;
84: ben_ext_person.g_pgm_attr_1 := null;
77: ben_ext_person.g_pl_attr_4 := null;
78: ben_ext_person.g_pl_attr_5 := null;
79: ben_ext_person.g_pl_attr_6 := null;
80: ben_ext_person.g_pl_attr_7 := null;
81: ben_ext_person.g_pl_attr_8 := null;
82: ben_ext_person.g_pl_attr_9 := null;
83: ben_ext_person.g_pl_attr_10 := null;
84: ben_ext_person.g_pgm_attr_1 := null;
85: ben_ext_person.g_pgm_attr_2 := null;
78: ben_ext_person.g_pl_attr_5 := null;
79: ben_ext_person.g_pl_attr_6 := null;
80: ben_ext_person.g_pl_attr_7 := null;
81: ben_ext_person.g_pl_attr_8 := null;
82: ben_ext_person.g_pl_attr_9 := null;
83: ben_ext_person.g_pl_attr_10 := null;
84: ben_ext_person.g_pgm_attr_1 := null;
85: ben_ext_person.g_pgm_attr_2 := null;
86: ben_ext_person.g_pgm_attr_3 := null;
79: ben_ext_person.g_pl_attr_6 := null;
80: ben_ext_person.g_pl_attr_7 := null;
81: ben_ext_person.g_pl_attr_8 := null;
82: ben_ext_person.g_pl_attr_9 := null;
83: ben_ext_person.g_pl_attr_10 := null;
84: ben_ext_person.g_pgm_attr_1 := null;
85: ben_ext_person.g_pgm_attr_2 := null;
86: ben_ext_person.g_pgm_attr_3 := null;
87: ben_ext_person.g_pgm_attr_4 := null;
80: ben_ext_person.g_pl_attr_7 := null;
81: ben_ext_person.g_pl_attr_8 := null;
82: ben_ext_person.g_pl_attr_9 := null;
83: ben_ext_person.g_pl_attr_10 := null;
84: ben_ext_person.g_pgm_attr_1 := null;
85: ben_ext_person.g_pgm_attr_2 := null;
86: ben_ext_person.g_pgm_attr_3 := null;
87: ben_ext_person.g_pgm_attr_4 := null;
88: ben_ext_person.g_pgm_attr_5 := null;
81: ben_ext_person.g_pl_attr_8 := null;
82: ben_ext_person.g_pl_attr_9 := null;
83: ben_ext_person.g_pl_attr_10 := null;
84: ben_ext_person.g_pgm_attr_1 := null;
85: ben_ext_person.g_pgm_attr_2 := null;
86: ben_ext_person.g_pgm_attr_3 := null;
87: ben_ext_person.g_pgm_attr_4 := null;
88: ben_ext_person.g_pgm_attr_5 := null;
89: ben_ext_person.g_pgm_attr_6 := null;
82: ben_ext_person.g_pl_attr_9 := null;
83: ben_ext_person.g_pl_attr_10 := null;
84: ben_ext_person.g_pgm_attr_1 := null;
85: ben_ext_person.g_pgm_attr_2 := null;
86: ben_ext_person.g_pgm_attr_3 := null;
87: ben_ext_person.g_pgm_attr_4 := null;
88: ben_ext_person.g_pgm_attr_5 := null;
89: ben_ext_person.g_pgm_attr_6 := null;
90: ben_ext_person.g_pgm_attr_7 := null;
83: ben_ext_person.g_pl_attr_10 := null;
84: ben_ext_person.g_pgm_attr_1 := null;
85: ben_ext_person.g_pgm_attr_2 := null;
86: ben_ext_person.g_pgm_attr_3 := null;
87: ben_ext_person.g_pgm_attr_4 := null;
88: ben_ext_person.g_pgm_attr_5 := null;
89: ben_ext_person.g_pgm_attr_6 := null;
90: ben_ext_person.g_pgm_attr_7 := null;
91: ben_ext_person.g_pgm_attr_8 := null;
84: ben_ext_person.g_pgm_attr_1 := null;
85: ben_ext_person.g_pgm_attr_2 := null;
86: ben_ext_person.g_pgm_attr_3 := null;
87: ben_ext_person.g_pgm_attr_4 := null;
88: ben_ext_person.g_pgm_attr_5 := null;
89: ben_ext_person.g_pgm_attr_6 := null;
90: ben_ext_person.g_pgm_attr_7 := null;
91: ben_ext_person.g_pgm_attr_8 := null;
92: ben_ext_person.g_pgm_attr_9 := null;
85: ben_ext_person.g_pgm_attr_2 := null;
86: ben_ext_person.g_pgm_attr_3 := null;
87: ben_ext_person.g_pgm_attr_4 := null;
88: ben_ext_person.g_pgm_attr_5 := null;
89: ben_ext_person.g_pgm_attr_6 := null;
90: ben_ext_person.g_pgm_attr_7 := null;
91: ben_ext_person.g_pgm_attr_8 := null;
92: ben_ext_person.g_pgm_attr_9 := null;
93: ben_ext_person.g_pgm_attr_10 := null;
86: ben_ext_person.g_pgm_attr_3 := null;
87: ben_ext_person.g_pgm_attr_4 := null;
88: ben_ext_person.g_pgm_attr_5 := null;
89: ben_ext_person.g_pgm_attr_6 := null;
90: ben_ext_person.g_pgm_attr_7 := null;
91: ben_ext_person.g_pgm_attr_8 := null;
92: ben_ext_person.g_pgm_attr_9 := null;
93: ben_ext_person.g_pgm_attr_10 := null;
94: ben_ext_person.g_ptp_attr_1 := null;
87: ben_ext_person.g_pgm_attr_4 := null;
88: ben_ext_person.g_pgm_attr_5 := null;
89: ben_ext_person.g_pgm_attr_6 := null;
90: ben_ext_person.g_pgm_attr_7 := null;
91: ben_ext_person.g_pgm_attr_8 := null;
92: ben_ext_person.g_pgm_attr_9 := null;
93: ben_ext_person.g_pgm_attr_10 := null;
94: ben_ext_person.g_ptp_attr_1 := null;
95: ben_ext_person.g_ptp_attr_2 := null;
88: ben_ext_person.g_pgm_attr_5 := null;
89: ben_ext_person.g_pgm_attr_6 := null;
90: ben_ext_person.g_pgm_attr_7 := null;
91: ben_ext_person.g_pgm_attr_8 := null;
92: ben_ext_person.g_pgm_attr_9 := null;
93: ben_ext_person.g_pgm_attr_10 := null;
94: ben_ext_person.g_ptp_attr_1 := null;
95: ben_ext_person.g_ptp_attr_2 := null;
96: ben_ext_person.g_ptp_attr_3 := null;
89: ben_ext_person.g_pgm_attr_6 := null;
90: ben_ext_person.g_pgm_attr_7 := null;
91: ben_ext_person.g_pgm_attr_8 := null;
92: ben_ext_person.g_pgm_attr_9 := null;
93: ben_ext_person.g_pgm_attr_10 := null;
94: ben_ext_person.g_ptp_attr_1 := null;
95: ben_ext_person.g_ptp_attr_2 := null;
96: ben_ext_person.g_ptp_attr_3 := null;
97: ben_ext_person.g_ptp_attr_4 := null;
90: ben_ext_person.g_pgm_attr_7 := null;
91: ben_ext_person.g_pgm_attr_8 := null;
92: ben_ext_person.g_pgm_attr_9 := null;
93: ben_ext_person.g_pgm_attr_10 := null;
94: ben_ext_person.g_ptp_attr_1 := null;
95: ben_ext_person.g_ptp_attr_2 := null;
96: ben_ext_person.g_ptp_attr_3 := null;
97: ben_ext_person.g_ptp_attr_4 := null;
98: ben_ext_person.g_ptp_attr_5 := null;
91: ben_ext_person.g_pgm_attr_8 := null;
92: ben_ext_person.g_pgm_attr_9 := null;
93: ben_ext_person.g_pgm_attr_10 := null;
94: ben_ext_person.g_ptp_attr_1 := null;
95: ben_ext_person.g_ptp_attr_2 := null;
96: ben_ext_person.g_ptp_attr_3 := null;
97: ben_ext_person.g_ptp_attr_4 := null;
98: ben_ext_person.g_ptp_attr_5 := null;
99: ben_ext_person.g_ptp_attr_6 := null;
92: ben_ext_person.g_pgm_attr_9 := null;
93: ben_ext_person.g_pgm_attr_10 := null;
94: ben_ext_person.g_ptp_attr_1 := null;
95: ben_ext_person.g_ptp_attr_2 := null;
96: ben_ext_person.g_ptp_attr_3 := null;
97: ben_ext_person.g_ptp_attr_4 := null;
98: ben_ext_person.g_ptp_attr_5 := null;
99: ben_ext_person.g_ptp_attr_6 := null;
100: ben_ext_person.g_ptp_attr_7 := null;
93: ben_ext_person.g_pgm_attr_10 := null;
94: ben_ext_person.g_ptp_attr_1 := null;
95: ben_ext_person.g_ptp_attr_2 := null;
96: ben_ext_person.g_ptp_attr_3 := null;
97: ben_ext_person.g_ptp_attr_4 := null;
98: ben_ext_person.g_ptp_attr_5 := null;
99: ben_ext_person.g_ptp_attr_6 := null;
100: ben_ext_person.g_ptp_attr_7 := null;
101: ben_ext_person.g_ptp_attr_8 := null;
94: ben_ext_person.g_ptp_attr_1 := null;
95: ben_ext_person.g_ptp_attr_2 := null;
96: ben_ext_person.g_ptp_attr_3 := null;
97: ben_ext_person.g_ptp_attr_4 := null;
98: ben_ext_person.g_ptp_attr_5 := null;
99: ben_ext_person.g_ptp_attr_6 := null;
100: ben_ext_person.g_ptp_attr_7 := null;
101: ben_ext_person.g_ptp_attr_8 := null;
102: ben_ext_person.g_ptp_attr_9 := null;
95: ben_ext_person.g_ptp_attr_2 := null;
96: ben_ext_person.g_ptp_attr_3 := null;
97: ben_ext_person.g_ptp_attr_4 := null;
98: ben_ext_person.g_ptp_attr_5 := null;
99: ben_ext_person.g_ptp_attr_6 := null;
100: ben_ext_person.g_ptp_attr_7 := null;
101: ben_ext_person.g_ptp_attr_8 := null;
102: ben_ext_person.g_ptp_attr_9 := null;
103: ben_ext_person.g_ptp_attr_10 := null;
96: ben_ext_person.g_ptp_attr_3 := null;
97: ben_ext_person.g_ptp_attr_4 := null;
98: ben_ext_person.g_ptp_attr_5 := null;
99: ben_ext_person.g_ptp_attr_6 := null;
100: ben_ext_person.g_ptp_attr_7 := null;
101: ben_ext_person.g_ptp_attr_8 := null;
102: ben_ext_person.g_ptp_attr_9 := null;
103: ben_ext_person.g_ptp_attr_10 := null;
104: ben_ext_person.g_plip_attr_1 := null;
97: ben_ext_person.g_ptp_attr_4 := null;
98: ben_ext_person.g_ptp_attr_5 := null;
99: ben_ext_person.g_ptp_attr_6 := null;
100: ben_ext_person.g_ptp_attr_7 := null;
101: ben_ext_person.g_ptp_attr_8 := null;
102: ben_ext_person.g_ptp_attr_9 := null;
103: ben_ext_person.g_ptp_attr_10 := null;
104: ben_ext_person.g_plip_attr_1 := null;
105: ben_ext_person.g_plip_attr_2 := null;
98: ben_ext_person.g_ptp_attr_5 := null;
99: ben_ext_person.g_ptp_attr_6 := null;
100: ben_ext_person.g_ptp_attr_7 := null;
101: ben_ext_person.g_ptp_attr_8 := null;
102: ben_ext_person.g_ptp_attr_9 := null;
103: ben_ext_person.g_ptp_attr_10 := null;
104: ben_ext_person.g_plip_attr_1 := null;
105: ben_ext_person.g_plip_attr_2 := null;
106: ben_ext_person.g_plip_attr_3 := null;
99: ben_ext_person.g_ptp_attr_6 := null;
100: ben_ext_person.g_ptp_attr_7 := null;
101: ben_ext_person.g_ptp_attr_8 := null;
102: ben_ext_person.g_ptp_attr_9 := null;
103: ben_ext_person.g_ptp_attr_10 := null;
104: ben_ext_person.g_plip_attr_1 := null;
105: ben_ext_person.g_plip_attr_2 := null;
106: ben_ext_person.g_plip_attr_3 := null;
107: ben_ext_person.g_plip_attr_4 := null;
100: ben_ext_person.g_ptp_attr_7 := null;
101: ben_ext_person.g_ptp_attr_8 := null;
102: ben_ext_person.g_ptp_attr_9 := null;
103: ben_ext_person.g_ptp_attr_10 := null;
104: ben_ext_person.g_plip_attr_1 := null;
105: ben_ext_person.g_plip_attr_2 := null;
106: ben_ext_person.g_plip_attr_3 := null;
107: ben_ext_person.g_plip_attr_4 := null;
108: ben_ext_person.g_plip_attr_5 := null;
101: ben_ext_person.g_ptp_attr_8 := null;
102: ben_ext_person.g_ptp_attr_9 := null;
103: ben_ext_person.g_ptp_attr_10 := null;
104: ben_ext_person.g_plip_attr_1 := null;
105: ben_ext_person.g_plip_attr_2 := null;
106: ben_ext_person.g_plip_attr_3 := null;
107: ben_ext_person.g_plip_attr_4 := null;
108: ben_ext_person.g_plip_attr_5 := null;
109: ben_ext_person.g_plip_attr_6 := null;
102: ben_ext_person.g_ptp_attr_9 := null;
103: ben_ext_person.g_ptp_attr_10 := null;
104: ben_ext_person.g_plip_attr_1 := null;
105: ben_ext_person.g_plip_attr_2 := null;
106: ben_ext_person.g_plip_attr_3 := null;
107: ben_ext_person.g_plip_attr_4 := null;
108: ben_ext_person.g_plip_attr_5 := null;
109: ben_ext_person.g_plip_attr_6 := null;
110: ben_ext_person.g_plip_attr_7 := null;
103: ben_ext_person.g_ptp_attr_10 := null;
104: ben_ext_person.g_plip_attr_1 := null;
105: ben_ext_person.g_plip_attr_2 := null;
106: ben_ext_person.g_plip_attr_3 := null;
107: ben_ext_person.g_plip_attr_4 := null;
108: ben_ext_person.g_plip_attr_5 := null;
109: ben_ext_person.g_plip_attr_6 := null;
110: ben_ext_person.g_plip_attr_7 := null;
111: ben_ext_person.g_plip_attr_8 := null;
104: ben_ext_person.g_plip_attr_1 := null;
105: ben_ext_person.g_plip_attr_2 := null;
106: ben_ext_person.g_plip_attr_3 := null;
107: ben_ext_person.g_plip_attr_4 := null;
108: ben_ext_person.g_plip_attr_5 := null;
109: ben_ext_person.g_plip_attr_6 := null;
110: ben_ext_person.g_plip_attr_7 := null;
111: ben_ext_person.g_plip_attr_8 := null;
112: ben_ext_person.g_plip_attr_9 := null;
105: ben_ext_person.g_plip_attr_2 := null;
106: ben_ext_person.g_plip_attr_3 := null;
107: ben_ext_person.g_plip_attr_4 := null;
108: ben_ext_person.g_plip_attr_5 := null;
109: ben_ext_person.g_plip_attr_6 := null;
110: ben_ext_person.g_plip_attr_7 := null;
111: ben_ext_person.g_plip_attr_8 := null;
112: ben_ext_person.g_plip_attr_9 := null;
113: ben_ext_person.g_plip_attr_10 := null;
106: ben_ext_person.g_plip_attr_3 := null;
107: ben_ext_person.g_plip_attr_4 := null;
108: ben_ext_person.g_plip_attr_5 := null;
109: ben_ext_person.g_plip_attr_6 := null;
110: ben_ext_person.g_plip_attr_7 := null;
111: ben_ext_person.g_plip_attr_8 := null;
112: ben_ext_person.g_plip_attr_9 := null;
113: ben_ext_person.g_plip_attr_10 := null;
114: ben_ext_person.g_oipl_attr_1 := null;
107: ben_ext_person.g_plip_attr_4 := null;
108: ben_ext_person.g_plip_attr_5 := null;
109: ben_ext_person.g_plip_attr_6 := null;
110: ben_ext_person.g_plip_attr_7 := null;
111: ben_ext_person.g_plip_attr_8 := null;
112: ben_ext_person.g_plip_attr_9 := null;
113: ben_ext_person.g_plip_attr_10 := null;
114: ben_ext_person.g_oipl_attr_1 := null;
115: ben_ext_person.g_oipl_attr_2 := null;
108: ben_ext_person.g_plip_attr_5 := null;
109: ben_ext_person.g_plip_attr_6 := null;
110: ben_ext_person.g_plip_attr_7 := null;
111: ben_ext_person.g_plip_attr_8 := null;
112: ben_ext_person.g_plip_attr_9 := null;
113: ben_ext_person.g_plip_attr_10 := null;
114: ben_ext_person.g_oipl_attr_1 := null;
115: ben_ext_person.g_oipl_attr_2 := null;
116: ben_ext_person.g_oipl_attr_3 := null;
109: ben_ext_person.g_plip_attr_6 := null;
110: ben_ext_person.g_plip_attr_7 := null;
111: ben_ext_person.g_plip_attr_8 := null;
112: ben_ext_person.g_plip_attr_9 := null;
113: ben_ext_person.g_plip_attr_10 := null;
114: ben_ext_person.g_oipl_attr_1 := null;
115: ben_ext_person.g_oipl_attr_2 := null;
116: ben_ext_person.g_oipl_attr_3 := null;
117: ben_ext_person.g_oipl_attr_4 := null;
110: ben_ext_person.g_plip_attr_7 := null;
111: ben_ext_person.g_plip_attr_8 := null;
112: ben_ext_person.g_plip_attr_9 := null;
113: ben_ext_person.g_plip_attr_10 := null;
114: ben_ext_person.g_oipl_attr_1 := null;
115: ben_ext_person.g_oipl_attr_2 := null;
116: ben_ext_person.g_oipl_attr_3 := null;
117: ben_ext_person.g_oipl_attr_4 := null;
118: ben_ext_person.g_oipl_attr_5 := null;
111: ben_ext_person.g_plip_attr_8 := null;
112: ben_ext_person.g_plip_attr_9 := null;
113: ben_ext_person.g_plip_attr_10 := null;
114: ben_ext_person.g_oipl_attr_1 := null;
115: ben_ext_person.g_oipl_attr_2 := null;
116: ben_ext_person.g_oipl_attr_3 := null;
117: ben_ext_person.g_oipl_attr_4 := null;
118: ben_ext_person.g_oipl_attr_5 := null;
119: ben_ext_person.g_oipl_attr_6 := null;
112: ben_ext_person.g_plip_attr_9 := null;
113: ben_ext_person.g_plip_attr_10 := null;
114: ben_ext_person.g_oipl_attr_1 := null;
115: ben_ext_person.g_oipl_attr_2 := null;
116: ben_ext_person.g_oipl_attr_3 := null;
117: ben_ext_person.g_oipl_attr_4 := null;
118: ben_ext_person.g_oipl_attr_5 := null;
119: ben_ext_person.g_oipl_attr_6 := null;
120: ben_ext_person.g_oipl_attr_7 := null;
113: ben_ext_person.g_plip_attr_10 := null;
114: ben_ext_person.g_oipl_attr_1 := null;
115: ben_ext_person.g_oipl_attr_2 := null;
116: ben_ext_person.g_oipl_attr_3 := null;
117: ben_ext_person.g_oipl_attr_4 := null;
118: ben_ext_person.g_oipl_attr_5 := null;
119: ben_ext_person.g_oipl_attr_6 := null;
120: ben_ext_person.g_oipl_attr_7 := null;
121: ben_ext_person.g_oipl_attr_8 := null;
114: ben_ext_person.g_oipl_attr_1 := null;
115: ben_ext_person.g_oipl_attr_2 := null;
116: ben_ext_person.g_oipl_attr_3 := null;
117: ben_ext_person.g_oipl_attr_4 := null;
118: ben_ext_person.g_oipl_attr_5 := null;
119: ben_ext_person.g_oipl_attr_6 := null;
120: ben_ext_person.g_oipl_attr_7 := null;
121: ben_ext_person.g_oipl_attr_8 := null;
122: ben_ext_person.g_oipl_attr_9 := null;
115: ben_ext_person.g_oipl_attr_2 := null;
116: ben_ext_person.g_oipl_attr_3 := null;
117: ben_ext_person.g_oipl_attr_4 := null;
118: ben_ext_person.g_oipl_attr_5 := null;
119: ben_ext_person.g_oipl_attr_6 := null;
120: ben_ext_person.g_oipl_attr_7 := null;
121: ben_ext_person.g_oipl_attr_8 := null;
122: ben_ext_person.g_oipl_attr_9 := null;
123: ben_ext_person.g_oipl_attr_10 := null;
116: ben_ext_person.g_oipl_attr_3 := null;
117: ben_ext_person.g_oipl_attr_4 := null;
118: ben_ext_person.g_oipl_attr_5 := null;
119: ben_ext_person.g_oipl_attr_6 := null;
120: ben_ext_person.g_oipl_attr_7 := null;
121: ben_ext_person.g_oipl_attr_8 := null;
122: ben_ext_person.g_oipl_attr_9 := null;
123: ben_ext_person.g_oipl_attr_10 := null;
124: ben_ext_person.g_opt_attr_1 := null;
117: ben_ext_person.g_oipl_attr_4 := null;
118: ben_ext_person.g_oipl_attr_5 := null;
119: ben_ext_person.g_oipl_attr_6 := null;
120: ben_ext_person.g_oipl_attr_7 := null;
121: ben_ext_person.g_oipl_attr_8 := null;
122: ben_ext_person.g_oipl_attr_9 := null;
123: ben_ext_person.g_oipl_attr_10 := null;
124: ben_ext_person.g_opt_attr_1 := null;
125: ben_ext_person.g_opt_attr_2 := null;
118: ben_ext_person.g_oipl_attr_5 := null;
119: ben_ext_person.g_oipl_attr_6 := null;
120: ben_ext_person.g_oipl_attr_7 := null;
121: ben_ext_person.g_oipl_attr_8 := null;
122: ben_ext_person.g_oipl_attr_9 := null;
123: ben_ext_person.g_oipl_attr_10 := null;
124: ben_ext_person.g_opt_attr_1 := null;
125: ben_ext_person.g_opt_attr_2 := null;
126: ben_ext_person.g_opt_attr_3 := null;
119: ben_ext_person.g_oipl_attr_6 := null;
120: ben_ext_person.g_oipl_attr_7 := null;
121: ben_ext_person.g_oipl_attr_8 := null;
122: ben_ext_person.g_oipl_attr_9 := null;
123: ben_ext_person.g_oipl_attr_10 := null;
124: ben_ext_person.g_opt_attr_1 := null;
125: ben_ext_person.g_opt_attr_2 := null;
126: ben_ext_person.g_opt_attr_3 := null;
127: ben_ext_person.g_opt_attr_4 := null;
120: ben_ext_person.g_oipl_attr_7 := null;
121: ben_ext_person.g_oipl_attr_8 := null;
122: ben_ext_person.g_oipl_attr_9 := null;
123: ben_ext_person.g_oipl_attr_10 := null;
124: ben_ext_person.g_opt_attr_1 := null;
125: ben_ext_person.g_opt_attr_2 := null;
126: ben_ext_person.g_opt_attr_3 := null;
127: ben_ext_person.g_opt_attr_4 := null;
128: ben_ext_person.g_opt_attr_5 := null;
121: ben_ext_person.g_oipl_attr_8 := null;
122: ben_ext_person.g_oipl_attr_9 := null;
123: ben_ext_person.g_oipl_attr_10 := null;
124: ben_ext_person.g_opt_attr_1 := null;
125: ben_ext_person.g_opt_attr_2 := null;
126: ben_ext_person.g_opt_attr_3 := null;
127: ben_ext_person.g_opt_attr_4 := null;
128: ben_ext_person.g_opt_attr_5 := null;
129: ben_ext_person.g_opt_attr_6 := null;
122: ben_ext_person.g_oipl_attr_9 := null;
123: ben_ext_person.g_oipl_attr_10 := null;
124: ben_ext_person.g_opt_attr_1 := null;
125: ben_ext_person.g_opt_attr_2 := null;
126: ben_ext_person.g_opt_attr_3 := null;
127: ben_ext_person.g_opt_attr_4 := null;
128: ben_ext_person.g_opt_attr_5 := null;
129: ben_ext_person.g_opt_attr_6 := null;
130: ben_ext_person.g_opt_attr_7 := null;
123: ben_ext_person.g_oipl_attr_10 := null;
124: ben_ext_person.g_opt_attr_1 := null;
125: ben_ext_person.g_opt_attr_2 := null;
126: ben_ext_person.g_opt_attr_3 := null;
127: ben_ext_person.g_opt_attr_4 := null;
128: ben_ext_person.g_opt_attr_5 := null;
129: ben_ext_person.g_opt_attr_6 := null;
130: ben_ext_person.g_opt_attr_7 := null;
131: ben_ext_person.g_opt_attr_8 := null;
124: ben_ext_person.g_opt_attr_1 := null;
125: ben_ext_person.g_opt_attr_2 := null;
126: ben_ext_person.g_opt_attr_3 := null;
127: ben_ext_person.g_opt_attr_4 := null;
128: ben_ext_person.g_opt_attr_5 := null;
129: ben_ext_person.g_opt_attr_6 := null;
130: ben_ext_person.g_opt_attr_7 := null;
131: ben_ext_person.g_opt_attr_8 := null;
132: ben_ext_person.g_opt_attr_9 := null;
125: ben_ext_person.g_opt_attr_2 := null;
126: ben_ext_person.g_opt_attr_3 := null;
127: ben_ext_person.g_opt_attr_4 := null;
128: ben_ext_person.g_opt_attr_5 := null;
129: ben_ext_person.g_opt_attr_6 := null;
130: ben_ext_person.g_opt_attr_7 := null;
131: ben_ext_person.g_opt_attr_8 := null;
132: ben_ext_person.g_opt_attr_9 := null;
133: ben_ext_person.g_opt_attr_10 := null;
126: ben_ext_person.g_opt_attr_3 := null;
127: ben_ext_person.g_opt_attr_4 := null;
128: ben_ext_person.g_opt_attr_5 := null;
129: ben_ext_person.g_opt_attr_6 := null;
130: ben_ext_person.g_opt_attr_7 := null;
131: ben_ext_person.g_opt_attr_8 := null;
132: ben_ext_person.g_opt_attr_9 := null;
133: ben_ext_person.g_opt_attr_10 := null;
134: ben_ext_person.g_enrt_plcy_r_grp := null;
127: ben_ext_person.g_opt_attr_4 := null;
128: ben_ext_person.g_opt_attr_5 := null;
129: ben_ext_person.g_opt_attr_6 := null;
130: ben_ext_person.g_opt_attr_7 := null;
131: ben_ext_person.g_opt_attr_8 := null;
132: ben_ext_person.g_opt_attr_9 := null;
133: ben_ext_person.g_opt_attr_10 := null;
134: ben_ext_person.g_enrt_plcy_r_grp := null;
135: ben_ext_person.g_ppr_name := null;
128: ben_ext_person.g_opt_attr_5 := null;
129: ben_ext_person.g_opt_attr_6 := null;
130: ben_ext_person.g_opt_attr_7 := null;
131: ben_ext_person.g_opt_attr_8 := null;
132: ben_ext_person.g_opt_attr_9 := null;
133: ben_ext_person.g_opt_attr_10 := null;
134: ben_ext_person.g_enrt_plcy_r_grp := null;
135: ben_ext_person.g_ppr_name := null;
136: ben_ext_person.g_ppr_ident := null;
129: ben_ext_person.g_opt_attr_6 := null;
130: ben_ext_person.g_opt_attr_7 := null;
131: ben_ext_person.g_opt_attr_8 := null;
132: ben_ext_person.g_opt_attr_9 := null;
133: ben_ext_person.g_opt_attr_10 := null;
134: ben_ext_person.g_enrt_plcy_r_grp := null;
135: ben_ext_person.g_ppr_name := null;
136: ben_ext_person.g_ppr_ident := null;
137: ben_ext_person.g_ppr_typ := null;
130: ben_ext_person.g_opt_attr_7 := null;
131: ben_ext_person.g_opt_attr_8 := null;
132: ben_ext_person.g_opt_attr_9 := null;
133: ben_ext_person.g_opt_attr_10 := null;
134: ben_ext_person.g_enrt_plcy_r_grp := null;
135: ben_ext_person.g_ppr_name := null;
136: ben_ext_person.g_ppr_ident := null;
137: ben_ext_person.g_ppr_typ := null;
138: ben_ext_person.g_ppr_strt_dt := null;
131: ben_ext_person.g_opt_attr_8 := null;
132: ben_ext_person.g_opt_attr_9 := null;
133: ben_ext_person.g_opt_attr_10 := null;
134: ben_ext_person.g_enrt_plcy_r_grp := null;
135: ben_ext_person.g_ppr_name := null;
136: ben_ext_person.g_ppr_ident := null;
137: ben_ext_person.g_ppr_typ := null;
138: ben_ext_person.g_ppr_strt_dt := null;
139: ben_ext_person.g_ppr_end_dt := null;
132: ben_ext_person.g_opt_attr_9 := null;
133: ben_ext_person.g_opt_attr_10 := null;
134: ben_ext_person.g_enrt_plcy_r_grp := null;
135: ben_ext_person.g_ppr_name := null;
136: ben_ext_person.g_ppr_ident := null;
137: ben_ext_person.g_ppr_typ := null;
138: ben_ext_person.g_ppr_strt_dt := null;
139: ben_ext_person.g_ppr_end_dt := null;
140: ben_ext_person.g_enrt_lfevt_name := null;
133: ben_ext_person.g_opt_attr_10 := null;
134: ben_ext_person.g_enrt_plcy_r_grp := null;
135: ben_ext_person.g_ppr_name := null;
136: ben_ext_person.g_ppr_ident := null;
137: ben_ext_person.g_ppr_typ := null;
138: ben_ext_person.g_ppr_strt_dt := null;
139: ben_ext_person.g_ppr_end_dt := null;
140: ben_ext_person.g_enrt_lfevt_name := null;
141: ben_ext_person.g_enrt_lfevt_status := null;
134: ben_ext_person.g_enrt_plcy_r_grp := null;
135: ben_ext_person.g_ppr_name := null;
136: ben_ext_person.g_ppr_ident := null;
137: ben_ext_person.g_ppr_typ := null;
138: ben_ext_person.g_ppr_strt_dt := null;
139: ben_ext_person.g_ppr_end_dt := null;
140: ben_ext_person.g_enrt_lfevt_name := null;
141: ben_ext_person.g_enrt_lfevt_status := null;
142: ben_ext_person.g_enrt_lfevt_note_dt := null;
135: ben_ext_person.g_ppr_name := null;
136: ben_ext_person.g_ppr_ident := null;
137: ben_ext_person.g_ppr_typ := null;
138: ben_ext_person.g_ppr_strt_dt := null;
139: ben_ext_person.g_ppr_end_dt := null;
140: ben_ext_person.g_enrt_lfevt_name := null;
141: ben_ext_person.g_enrt_lfevt_status := null;
142: ben_ext_person.g_enrt_lfevt_note_dt := null;
143: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
136: ben_ext_person.g_ppr_ident := null;
137: ben_ext_person.g_ppr_typ := null;
138: ben_ext_person.g_ppr_strt_dt := null;
139: ben_ext_person.g_ppr_end_dt := null;
140: ben_ext_person.g_enrt_lfevt_name := null;
141: ben_ext_person.g_enrt_lfevt_status := null;
142: ben_ext_person.g_enrt_lfevt_note_dt := null;
143: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
144: --
137: ben_ext_person.g_ppr_typ := null;
138: ben_ext_person.g_ppr_strt_dt := null;
139: ben_ext_person.g_ppr_end_dt := null;
140: ben_ext_person.g_enrt_lfevt_name := null;
141: ben_ext_person.g_enrt_lfevt_status := null;
142: ben_ext_person.g_enrt_lfevt_note_dt := null;
143: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
144: --
145: ben_ext_person.g_enrt_pl_fd_name := null;
138: ben_ext_person.g_ppr_strt_dt := null;
139: ben_ext_person.g_ppr_end_dt := null;
140: ben_ext_person.g_enrt_lfevt_name := null;
141: ben_ext_person.g_enrt_lfevt_status := null;
142: ben_ext_person.g_enrt_lfevt_note_dt := null;
143: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
144: --
145: ben_ext_person.g_enrt_pl_fd_name := null;
146: ben_ext_person.g_enrt_pl_fd_code := null;
139: ben_ext_person.g_ppr_end_dt := null;
140: ben_ext_person.g_enrt_lfevt_name := null;
141: ben_ext_person.g_enrt_lfevt_status := null;
142: ben_ext_person.g_enrt_lfevt_note_dt := null;
143: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
144: --
145: ben_ext_person.g_enrt_pl_fd_name := null;
146: ben_ext_person.g_enrt_pl_fd_code := null;
147: ben_ext_person.g_enrt_pgm_fd_name := null;
141: ben_ext_person.g_enrt_lfevt_status := null;
142: ben_ext_person.g_enrt_lfevt_note_dt := null;
143: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
144: --
145: ben_ext_person.g_enrt_pl_fd_name := null;
146: ben_ext_person.g_enrt_pl_fd_code := null;
147: ben_ext_person.g_enrt_pgm_fd_name := null;
148: ben_ext_person.g_enrt_pgm_fd_code := null;
149: ben_ext_person.g_enrt_pl_typ_fd_name := null;
142: ben_ext_person.g_enrt_lfevt_note_dt := null;
143: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
144: --
145: ben_ext_person.g_enrt_pl_fd_name := null;
146: ben_ext_person.g_enrt_pl_fd_code := null;
147: ben_ext_person.g_enrt_pgm_fd_name := null;
148: ben_ext_person.g_enrt_pgm_fd_code := null;
149: ben_ext_person.g_enrt_pl_typ_fd_name := null;
150: ben_ext_person.g_enrt_pl_typ_fd_code := null;
143: ben_ext_person.g_enrt_lfevt_ocrd_dt := null;
144: --
145: ben_ext_person.g_enrt_pl_fd_name := null;
146: ben_ext_person.g_enrt_pl_fd_code := null;
147: ben_ext_person.g_enrt_pgm_fd_name := null;
148: ben_ext_person.g_enrt_pgm_fd_code := null;
149: ben_ext_person.g_enrt_pl_typ_fd_name := null;
150: ben_ext_person.g_enrt_pl_typ_fd_code := null;
151: ben_ext_person.g_enrt_opt_fd_name := null;
144: --
145: ben_ext_person.g_enrt_pl_fd_name := null;
146: ben_ext_person.g_enrt_pl_fd_code := null;
147: ben_ext_person.g_enrt_pgm_fd_name := null;
148: ben_ext_person.g_enrt_pgm_fd_code := null;
149: ben_ext_person.g_enrt_pl_typ_fd_name := null;
150: ben_ext_person.g_enrt_pl_typ_fd_code := null;
151: ben_ext_person.g_enrt_opt_fd_name := null;
152: ben_ext_person.g_enrt_opt_fd_code := null;
145: ben_ext_person.g_enrt_pl_fd_name := null;
146: ben_ext_person.g_enrt_pl_fd_code := null;
147: ben_ext_person.g_enrt_pgm_fd_name := null;
148: ben_ext_person.g_enrt_pgm_fd_code := null;
149: ben_ext_person.g_enrt_pl_typ_fd_name := null;
150: ben_ext_person.g_enrt_pl_typ_fd_code := null;
151: ben_ext_person.g_enrt_opt_fd_name := null;
152: ben_ext_person.g_enrt_opt_fd_code := null;
153: ben_ext_person.g_enrt_opt_pl_fd_name := null;
146: ben_ext_person.g_enrt_pl_fd_code := null;
147: ben_ext_person.g_enrt_pgm_fd_name := null;
148: ben_ext_person.g_enrt_pgm_fd_code := null;
149: ben_ext_person.g_enrt_pl_typ_fd_name := null;
150: ben_ext_person.g_enrt_pl_typ_fd_code := null;
151: ben_ext_person.g_enrt_opt_fd_name := null;
152: ben_ext_person.g_enrt_opt_fd_code := null;
153: ben_ext_person.g_enrt_opt_pl_fd_name := null;
154: ben_ext_person.g_enrt_opt_pl_fd_code := null;
147: ben_ext_person.g_enrt_pgm_fd_name := null;
148: ben_ext_person.g_enrt_pgm_fd_code := null;
149: ben_ext_person.g_enrt_pl_typ_fd_name := null;
150: ben_ext_person.g_enrt_pl_typ_fd_code := null;
151: ben_ext_person.g_enrt_opt_fd_name := null;
152: ben_ext_person.g_enrt_opt_fd_code := null;
153: ben_ext_person.g_enrt_opt_pl_fd_name := null;
154: ben_ext_person.g_enrt_opt_pl_fd_code := null;
155: ben_ext_person.g_enrt_pl_pgm_fd_name := null;
148: ben_ext_person.g_enrt_pgm_fd_code := null;
149: ben_ext_person.g_enrt_pl_typ_fd_name := null;
150: ben_ext_person.g_enrt_pl_typ_fd_code := null;
151: ben_ext_person.g_enrt_opt_fd_name := null;
152: ben_ext_person.g_enrt_opt_fd_code := null;
153: ben_ext_person.g_enrt_opt_pl_fd_name := null;
154: ben_ext_person.g_enrt_opt_pl_fd_code := null;
155: ben_ext_person.g_enrt_pl_pgm_fd_name := null;
156: ben_ext_person.g_enrt_pl_pgm_fd_code := null;
149: ben_ext_person.g_enrt_pl_typ_fd_name := null;
150: ben_ext_person.g_enrt_pl_typ_fd_code := null;
151: ben_ext_person.g_enrt_opt_fd_name := null;
152: ben_ext_person.g_enrt_opt_fd_code := null;
153: ben_ext_person.g_enrt_opt_pl_fd_name := null;
154: ben_ext_person.g_enrt_opt_pl_fd_code := null;
155: ben_ext_person.g_enrt_pl_pgm_fd_name := null;
156: ben_ext_person.g_enrt_pl_pgm_fd_code := null;
157: ben_ext_person.g_enrt_pl_typ_pgm_fd_name := null;
150: ben_ext_person.g_enrt_pl_typ_fd_code := null;
151: ben_ext_person.g_enrt_opt_fd_name := null;
152: ben_ext_person.g_enrt_opt_fd_code := null;
153: ben_ext_person.g_enrt_opt_pl_fd_name := null;
154: ben_ext_person.g_enrt_opt_pl_fd_code := null;
155: ben_ext_person.g_enrt_pl_pgm_fd_name := null;
156: ben_ext_person.g_enrt_pl_pgm_fd_code := null;
157: ben_ext_person.g_enrt_pl_typ_pgm_fd_name := null;
158: ben_ext_person.g_enrt_pl_typ_pgm_fd_code := null;
151: ben_ext_person.g_enrt_opt_fd_name := null;
152: ben_ext_person.g_enrt_opt_fd_code := null;
153: ben_ext_person.g_enrt_opt_pl_fd_name := null;
154: ben_ext_person.g_enrt_opt_pl_fd_code := null;
155: ben_ext_person.g_enrt_pl_pgm_fd_name := null;
156: ben_ext_person.g_enrt_pl_pgm_fd_code := null;
157: ben_ext_person.g_enrt_pl_typ_pgm_fd_name := null;
158: ben_ext_person.g_enrt_pl_typ_pgm_fd_code := null;
159:
152: ben_ext_person.g_enrt_opt_fd_code := null;
153: ben_ext_person.g_enrt_opt_pl_fd_name := null;
154: ben_ext_person.g_enrt_opt_pl_fd_code := null;
155: ben_ext_person.g_enrt_pl_pgm_fd_name := null;
156: ben_ext_person.g_enrt_pl_pgm_fd_code := null;
157: ben_ext_person.g_enrt_pl_typ_pgm_fd_name := null;
158: ben_ext_person.g_enrt_pl_typ_pgm_fd_code := null;
159:
160:
153: ben_ext_person.g_enrt_opt_pl_fd_name := null;
154: ben_ext_person.g_enrt_opt_pl_fd_code := null;
155: ben_ext_person.g_enrt_pl_pgm_fd_name := null;
156: ben_ext_person.g_enrt_pl_pgm_fd_code := null;
157: ben_ext_person.g_enrt_pl_typ_pgm_fd_name := null;
158: ben_ext_person.g_enrt_pl_typ_pgm_fd_code := null;
159:
160:
161:
154: ben_ext_person.g_enrt_opt_pl_fd_code := null;
155: ben_ext_person.g_enrt_pl_pgm_fd_name := null;
156: ben_ext_person.g_enrt_pl_pgm_fd_code := null;
157: ben_ext_person.g_enrt_pl_typ_pgm_fd_name := null;
158: ben_ext_person.g_enrt_pl_typ_pgm_fd_code := null;
159:
160:
161:
162: hr_utility.set_location('Exiting'||l_proc, 15);
175: Begin
176: --
177: hr_utility.set_location('Entering'||l_proc, 5);
178: --
179: ben_ext_person.g_ee_pre_tax_cost := null;
180: ben_ext_person.g_ee_after_tax_cost := null;
181: ben_ext_person.g_ee_ttl_cost := null;
182: ben_ext_person.g_er_ttl_cost := null;
183: ben_ext_person.g_ee_ttl_distribution := null;
176: --
177: hr_utility.set_location('Entering'||l_proc, 5);
178: --
179: ben_ext_person.g_ee_pre_tax_cost := null;
180: ben_ext_person.g_ee_after_tax_cost := null;
181: ben_ext_person.g_ee_ttl_cost := null;
182: ben_ext_person.g_er_ttl_cost := null;
183: ben_ext_person.g_ee_ttl_distribution := null;
184: ben_ext_person.g_er_ttl_distribution := null;
177: hr_utility.set_location('Entering'||l_proc, 5);
178: --
179: ben_ext_person.g_ee_pre_tax_cost := null;
180: ben_ext_person.g_ee_after_tax_cost := null;
181: ben_ext_person.g_ee_ttl_cost := null;
182: ben_ext_person.g_er_ttl_cost := null;
183: ben_ext_person.g_ee_ttl_distribution := null;
184: ben_ext_person.g_er_ttl_distribution := null;
185: ben_ext_person.g_ttl_other_rate := null;
178: --
179: ben_ext_person.g_ee_pre_tax_cost := null;
180: ben_ext_person.g_ee_after_tax_cost := null;
181: ben_ext_person.g_ee_ttl_cost := null;
182: ben_ext_person.g_er_ttl_cost := null;
183: ben_ext_person.g_ee_ttl_distribution := null;
184: ben_ext_person.g_er_ttl_distribution := null;
185: ben_ext_person.g_ttl_other_rate := null;
186: ben_ext_person.g_pev_ee_pre_tax_contr := null;
179: ben_ext_person.g_ee_pre_tax_cost := null;
180: ben_ext_person.g_ee_after_tax_cost := null;
181: ben_ext_person.g_ee_ttl_cost := null;
182: ben_ext_person.g_er_ttl_cost := null;
183: ben_ext_person.g_ee_ttl_distribution := null;
184: ben_ext_person.g_er_ttl_distribution := null;
185: ben_ext_person.g_ttl_other_rate := null;
186: ben_ext_person.g_pev_ee_pre_tax_contr := null;
187: ben_ext_person.g_pev_ee_after_tax_contr := null;
180: ben_ext_person.g_ee_after_tax_cost := null;
181: ben_ext_person.g_ee_ttl_cost := null;
182: ben_ext_person.g_er_ttl_cost := null;
183: ben_ext_person.g_ee_ttl_distribution := null;
184: ben_ext_person.g_er_ttl_distribution := null;
185: ben_ext_person.g_ttl_other_rate := null;
186: ben_ext_person.g_pev_ee_pre_tax_contr := null;
187: ben_ext_person.g_pev_ee_after_tax_contr := null;
188: ben_ext_person.g_pev_ee_ttl_contr := null;
181: ben_ext_person.g_ee_ttl_cost := null;
182: ben_ext_person.g_er_ttl_cost := null;
183: ben_ext_person.g_ee_ttl_distribution := null;
184: ben_ext_person.g_er_ttl_distribution := null;
185: ben_ext_person.g_ttl_other_rate := null;
186: ben_ext_person.g_pev_ee_pre_tax_contr := null;
187: ben_ext_person.g_pev_ee_after_tax_contr := null;
188: ben_ext_person.g_pev_ee_ttl_contr := null;
189: ben_ext_person.g_pev_er_ttl_contr := null;
182: ben_ext_person.g_er_ttl_cost := null;
183: ben_ext_person.g_ee_ttl_distribution := null;
184: ben_ext_person.g_er_ttl_distribution := null;
185: ben_ext_person.g_ttl_other_rate := null;
186: ben_ext_person.g_pev_ee_pre_tax_contr := null;
187: ben_ext_person.g_pev_ee_after_tax_contr := null;
188: ben_ext_person.g_pev_ee_ttl_contr := null;
189: ben_ext_person.g_pev_er_ttl_contr := null;
190: ben_ext_person.g_pev_ee_ttl_distribution := null;
183: ben_ext_person.g_ee_ttl_distribution := null;
184: ben_ext_person.g_er_ttl_distribution := null;
185: ben_ext_person.g_ttl_other_rate := null;
186: ben_ext_person.g_pev_ee_pre_tax_contr := null;
187: ben_ext_person.g_pev_ee_after_tax_contr := null;
188: ben_ext_person.g_pev_ee_ttl_contr := null;
189: ben_ext_person.g_pev_er_ttl_contr := null;
190: ben_ext_person.g_pev_ee_ttl_distribution := null;
191: ben_ext_person.g_pev_er_ttl_distribution := null;
184: ben_ext_person.g_er_ttl_distribution := null;
185: ben_ext_person.g_ttl_other_rate := null;
186: ben_ext_person.g_pev_ee_pre_tax_contr := null;
187: ben_ext_person.g_pev_ee_after_tax_contr := null;
188: ben_ext_person.g_pev_ee_ttl_contr := null;
189: ben_ext_person.g_pev_er_ttl_contr := null;
190: ben_ext_person.g_pev_ee_ttl_distribution := null;
191: ben_ext_person.g_pev_er_ttl_distribution := null;
192: ben_ext_person.g_pev_ttl_other_rate := null;
185: ben_ext_person.g_ttl_other_rate := null;
186: ben_ext_person.g_pev_ee_pre_tax_contr := null;
187: ben_ext_person.g_pev_ee_after_tax_contr := null;
188: ben_ext_person.g_pev_ee_ttl_contr := null;
189: ben_ext_person.g_pev_er_ttl_contr := null;
190: ben_ext_person.g_pev_ee_ttl_distribution := null;
191: ben_ext_person.g_pev_er_ttl_distribution := null;
192: ben_ext_person.g_pev_ttl_other_rate := null;
193: ---cwb 2832419
186: ben_ext_person.g_pev_ee_pre_tax_contr := null;
187: ben_ext_person.g_pev_ee_after_tax_contr := null;
188: ben_ext_person.g_pev_ee_ttl_contr := null;
189: ben_ext_person.g_pev_er_ttl_contr := null;
190: ben_ext_person.g_pev_ee_ttl_distribution := null;
191: ben_ext_person.g_pev_er_ttl_distribution := null;
192: ben_ext_person.g_pev_ttl_other_rate := null;
193: ---cwb 2832419
194: ben_ext_person.g_er_cwb_dst_bdgt := null ;
187: ben_ext_person.g_pev_ee_after_tax_contr := null;
188: ben_ext_person.g_pev_ee_ttl_contr := null;
189: ben_ext_person.g_pev_er_ttl_contr := null;
190: ben_ext_person.g_pev_ee_ttl_distribution := null;
191: ben_ext_person.g_pev_er_ttl_distribution := null;
192: ben_ext_person.g_pev_ttl_other_rate := null;
193: ---cwb 2832419
194: ben_ext_person.g_er_cwb_dst_bdgt := null ;
195: ben_ext_person.g_er_cwb_misc_rate_1 := null ;
188: ben_ext_person.g_pev_ee_ttl_contr := null;
189: ben_ext_person.g_pev_er_ttl_contr := null;
190: ben_ext_person.g_pev_ee_ttl_distribution := null;
191: ben_ext_person.g_pev_er_ttl_distribution := null;
192: ben_ext_person.g_pev_ttl_other_rate := null;
193: ---cwb 2832419
194: ben_ext_person.g_er_cwb_dst_bdgt := null ;
195: ben_ext_person.g_er_cwb_misc_rate_1 := null ;
196: ben_ext_person.g_er_cwb_elig_salary := null ;
190: ben_ext_person.g_pev_ee_ttl_distribution := null;
191: ben_ext_person.g_pev_er_ttl_distribution := null;
192: ben_ext_person.g_pev_ttl_other_rate := null;
193: ---cwb 2832419
194: ben_ext_person.g_er_cwb_dst_bdgt := null ;
195: ben_ext_person.g_er_cwb_misc_rate_1 := null ;
196: ben_ext_person.g_er_cwb_elig_salary := null ;
197: ben_ext_person.g_er_cwb_misc_rate_2 := null ;
198: ben_ext_person.g_er_cwb_grant_price := null ;
191: ben_ext_person.g_pev_er_ttl_distribution := null;
192: ben_ext_person.g_pev_ttl_other_rate := null;
193: ---cwb 2832419
194: ben_ext_person.g_er_cwb_dst_bdgt := null ;
195: ben_ext_person.g_er_cwb_misc_rate_1 := null ;
196: ben_ext_person.g_er_cwb_elig_salary := null ;
197: ben_ext_person.g_er_cwb_misc_rate_2 := null ;
198: ben_ext_person.g_er_cwb_grant_price := null ;
199: ben_ext_person.g_er_cwb_other_salary := null ;
192: ben_ext_person.g_pev_ttl_other_rate := null;
193: ---cwb 2832419
194: ben_ext_person.g_er_cwb_dst_bdgt := null ;
195: ben_ext_person.g_er_cwb_misc_rate_1 := null ;
196: ben_ext_person.g_er_cwb_elig_salary := null ;
197: ben_ext_person.g_er_cwb_misc_rate_2 := null ;
198: ben_ext_person.g_er_cwb_grant_price := null ;
199: ben_ext_person.g_er_cwb_other_salary := null ;
200: ben_ext_person.g_er_cwb_reserve := null ;
193: ---cwb 2832419
194: ben_ext_person.g_er_cwb_dst_bdgt := null ;
195: ben_ext_person.g_er_cwb_misc_rate_1 := null ;
196: ben_ext_person.g_er_cwb_elig_salary := null ;
197: ben_ext_person.g_er_cwb_misc_rate_2 := null ;
198: ben_ext_person.g_er_cwb_grant_price := null ;
199: ben_ext_person.g_er_cwb_other_salary := null ;
200: ben_ext_person.g_er_cwb_reserve := null ;
201: ben_ext_person.g_er_cwb_recomond_amt := null ;
194: ben_ext_person.g_er_cwb_dst_bdgt := null ;
195: ben_ext_person.g_er_cwb_misc_rate_1 := null ;
196: ben_ext_person.g_er_cwb_elig_salary := null ;
197: ben_ext_person.g_er_cwb_misc_rate_2 := null ;
198: ben_ext_person.g_er_cwb_grant_price := null ;
199: ben_ext_person.g_er_cwb_other_salary := null ;
200: ben_ext_person.g_er_cwb_reserve := null ;
201: ben_ext_person.g_er_cwb_recomond_amt := null ;
202: ben_ext_person.g_er_cwb_stated_salary := null ;
195: ben_ext_person.g_er_cwb_misc_rate_1 := null ;
196: ben_ext_person.g_er_cwb_elig_salary := null ;
197: ben_ext_person.g_er_cwb_misc_rate_2 := null ;
198: ben_ext_person.g_er_cwb_grant_price := null ;
199: ben_ext_person.g_er_cwb_other_salary := null ;
200: ben_ext_person.g_er_cwb_reserve := null ;
201: ben_ext_person.g_er_cwb_recomond_amt := null ;
202: ben_ext_person.g_er_cwb_stated_salary := null ;
203: ben_ext_person.g_er_cwb_tot_compensation := null ;
196: ben_ext_person.g_er_cwb_elig_salary := null ;
197: ben_ext_person.g_er_cwb_misc_rate_2 := null ;
198: ben_ext_person.g_er_cwb_grant_price := null ;
199: ben_ext_person.g_er_cwb_other_salary := null ;
200: ben_ext_person.g_er_cwb_reserve := null ;
201: ben_ext_person.g_er_cwb_recomond_amt := null ;
202: ben_ext_person.g_er_cwb_stated_salary := null ;
203: ben_ext_person.g_er_cwb_tot_compensation := null ;
204: ben_ext_person.g_er_cwb_worksheet_bdgt := null ;
197: ben_ext_person.g_er_cwb_misc_rate_2 := null ;
198: ben_ext_person.g_er_cwb_grant_price := null ;
199: ben_ext_person.g_er_cwb_other_salary := null ;
200: ben_ext_person.g_er_cwb_reserve := null ;
201: ben_ext_person.g_er_cwb_recomond_amt := null ;
202: ben_ext_person.g_er_cwb_stated_salary := null ;
203: ben_ext_person.g_er_cwb_tot_compensation := null ;
204: ben_ext_person.g_er_cwb_worksheet_bdgt := null ;
205: ben_ext_person.g_er_cwb_elig_salary := null ;
198: ben_ext_person.g_er_cwb_grant_price := null ;
199: ben_ext_person.g_er_cwb_other_salary := null ;
200: ben_ext_person.g_er_cwb_reserve := null ;
201: ben_ext_person.g_er_cwb_recomond_amt := null ;
202: ben_ext_person.g_er_cwb_stated_salary := null ;
203: ben_ext_person.g_er_cwb_tot_compensation := null ;
204: ben_ext_person.g_er_cwb_worksheet_bdgt := null ;
205: ben_ext_person.g_er_cwb_elig_salary := null ;
206: ben_ext_person.g_er_cwb_misc_rate_3 := null ;
199: ben_ext_person.g_er_cwb_other_salary := null ;
200: ben_ext_person.g_er_cwb_reserve := null ;
201: ben_ext_person.g_er_cwb_recomond_amt := null ;
202: ben_ext_person.g_er_cwb_stated_salary := null ;
203: ben_ext_person.g_er_cwb_tot_compensation := null ;
204: ben_ext_person.g_er_cwb_worksheet_bdgt := null ;
205: ben_ext_person.g_er_cwb_elig_salary := null ;
206: ben_ext_person.g_er_cwb_misc_rate_3 := null ;
207: ben_ext_person.g_er_reimbursement := null ;
200: ben_ext_person.g_er_cwb_reserve := null ;
201: ben_ext_person.g_er_cwb_recomond_amt := null ;
202: ben_ext_person.g_er_cwb_stated_salary := null ;
203: ben_ext_person.g_er_cwb_tot_compensation := null ;
204: ben_ext_person.g_er_cwb_worksheet_bdgt := null ;
205: ben_ext_person.g_er_cwb_elig_salary := null ;
206: ben_ext_person.g_er_cwb_misc_rate_3 := null ;
207: ben_ext_person.g_er_reimbursement := null ;
208: ben_ext_person.g_pev_er_reimbursement := null ;
201: ben_ext_person.g_er_cwb_recomond_amt := null ;
202: ben_ext_person.g_er_cwb_stated_salary := null ;
203: ben_ext_person.g_er_cwb_tot_compensation := null ;
204: ben_ext_person.g_er_cwb_worksheet_bdgt := null ;
205: ben_ext_person.g_er_cwb_elig_salary := null ;
206: ben_ext_person.g_er_cwb_misc_rate_3 := null ;
207: ben_ext_person.g_er_reimbursement := null ;
208: ben_ext_person.g_pev_er_reimbursement := null ;
209: ben_ext_person.g_er_forfeited := null ;
202: ben_ext_person.g_er_cwb_stated_salary := null ;
203: ben_ext_person.g_er_cwb_tot_compensation := null ;
204: ben_ext_person.g_er_cwb_worksheet_bdgt := null ;
205: ben_ext_person.g_er_cwb_elig_salary := null ;
206: ben_ext_person.g_er_cwb_misc_rate_3 := null ;
207: ben_ext_person.g_er_reimbursement := null ;
208: ben_ext_person.g_pev_er_reimbursement := null ;
209: ben_ext_person.g_er_forfeited := null ;
210: ben_ext_person.g_pev_er_forfeited := null ;
203: ben_ext_person.g_er_cwb_tot_compensation := null ;
204: ben_ext_person.g_er_cwb_worksheet_bdgt := null ;
205: ben_ext_person.g_er_cwb_elig_salary := null ;
206: ben_ext_person.g_er_cwb_misc_rate_3 := null ;
207: ben_ext_person.g_er_reimbursement := null ;
208: ben_ext_person.g_pev_er_reimbursement := null ;
209: ben_ext_person.g_er_forfeited := null ;
210: ben_ext_person.g_pev_er_forfeited := null ;
211:
204: ben_ext_person.g_er_cwb_worksheet_bdgt := null ;
205: ben_ext_person.g_er_cwb_elig_salary := null ;
206: ben_ext_person.g_er_cwb_misc_rate_3 := null ;
207: ben_ext_person.g_er_reimbursement := null ;
208: ben_ext_person.g_pev_er_reimbursement := null ;
209: ben_ext_person.g_er_forfeited := null ;
210: ben_ext_person.g_pev_er_forfeited := null ;
211:
212:
205: ben_ext_person.g_er_cwb_elig_salary := null ;
206: ben_ext_person.g_er_cwb_misc_rate_3 := null ;
207: ben_ext_person.g_er_reimbursement := null ;
208: ben_ext_person.g_pev_er_reimbursement := null ;
209: ben_ext_person.g_er_forfeited := null ;
210: ben_ext_person.g_pev_er_forfeited := null ;
211:
212:
213: --
206: ben_ext_person.g_er_cwb_misc_rate_3 := null ;
207: ben_ext_person.g_er_reimbursement := null ;
208: ben_ext_person.g_pev_er_reimbursement := null ;
209: ben_ext_person.g_er_forfeited := null ;
210: ben_ext_person.g_pev_er_forfeited := null ;
211:
212:
213: --
214: hr_utility.set_location('Exiting'||l_proc, 15);
338: -- Initialize rt info globals - May, 99
339: initialize_rt_info_globals;
340: --
341: open ee_pre_tax_c;
342: fetch ee_pre_tax_c into ben_ext_person.g_ee_pre_tax_cost, ben_ext_person.g_pev_ee_pre_tax_contr;
343: close ee_pre_tax_c;
344: --
345: open ee_after_tax_c;
346: fetch ee_after_tax_c into ben_ext_person.g_ee_after_tax_cost, ben_ext_person.g_pev_ee_after_tax_contr;
342: fetch ee_pre_tax_c into ben_ext_person.g_ee_pre_tax_cost, ben_ext_person.g_pev_ee_pre_tax_contr;
343: close ee_pre_tax_c;
344: --
345: open ee_after_tax_c;
346: fetch ee_after_tax_c into ben_ext_person.g_ee_after_tax_cost, ben_ext_person.g_pev_ee_after_tax_contr;
347: close ee_after_tax_c;
348: --
349: open ee_ttl_c;
350: fetch ee_ttl_c into ben_ext_person.g_ee_ttl_cost, ben_ext_person.g_pev_ee_ttl_contr;
346: fetch ee_after_tax_c into ben_ext_person.g_ee_after_tax_cost, ben_ext_person.g_pev_ee_after_tax_contr;
347: close ee_after_tax_c;
348: --
349: open ee_ttl_c;
350: fetch ee_ttl_c into ben_ext_person.g_ee_ttl_cost, ben_ext_person.g_pev_ee_ttl_contr;
351: close ee_ttl_c;
352: --
353: open er_ttl_c;
354: fetch er_ttl_c into ben_ext_person.g_er_ttl_cost, ben_ext_person.g_pev_er_ttl_contr;
350: fetch ee_ttl_c into ben_ext_person.g_ee_ttl_cost, ben_ext_person.g_pev_ee_ttl_contr;
351: close ee_ttl_c;
352: --
353: open er_ttl_c;
354: fetch er_ttl_c into ben_ext_person.g_er_ttl_cost, ben_ext_person.g_pev_er_ttl_contr;
355: close er_ttl_c;
356: --
357: open ee_ttl_dist_c;
358: fetch ee_ttl_dist_c into ben_ext_person.g_ee_ttl_distribution, ben_ext_person.g_pev_ee_ttl_distribution;
354: fetch er_ttl_c into ben_ext_person.g_er_ttl_cost, ben_ext_person.g_pev_er_ttl_contr;
355: close er_ttl_c;
356: --
357: open ee_ttl_dist_c;
358: fetch ee_ttl_dist_c into ben_ext_person.g_ee_ttl_distribution, ben_ext_person.g_pev_ee_ttl_distribution;
359: close ee_ttl_dist_c;
360: --
361: open er_ttl_dist_c;
362: fetch er_ttl_dist_c into ben_ext_person.g_er_ttl_distribution, ben_ext_person.g_pev_er_ttl_distribution;
358: fetch ee_ttl_dist_c into ben_ext_person.g_ee_ttl_distribution, ben_ext_person.g_pev_ee_ttl_distribution;
359: close ee_ttl_dist_c;
360: --
361: open er_ttl_dist_c;
362: fetch er_ttl_dist_c into ben_ext_person.g_er_ttl_distribution, ben_ext_person.g_pev_er_ttl_distribution;
363: close er_ttl_dist_c;
364: --
365: open ttl_oth_rt_c;
366: fetch ttl_oth_rt_c into ben_ext_person.g_ttl_other_rate, ben_ext_person.g_pev_ttl_other_rate;
362: fetch er_ttl_dist_c into ben_ext_person.g_er_ttl_distribution, ben_ext_person.g_pev_er_ttl_distribution;
363: close er_ttl_dist_c;
364: --
365: open ttl_oth_rt_c;
366: fetch ttl_oth_rt_c into ben_ext_person.g_ttl_other_rate, ben_ext_person.g_pev_ttl_other_rate;
367: close ttl_oth_rt_c;
368:
369: -- cwb 2832419
370: -- reimbursement
368:
369: -- cwb 2832419
370: -- reimbursement
371: open ttl_reimb_c;
372: fetch ttl_reimb_c into ben_ext_person.g_er_reimbursement , ben_ext_person.g_pev_er_reimbursement;
373: close ttl_reimb_c;
374:
375: hr_utility.set_location( 'reimb ' || ben_ext_person.g_er_reimbursement , 911 );
376: hr_utility.set_location( 'reimb ' || ben_ext_person.g_pev_er_reimbursement,911 );
371: open ttl_reimb_c;
372: fetch ttl_reimb_c into ben_ext_person.g_er_reimbursement , ben_ext_person.g_pev_er_reimbursement;
373: close ttl_reimb_c;
374:
375: hr_utility.set_location( 'reimb ' || ben_ext_person.g_er_reimbursement , 911 );
376: hr_utility.set_location( 'reimb ' || ben_ext_person.g_pev_er_reimbursement,911 );
377: --- Forfeiture
378: open ttl_type_cd_c('PRTRFS');
379: fetch ttl_type_cd_c into ben_ext_person.g_er_forfeited , ben_ext_person.g_pev_er_forfeited;
372: fetch ttl_reimb_c into ben_ext_person.g_er_reimbursement , ben_ext_person.g_pev_er_reimbursement;
373: close ttl_reimb_c;
374:
375: hr_utility.set_location( 'reimb ' || ben_ext_person.g_er_reimbursement , 911 );
376: hr_utility.set_location( 'reimb ' || ben_ext_person.g_pev_er_reimbursement,911 );
377: --- Forfeiture
378: open ttl_type_cd_c('PRTRFS');
379: fetch ttl_type_cd_c into ben_ext_person.g_er_forfeited , ben_ext_person.g_pev_er_forfeited;
380: close ttl_type_cd_c ;
375: hr_utility.set_location( 'reimb ' || ben_ext_person.g_er_reimbursement , 911 );
376: hr_utility.set_location( 'reimb ' || ben_ext_person.g_pev_er_reimbursement,911 );
377: --- Forfeiture
378: open ttl_type_cd_c('PRTRFS');
379: fetch ttl_type_cd_c into ben_ext_person.g_er_forfeited , ben_ext_person.g_pev_er_forfeited;
380: close ttl_type_cd_c ;
381:
382: -- CWB
383: open ttl_type_cd_c('CWBDB');
380: close ttl_type_cd_c ;
381:
382: -- CWB
383: open ttl_type_cd_c('CWBDB');
384: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_dst_bdgt,l_dummy ;
385: close ttl_type_cd_c ;
386:
387: open ttl_type_cd_c('CWBES');
388: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_elig_salary,l_dummy ;
384: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_dst_bdgt,l_dummy ;
385: close ttl_type_cd_c ;
386:
387: open ttl_type_cd_c('CWBES');
388: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_elig_salary,l_dummy ;
389: close ttl_type_cd_c ;
390:
391: open ttl_type_cd_c('CWBGP');
392: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_grant_price,l_dummy ;
388: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_elig_salary,l_dummy ;
389: close ttl_type_cd_c ;
390:
391: open ttl_type_cd_c('CWBGP');
392: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_grant_price,l_dummy ;
393: close ttl_type_cd_c ;
394:
395: hr_utility.set_location( 'CWBGP ' || ben_ext_person.g_er_cwb_grant_price , 911 );
396:
391: open ttl_type_cd_c('CWBGP');
392: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_grant_price,l_dummy ;
393: close ttl_type_cd_c ;
394:
395: hr_utility.set_location( 'CWBGP ' || ben_ext_person.g_er_cwb_grant_price , 911 );
396:
397: open ttl_type_cd_c('CWBMR1');
398: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_misc_rate_1,l_dummy ;
399: close ttl_type_cd_c ;
394:
395: hr_utility.set_location( 'CWBGP ' || ben_ext_person.g_er_cwb_grant_price , 911 );
396:
397: open ttl_type_cd_c('CWBMR1');
398: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_misc_rate_1,l_dummy ;
399: close ttl_type_cd_c ;
400:
401: open ttl_type_cd_c('CWBMR2');
402: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_misc_rate_2,l_dummy ;
398: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_misc_rate_1,l_dummy ;
399: close ttl_type_cd_c ;
400:
401: open ttl_type_cd_c('CWBMR2');
402: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_misc_rate_2,l_dummy ;
403: close ttl_type_cd_c ;
404:
405: open ttl_type_cd_c('CWBMR3');
406: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_misc_rate_3,l_dummy ;
402: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_misc_rate_2,l_dummy ;
403: close ttl_type_cd_c ;
404:
405: open ttl_type_cd_c('CWBMR3');
406: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_misc_rate_3,l_dummy ;
407: close ttl_type_cd_c ;
408:
409: open ttl_type_cd_c('CWBOS');
410: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_other_salary,l_dummy ;
406: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_misc_rate_3,l_dummy ;
407: close ttl_type_cd_c ;
408:
409: open ttl_type_cd_c('CWBOS');
410: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_other_salary,l_dummy ;
411: close ttl_type_cd_c ;
412:
413: open ttl_type_cd_c('CWBR');
414: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_reserve ,l_dummy ;
410: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_other_salary,l_dummy ;
411: close ttl_type_cd_c ;
412:
413: open ttl_type_cd_c('CWBR');
414: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_reserve ,l_dummy ;
415: close ttl_type_cd_c ;
416:
417: open ttl_type_cd_c('CWBRA');
418: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_recomond_amt,l_dummy ;
414: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_reserve ,l_dummy ;
415: close ttl_type_cd_c ;
416:
417: open ttl_type_cd_c('CWBRA');
418: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_recomond_amt,l_dummy ;
419: close ttl_type_cd_c ;
420:
421: open ttl_type_cd_c('CWBSS');
422: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_stated_salary,l_dummy ;
418: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_recomond_amt,l_dummy ;
419: close ttl_type_cd_c ;
420:
421: open ttl_type_cd_c('CWBSS');
422: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_stated_salary,l_dummy ;
423: close ttl_type_cd_c ;
424:
425: open ttl_type_cd_c('CWBTC');
426: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_tot_compensation,l_dummy ;
422: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_stated_salary,l_dummy ;
423: close ttl_type_cd_c ;
424:
425: open ttl_type_cd_c('CWBTC');
426: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_tot_compensation,l_dummy ;
427: close ttl_type_cd_c ;
428:
429: open ttl_type_cd_c('CWBWB');
430: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_worksheet_bdgt,l_dummy ;
426: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_tot_compensation,l_dummy ;
427: close ttl_type_cd_c ;
428:
429: open ttl_type_cd_c('CWBWB');
430: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_worksheet_bdgt,l_dummy ;
431: close ttl_type_cd_c ;
432:
433: open ttl_type_cd_c('CWBWS');
434: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_worksheet_amt,l_dummy ;
430: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_worksheet_bdgt,l_dummy ;
431: close ttl_type_cd_c ;
432:
433: open ttl_type_cd_c('CWBWS');
434: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_worksheet_amt,l_dummy ;
435: close ttl_type_cd_c ;
436:
437: hr_utility.set_location( 'CWBWS ' || ben_ext_person.g_er_cwb_worksheet_amt , 911 );
438:
433: open ttl_type_cd_c('CWBWS');
434: fetch ttl_type_cd_c into ben_ext_person.g_er_cwb_worksheet_amt,l_dummy ;
435: close ttl_type_cd_c ;
436:
437: hr_utility.set_location( 'CWBWS ' || ben_ext_person.g_er_cwb_worksheet_amt , 911 );
438:
439: --
440: hr_utility.set_location('Exiting'||l_proc, 15);
441: --
687: from ben_popl_org_f ppl ,
688: per_all_assignments_f asg
689: where pl_id = l_pl_id
690: and plcy_r_grp is not null
691: and asg.assignment_id = ben_ext_person.g_assignment_id
692: and ppl.organization_id = asg.organization_id
693: and p_effective_date between ppl.effective_start_date
694: and ppl.effective_end_date
695: and p_effective_date between asg.effective_start_date
885:
886: open c_ptip_fd(l_pgm_id => enrt.pgm_id ,
887: l_pl_typ_id => enrt.pl_typ_id ) ;
888: fetch c_ptip_fd
889: into ben_ext_person.g_enrt_pl_typ_pgm_fd_name
890: ,ben_ext_person.g_enrt_pl_typ_pgm_fd_code ;
891: close c_ptip_fd ;
892:
893: end if ;
886: open c_ptip_fd(l_pgm_id => enrt.pgm_id ,
887: l_pl_typ_id => enrt.pl_typ_id ) ;
888: fetch c_ptip_fd
889: into ben_ext_person.g_enrt_pl_typ_pgm_fd_name
890: ,ben_ext_person.g_enrt_pl_typ_pgm_fd_code ;
891: close c_ptip_fd ;
892:
893: end if ;
894: --
892:
893: end if ;
894: --
895: /* Start of Changes for WWBUG: 1828349 */
896: ben_ext_person.g_enrt_prtt_enrt_rslt_id := enrt.prtt_enrt_rslt_id;
897: /* End of Changes for WWBUG: 1828349 */
898: ben_ext_person.g_enrt_pl_name := enrt.pl_name;
899: ben_ext_person.g_enrt_orgcovg_strdt := enrt.orgn_strdt;
900: ben_ext_person.g_enrt_prt_orgcovg_strdt := enrt.orgn_strdt;
894: --
895: /* Start of Changes for WWBUG: 1828349 */
896: ben_ext_person.g_enrt_prtt_enrt_rslt_id := enrt.prtt_enrt_rslt_id;
897: /* End of Changes for WWBUG: 1828349 */
898: ben_ext_person.g_enrt_pl_name := enrt.pl_name;
899: ben_ext_person.g_enrt_orgcovg_strdt := enrt.orgn_strdt;
900: ben_ext_person.g_enrt_prt_orgcovg_strdt := enrt.orgn_strdt;
901: ben_ext_person.g_enrt_status_cd := enrt.status_cd;
902: ben_ext_person.g_enrt_pl_id := enrt.pl_id;
895: /* Start of Changes for WWBUG: 1828349 */
896: ben_ext_person.g_enrt_prtt_enrt_rslt_id := enrt.prtt_enrt_rslt_id;
897: /* End of Changes for WWBUG: 1828349 */
898: ben_ext_person.g_enrt_pl_name := enrt.pl_name;
899: ben_ext_person.g_enrt_orgcovg_strdt := enrt.orgn_strdt;
900: ben_ext_person.g_enrt_prt_orgcovg_strdt := enrt.orgn_strdt;
901: ben_ext_person.g_enrt_status_cd := enrt.status_cd;
902: ben_ext_person.g_enrt_pl_id := enrt.pl_id;
903: ben_ext_person.g_enrt_pl_seq_num := enrt.pl_seq_num;
896: ben_ext_person.g_enrt_prtt_enrt_rslt_id := enrt.prtt_enrt_rslt_id;
897: /* End of Changes for WWBUG: 1828349 */
898: ben_ext_person.g_enrt_pl_name := enrt.pl_name;
899: ben_ext_person.g_enrt_orgcovg_strdt := enrt.orgn_strdt;
900: ben_ext_person.g_enrt_prt_orgcovg_strdt := enrt.orgn_strdt;
901: ben_ext_person.g_enrt_status_cd := enrt.status_cd;
902: ben_ext_person.g_enrt_pl_id := enrt.pl_id;
903: ben_ext_person.g_enrt_pl_seq_num := enrt.pl_seq_num;
904: ben_ext_person.g_enrt_pip_seq_num := enrt.plip_seq_num;
897: /* End of Changes for WWBUG: 1828349 */
898: ben_ext_person.g_enrt_pl_name := enrt.pl_name;
899: ben_ext_person.g_enrt_orgcovg_strdt := enrt.orgn_strdt;
900: ben_ext_person.g_enrt_prt_orgcovg_strdt := enrt.orgn_strdt;
901: ben_ext_person.g_enrt_status_cd := enrt.status_cd;
902: ben_ext_person.g_enrt_pl_id := enrt.pl_id;
903: ben_ext_person.g_enrt_pl_seq_num := enrt.pl_seq_num;
904: ben_ext_person.g_enrt_pip_seq_num := enrt.plip_seq_num;
905: ben_ext_person.g_enrt_ptp_seq_num := enrt.ptip_seq_num;
898: ben_ext_person.g_enrt_pl_name := enrt.pl_name;
899: ben_ext_person.g_enrt_orgcovg_strdt := enrt.orgn_strdt;
900: ben_ext_person.g_enrt_prt_orgcovg_strdt := enrt.orgn_strdt;
901: ben_ext_person.g_enrt_status_cd := enrt.status_cd;
902: ben_ext_person.g_enrt_pl_id := enrt.pl_id;
903: ben_ext_person.g_enrt_pl_seq_num := enrt.pl_seq_num;
904: ben_ext_person.g_enrt_pip_seq_num := enrt.plip_seq_num;
905: ben_ext_person.g_enrt_ptp_seq_num := enrt.ptip_seq_num;
906: ben_ext_person.g_enrt_oip_seq_num := enrt.oipl_seq_num;
899: ben_ext_person.g_enrt_orgcovg_strdt := enrt.orgn_strdt;
900: ben_ext_person.g_enrt_prt_orgcovg_strdt := enrt.orgn_strdt;
901: ben_ext_person.g_enrt_status_cd := enrt.status_cd;
902: ben_ext_person.g_enrt_pl_id := enrt.pl_id;
903: ben_ext_person.g_enrt_pl_seq_num := enrt.pl_seq_num;
904: ben_ext_person.g_enrt_pip_seq_num := enrt.plip_seq_num;
905: ben_ext_person.g_enrt_ptp_seq_num := enrt.ptip_seq_num;
906: ben_ext_person.g_enrt_oip_seq_num := enrt.oipl_seq_num;
907: ben_ext_person.g_enrt_cvg_strt_dt := enrt.cvg_strt_dt;
900: ben_ext_person.g_enrt_prt_orgcovg_strdt := enrt.orgn_strdt;
901: ben_ext_person.g_enrt_status_cd := enrt.status_cd;
902: ben_ext_person.g_enrt_pl_id := enrt.pl_id;
903: ben_ext_person.g_enrt_pl_seq_num := enrt.pl_seq_num;
904: ben_ext_person.g_enrt_pip_seq_num := enrt.plip_seq_num;
905: ben_ext_person.g_enrt_ptp_seq_num := enrt.ptip_seq_num;
906: ben_ext_person.g_enrt_oip_seq_num := enrt.oipl_seq_num;
907: ben_ext_person.g_enrt_cvg_strt_dt := enrt.cvg_strt_dt;
908: ben_ext_person.g_enrt_cvg_thru_dt := enrt.cvg_thru_dt;
901: ben_ext_person.g_enrt_status_cd := enrt.status_cd;
902: ben_ext_person.g_enrt_pl_id := enrt.pl_id;
903: ben_ext_person.g_enrt_pl_seq_num := enrt.pl_seq_num;
904: ben_ext_person.g_enrt_pip_seq_num := enrt.plip_seq_num;
905: ben_ext_person.g_enrt_ptp_seq_num := enrt.ptip_seq_num;
906: ben_ext_person.g_enrt_oip_seq_num := enrt.oipl_seq_num;
907: ben_ext_person.g_enrt_cvg_strt_dt := enrt.cvg_strt_dt;
908: ben_ext_person.g_enrt_cvg_thru_dt := enrt.cvg_thru_dt;
909: ben_ext_person.g_enrt_method := enrt.mthd_cd;
902: ben_ext_person.g_enrt_pl_id := enrt.pl_id;
903: ben_ext_person.g_enrt_pl_seq_num := enrt.pl_seq_num;
904: ben_ext_person.g_enrt_pip_seq_num := enrt.plip_seq_num;
905: ben_ext_person.g_enrt_ptp_seq_num := enrt.ptip_seq_num;
906: ben_ext_person.g_enrt_oip_seq_num := enrt.oipl_seq_num;
907: ben_ext_person.g_enrt_cvg_strt_dt := enrt.cvg_strt_dt;
908: ben_ext_person.g_enrt_cvg_thru_dt := enrt.cvg_thru_dt;
909: ben_ext_person.g_enrt_method := enrt.mthd_cd;
910: ben_ext_person.g_enrt_ovrd_flag := enrt.ovridn_flag;
903: ben_ext_person.g_enrt_pl_seq_num := enrt.pl_seq_num;
904: ben_ext_person.g_enrt_pip_seq_num := enrt.plip_seq_num;
905: ben_ext_person.g_enrt_ptp_seq_num := enrt.ptip_seq_num;
906: ben_ext_person.g_enrt_oip_seq_num := enrt.oipl_seq_num;
907: ben_ext_person.g_enrt_cvg_strt_dt := enrt.cvg_strt_dt;
908: ben_ext_person.g_enrt_cvg_thru_dt := enrt.cvg_thru_dt;
909: ben_ext_person.g_enrt_method := enrt.mthd_cd;
910: ben_ext_person.g_enrt_ovrd_flag := enrt.ovridn_flag;
911: ben_ext_person.g_enrt_ovrd_thru_dt := enrt.ovrid_thru_dt;
904: ben_ext_person.g_enrt_pip_seq_num := enrt.plip_seq_num;
905: ben_ext_person.g_enrt_ptp_seq_num := enrt.ptip_seq_num;
906: ben_ext_person.g_enrt_oip_seq_num := enrt.oipl_seq_num;
907: ben_ext_person.g_enrt_cvg_strt_dt := enrt.cvg_strt_dt;
908: ben_ext_person.g_enrt_cvg_thru_dt := enrt.cvg_thru_dt;
909: ben_ext_person.g_enrt_method := enrt.mthd_cd;
910: ben_ext_person.g_enrt_ovrd_flag := enrt.ovridn_flag;
911: ben_ext_person.g_enrt_ovrd_thru_dt := enrt.ovrid_thru_dt;
912: ben_ext_person.g_enrt_ovrd_reason := enrt.ovrid_rsn_cd;
905: ben_ext_person.g_enrt_ptp_seq_num := enrt.ptip_seq_num;
906: ben_ext_person.g_enrt_oip_seq_num := enrt.oipl_seq_num;
907: ben_ext_person.g_enrt_cvg_strt_dt := enrt.cvg_strt_dt;
908: ben_ext_person.g_enrt_cvg_thru_dt := enrt.cvg_thru_dt;
909: ben_ext_person.g_enrt_method := enrt.mthd_cd;
910: ben_ext_person.g_enrt_ovrd_flag := enrt.ovridn_flag;
911: ben_ext_person.g_enrt_ovrd_thru_dt := enrt.ovrid_thru_dt;
912: ben_ext_person.g_enrt_ovrd_reason := enrt.ovrid_rsn_cd;
913: ben_ext_person.g_enrt_suspended_flag := enrt.sspndd_flag;
906: ben_ext_person.g_enrt_oip_seq_num := enrt.oipl_seq_num;
907: ben_ext_person.g_enrt_cvg_strt_dt := enrt.cvg_strt_dt;
908: ben_ext_person.g_enrt_cvg_thru_dt := enrt.cvg_thru_dt;
909: ben_ext_person.g_enrt_method := enrt.mthd_cd;
910: ben_ext_person.g_enrt_ovrd_flag := enrt.ovridn_flag;
911: ben_ext_person.g_enrt_ovrd_thru_dt := enrt.ovrid_thru_dt;
912: ben_ext_person.g_enrt_ovrd_reason := enrt.ovrid_rsn_cd;
913: ben_ext_person.g_enrt_suspended_flag := enrt.sspndd_flag;
914: ben_ext_person.g_enrt_rslt_effct_strdt := enrt.effct_strdt;
907: ben_ext_person.g_enrt_cvg_strt_dt := enrt.cvg_strt_dt;
908: ben_ext_person.g_enrt_cvg_thru_dt := enrt.cvg_thru_dt;
909: ben_ext_person.g_enrt_method := enrt.mthd_cd;
910: ben_ext_person.g_enrt_ovrd_flag := enrt.ovridn_flag;
911: ben_ext_person.g_enrt_ovrd_thru_dt := enrt.ovrid_thru_dt;
912: ben_ext_person.g_enrt_ovrd_reason := enrt.ovrid_rsn_cd;
913: ben_ext_person.g_enrt_suspended_flag := enrt.sspndd_flag;
914: ben_ext_person.g_enrt_rslt_effct_strdt := enrt.effct_strdt;
915: ben_ext_person.g_enrt_cvg_amt := enrt.bnft_amt;
908: ben_ext_person.g_enrt_cvg_thru_dt := enrt.cvg_thru_dt;
909: ben_ext_person.g_enrt_method := enrt.mthd_cd;
910: ben_ext_person.g_enrt_ovrd_flag := enrt.ovridn_flag;
911: ben_ext_person.g_enrt_ovrd_thru_dt := enrt.ovrid_thru_dt;
912: ben_ext_person.g_enrt_ovrd_reason := enrt.ovrid_rsn_cd;
913: ben_ext_person.g_enrt_suspended_flag := enrt.sspndd_flag;
914: ben_ext_person.g_enrt_rslt_effct_strdt := enrt.effct_strdt;
915: ben_ext_person.g_enrt_cvg_amt := enrt.bnft_amt;
916: ben_ext_person.g_enrt_benefit_order_num := enrt.bnft_order_num;
909: ben_ext_person.g_enrt_method := enrt.mthd_cd;
910: ben_ext_person.g_enrt_ovrd_flag := enrt.ovridn_flag;
911: ben_ext_person.g_enrt_ovrd_thru_dt := enrt.ovrid_thru_dt;
912: ben_ext_person.g_enrt_ovrd_reason := enrt.ovrid_rsn_cd;
913: ben_ext_person.g_enrt_suspended_flag := enrt.sspndd_flag;
914: ben_ext_person.g_enrt_rslt_effct_strdt := enrt.effct_strdt;
915: ben_ext_person.g_enrt_cvg_amt := enrt.bnft_amt;
916: ben_ext_person.g_enrt_benefit_order_num := enrt.bnft_order_num;
917: ben_ext_person.g_enrt_pgm_id := enrt.pgm_id;
910: ben_ext_person.g_enrt_ovrd_flag := enrt.ovridn_flag;
911: ben_ext_person.g_enrt_ovrd_thru_dt := enrt.ovrid_thru_dt;
912: ben_ext_person.g_enrt_ovrd_reason := enrt.ovrid_rsn_cd;
913: ben_ext_person.g_enrt_suspended_flag := enrt.sspndd_flag;
914: ben_ext_person.g_enrt_rslt_effct_strdt := enrt.effct_strdt;
915: ben_ext_person.g_enrt_cvg_amt := enrt.bnft_amt;
916: ben_ext_person.g_enrt_benefit_order_num := enrt.bnft_order_num;
917: ben_ext_person.g_enrt_pgm_id := enrt.pgm_id;
918: ben_ext_person.g_enrt_pl_typ_id := enrt.pl_typ_id;
911: ben_ext_person.g_enrt_ovrd_thru_dt := enrt.ovrid_thru_dt;
912: ben_ext_person.g_enrt_ovrd_reason := enrt.ovrid_rsn_cd;
913: ben_ext_person.g_enrt_suspended_flag := enrt.sspndd_flag;
914: ben_ext_person.g_enrt_rslt_effct_strdt := enrt.effct_strdt;
915: ben_ext_person.g_enrt_cvg_amt := enrt.bnft_amt;
916: ben_ext_person.g_enrt_benefit_order_num := enrt.bnft_order_num;
917: ben_ext_person.g_enrt_pgm_id := enrt.pgm_id;
918: ben_ext_person.g_enrt_pl_typ_id := enrt.pl_typ_id;
919: ben_ext_person.g_enrt_pl_typ_name := enrt.pl_typ_name;
912: ben_ext_person.g_enrt_ovrd_reason := enrt.ovrid_rsn_cd;
913: ben_ext_person.g_enrt_suspended_flag := enrt.sspndd_flag;
914: ben_ext_person.g_enrt_rslt_effct_strdt := enrt.effct_strdt;
915: ben_ext_person.g_enrt_cvg_amt := enrt.bnft_amt;
916: ben_ext_person.g_enrt_benefit_order_num := enrt.bnft_order_num;
917: ben_ext_person.g_enrt_pgm_id := enrt.pgm_id;
918: ben_ext_person.g_enrt_pl_typ_id := enrt.pl_typ_id;
919: ben_ext_person.g_enrt_pl_typ_name := enrt.pl_typ_name;
920: ben_ext_person.g_enrt_attr_1 := enrt.pen_attribute1;
913: ben_ext_person.g_enrt_suspended_flag := enrt.sspndd_flag;
914: ben_ext_person.g_enrt_rslt_effct_strdt := enrt.effct_strdt;
915: ben_ext_person.g_enrt_cvg_amt := enrt.bnft_amt;
916: ben_ext_person.g_enrt_benefit_order_num := enrt.bnft_order_num;
917: ben_ext_person.g_enrt_pgm_id := enrt.pgm_id;
918: ben_ext_person.g_enrt_pl_typ_id := enrt.pl_typ_id;
919: ben_ext_person.g_enrt_pl_typ_name := enrt.pl_typ_name;
920: ben_ext_person.g_enrt_attr_1 := enrt.pen_attribute1;
921: ben_ext_person.g_enrt_attr_2 := enrt.pen_attribute2;
914: ben_ext_person.g_enrt_rslt_effct_strdt := enrt.effct_strdt;
915: ben_ext_person.g_enrt_cvg_amt := enrt.bnft_amt;
916: ben_ext_person.g_enrt_benefit_order_num := enrt.bnft_order_num;
917: ben_ext_person.g_enrt_pgm_id := enrt.pgm_id;
918: ben_ext_person.g_enrt_pl_typ_id := enrt.pl_typ_id;
919: ben_ext_person.g_enrt_pl_typ_name := enrt.pl_typ_name;
920: ben_ext_person.g_enrt_attr_1 := enrt.pen_attribute1;
921: ben_ext_person.g_enrt_attr_2 := enrt.pen_attribute2;
922: ben_ext_person.g_enrt_attr_3 := enrt.pen_attribute3;
915: ben_ext_person.g_enrt_cvg_amt := enrt.bnft_amt;
916: ben_ext_person.g_enrt_benefit_order_num := enrt.bnft_order_num;
917: ben_ext_person.g_enrt_pgm_id := enrt.pgm_id;
918: ben_ext_person.g_enrt_pl_typ_id := enrt.pl_typ_id;
919: ben_ext_person.g_enrt_pl_typ_name := enrt.pl_typ_name;
920: ben_ext_person.g_enrt_attr_1 := enrt.pen_attribute1;
921: ben_ext_person.g_enrt_attr_2 := enrt.pen_attribute2;
922: ben_ext_person.g_enrt_attr_3 := enrt.pen_attribute3;
923: ben_ext_person.g_enrt_attr_4 := enrt.pen_attribute4;
916: ben_ext_person.g_enrt_benefit_order_num := enrt.bnft_order_num;
917: ben_ext_person.g_enrt_pgm_id := enrt.pgm_id;
918: ben_ext_person.g_enrt_pl_typ_id := enrt.pl_typ_id;
919: ben_ext_person.g_enrt_pl_typ_name := enrt.pl_typ_name;
920: ben_ext_person.g_enrt_attr_1 := enrt.pen_attribute1;
921: ben_ext_person.g_enrt_attr_2 := enrt.pen_attribute2;
922: ben_ext_person.g_enrt_attr_3 := enrt.pen_attribute3;
923: ben_ext_person.g_enrt_attr_4 := enrt.pen_attribute4;
924: ben_ext_person.g_enrt_attr_5 := enrt.pen_attribute5;
917: ben_ext_person.g_enrt_pgm_id := enrt.pgm_id;
918: ben_ext_person.g_enrt_pl_typ_id := enrt.pl_typ_id;
919: ben_ext_person.g_enrt_pl_typ_name := enrt.pl_typ_name;
920: ben_ext_person.g_enrt_attr_1 := enrt.pen_attribute1;
921: ben_ext_person.g_enrt_attr_2 := enrt.pen_attribute2;
922: ben_ext_person.g_enrt_attr_3 := enrt.pen_attribute3;
923: ben_ext_person.g_enrt_attr_4 := enrt.pen_attribute4;
924: ben_ext_person.g_enrt_attr_5 := enrt.pen_attribute5;
925: ben_ext_person.g_enrt_attr_6 := enrt.pen_attribute6;
918: ben_ext_person.g_enrt_pl_typ_id := enrt.pl_typ_id;
919: ben_ext_person.g_enrt_pl_typ_name := enrt.pl_typ_name;
920: ben_ext_person.g_enrt_attr_1 := enrt.pen_attribute1;
921: ben_ext_person.g_enrt_attr_2 := enrt.pen_attribute2;
922: ben_ext_person.g_enrt_attr_3 := enrt.pen_attribute3;
923: ben_ext_person.g_enrt_attr_4 := enrt.pen_attribute4;
924: ben_ext_person.g_enrt_attr_5 := enrt.pen_attribute5;
925: ben_ext_person.g_enrt_attr_6 := enrt.pen_attribute6;
926: ben_ext_person.g_enrt_attr_7 := enrt.pen_attribute7;
919: ben_ext_person.g_enrt_pl_typ_name := enrt.pl_typ_name;
920: ben_ext_person.g_enrt_attr_1 := enrt.pen_attribute1;
921: ben_ext_person.g_enrt_attr_2 := enrt.pen_attribute2;
922: ben_ext_person.g_enrt_attr_3 := enrt.pen_attribute3;
923: ben_ext_person.g_enrt_attr_4 := enrt.pen_attribute4;
924: ben_ext_person.g_enrt_attr_5 := enrt.pen_attribute5;
925: ben_ext_person.g_enrt_attr_6 := enrt.pen_attribute6;
926: ben_ext_person.g_enrt_attr_7 := enrt.pen_attribute7;
927: ben_ext_person.g_enrt_attr_8 := enrt.pen_attribute8;
920: ben_ext_person.g_enrt_attr_1 := enrt.pen_attribute1;
921: ben_ext_person.g_enrt_attr_2 := enrt.pen_attribute2;
922: ben_ext_person.g_enrt_attr_3 := enrt.pen_attribute3;
923: ben_ext_person.g_enrt_attr_4 := enrt.pen_attribute4;
924: ben_ext_person.g_enrt_attr_5 := enrt.pen_attribute5;
925: ben_ext_person.g_enrt_attr_6 := enrt.pen_attribute6;
926: ben_ext_person.g_enrt_attr_7 := enrt.pen_attribute7;
927: ben_ext_person.g_enrt_attr_8 := enrt.pen_attribute8;
928: ben_ext_person.g_enrt_attr_9 := enrt.pen_attribute9;
921: ben_ext_person.g_enrt_attr_2 := enrt.pen_attribute2;
922: ben_ext_person.g_enrt_attr_3 := enrt.pen_attribute3;
923: ben_ext_person.g_enrt_attr_4 := enrt.pen_attribute4;
924: ben_ext_person.g_enrt_attr_5 := enrt.pen_attribute5;
925: ben_ext_person.g_enrt_attr_6 := enrt.pen_attribute6;
926: ben_ext_person.g_enrt_attr_7 := enrt.pen_attribute7;
927: ben_ext_person.g_enrt_attr_8 := enrt.pen_attribute8;
928: ben_ext_person.g_enrt_attr_9 := enrt.pen_attribute9;
929: ben_ext_person.g_enrt_attr_10 := enrt.pen_attribute10;
922: ben_ext_person.g_enrt_attr_3 := enrt.pen_attribute3;
923: ben_ext_person.g_enrt_attr_4 := enrt.pen_attribute4;
924: ben_ext_person.g_enrt_attr_5 := enrt.pen_attribute5;
925: ben_ext_person.g_enrt_attr_6 := enrt.pen_attribute6;
926: ben_ext_person.g_enrt_attr_7 := enrt.pen_attribute7;
927: ben_ext_person.g_enrt_attr_8 := enrt.pen_attribute8;
928: ben_ext_person.g_enrt_attr_9 := enrt.pen_attribute9;
929: ben_ext_person.g_enrt_attr_10 := enrt.pen_attribute10;
930: ben_ext_person.g_enrt_ler_id := enrt.enrt_ler_id;
923: ben_ext_person.g_enrt_attr_4 := enrt.pen_attribute4;
924: ben_ext_person.g_enrt_attr_5 := enrt.pen_attribute5;
925: ben_ext_person.g_enrt_attr_6 := enrt.pen_attribute6;
926: ben_ext_person.g_enrt_attr_7 := enrt.pen_attribute7;
927: ben_ext_person.g_enrt_attr_8 := enrt.pen_attribute8;
928: ben_ext_person.g_enrt_attr_9 := enrt.pen_attribute9;
929: ben_ext_person.g_enrt_attr_10 := enrt.pen_attribute10;
930: ben_ext_person.g_enrt_ler_id := enrt.enrt_ler_id;
931: ben_ext_person.g_enrt_assignment_id := enrt.assignment_id;
924: ben_ext_person.g_enrt_attr_5 := enrt.pen_attribute5;
925: ben_ext_person.g_enrt_attr_6 := enrt.pen_attribute6;
926: ben_ext_person.g_enrt_attr_7 := enrt.pen_attribute7;
927: ben_ext_person.g_enrt_attr_8 := enrt.pen_attribute8;
928: ben_ext_person.g_enrt_attr_9 := enrt.pen_attribute9;
929: ben_ext_person.g_enrt_attr_10 := enrt.pen_attribute10;
930: ben_ext_person.g_enrt_ler_id := enrt.enrt_ler_id;
931: ben_ext_person.g_enrt_assignment_id := enrt.assignment_id;
932: ben_ext_person.g_enrt_uom := enrt.uom;
925: ben_ext_person.g_enrt_attr_6 := enrt.pen_attribute6;
926: ben_ext_person.g_enrt_attr_7 := enrt.pen_attribute7;
927: ben_ext_person.g_enrt_attr_8 := enrt.pen_attribute8;
928: ben_ext_person.g_enrt_attr_9 := enrt.pen_attribute9;
929: ben_ext_person.g_enrt_attr_10 := enrt.pen_attribute10;
930: ben_ext_person.g_enrt_ler_id := enrt.enrt_ler_id;
931: ben_ext_person.g_enrt_assignment_id := enrt.assignment_id;
932: ben_ext_person.g_enrt_uom := enrt.uom;
933: ben_ext_person.g_pl_attr_1 := enrt.pln_attribute1;
926: ben_ext_person.g_enrt_attr_7 := enrt.pen_attribute7;
927: ben_ext_person.g_enrt_attr_8 := enrt.pen_attribute8;
928: ben_ext_person.g_enrt_attr_9 := enrt.pen_attribute9;
929: ben_ext_person.g_enrt_attr_10 := enrt.pen_attribute10;
930: ben_ext_person.g_enrt_ler_id := enrt.enrt_ler_id;
931: ben_ext_person.g_enrt_assignment_id := enrt.assignment_id;
932: ben_ext_person.g_enrt_uom := enrt.uom;
933: ben_ext_person.g_pl_attr_1 := enrt.pln_attribute1;
934: ben_ext_person.g_pl_attr_2 := enrt.pln_attribute2;
927: ben_ext_person.g_enrt_attr_8 := enrt.pen_attribute8;
928: ben_ext_person.g_enrt_attr_9 := enrt.pen_attribute9;
929: ben_ext_person.g_enrt_attr_10 := enrt.pen_attribute10;
930: ben_ext_person.g_enrt_ler_id := enrt.enrt_ler_id;
931: ben_ext_person.g_enrt_assignment_id := enrt.assignment_id;
932: ben_ext_person.g_enrt_uom := enrt.uom;
933: ben_ext_person.g_pl_attr_1 := enrt.pln_attribute1;
934: ben_ext_person.g_pl_attr_2 := enrt.pln_attribute2;
935: ben_ext_person.g_pl_attr_3 := enrt.pln_attribute3;
928: ben_ext_person.g_enrt_attr_9 := enrt.pen_attribute9;
929: ben_ext_person.g_enrt_attr_10 := enrt.pen_attribute10;
930: ben_ext_person.g_enrt_ler_id := enrt.enrt_ler_id;
931: ben_ext_person.g_enrt_assignment_id := enrt.assignment_id;
932: ben_ext_person.g_enrt_uom := enrt.uom;
933: ben_ext_person.g_pl_attr_1 := enrt.pln_attribute1;
934: ben_ext_person.g_pl_attr_2 := enrt.pln_attribute2;
935: ben_ext_person.g_pl_attr_3 := enrt.pln_attribute3;
936: ben_ext_person.g_pl_attr_4 := enrt.pln_attribute4;
929: ben_ext_person.g_enrt_attr_10 := enrt.pen_attribute10;
930: ben_ext_person.g_enrt_ler_id := enrt.enrt_ler_id;
931: ben_ext_person.g_enrt_assignment_id := enrt.assignment_id;
932: ben_ext_person.g_enrt_uom := enrt.uom;
933: ben_ext_person.g_pl_attr_1 := enrt.pln_attribute1;
934: ben_ext_person.g_pl_attr_2 := enrt.pln_attribute2;
935: ben_ext_person.g_pl_attr_3 := enrt.pln_attribute3;
936: ben_ext_person.g_pl_attr_4 := enrt.pln_attribute4;
937: ben_ext_person.g_pl_attr_5 := enrt.pln_attribute5;
930: ben_ext_person.g_enrt_ler_id := enrt.enrt_ler_id;
931: ben_ext_person.g_enrt_assignment_id := enrt.assignment_id;
932: ben_ext_person.g_enrt_uom := enrt.uom;
933: ben_ext_person.g_pl_attr_1 := enrt.pln_attribute1;
934: ben_ext_person.g_pl_attr_2 := enrt.pln_attribute2;
935: ben_ext_person.g_pl_attr_3 := enrt.pln_attribute3;
936: ben_ext_person.g_pl_attr_4 := enrt.pln_attribute4;
937: ben_ext_person.g_pl_attr_5 := enrt.pln_attribute5;
938: ben_ext_person.g_pl_attr_6 := enrt.pln_attribute6;
931: ben_ext_person.g_enrt_assignment_id := enrt.assignment_id;
932: ben_ext_person.g_enrt_uom := enrt.uom;
933: ben_ext_person.g_pl_attr_1 := enrt.pln_attribute1;
934: ben_ext_person.g_pl_attr_2 := enrt.pln_attribute2;
935: ben_ext_person.g_pl_attr_3 := enrt.pln_attribute3;
936: ben_ext_person.g_pl_attr_4 := enrt.pln_attribute4;
937: ben_ext_person.g_pl_attr_5 := enrt.pln_attribute5;
938: ben_ext_person.g_pl_attr_6 := enrt.pln_attribute6;
939: ben_ext_person.g_pl_attr_7 := enrt.pln_attribute7;
932: ben_ext_person.g_enrt_uom := enrt.uom;
933: ben_ext_person.g_pl_attr_1 := enrt.pln_attribute1;
934: ben_ext_person.g_pl_attr_2 := enrt.pln_attribute2;
935: ben_ext_person.g_pl_attr_3 := enrt.pln_attribute3;
936: ben_ext_person.g_pl_attr_4 := enrt.pln_attribute4;
937: ben_ext_person.g_pl_attr_5 := enrt.pln_attribute5;
938: ben_ext_person.g_pl_attr_6 := enrt.pln_attribute6;
939: ben_ext_person.g_pl_attr_7 := enrt.pln_attribute7;
940: ben_ext_person.g_pl_attr_8 := enrt.pln_attribute8;
933: ben_ext_person.g_pl_attr_1 := enrt.pln_attribute1;
934: ben_ext_person.g_pl_attr_2 := enrt.pln_attribute2;
935: ben_ext_person.g_pl_attr_3 := enrt.pln_attribute3;
936: ben_ext_person.g_pl_attr_4 := enrt.pln_attribute4;
937: ben_ext_person.g_pl_attr_5 := enrt.pln_attribute5;
938: ben_ext_person.g_pl_attr_6 := enrt.pln_attribute6;
939: ben_ext_person.g_pl_attr_7 := enrt.pln_attribute7;
940: ben_ext_person.g_pl_attr_8 := enrt.pln_attribute8;
941: ben_ext_person.g_pl_attr_9 := enrt.pln_attribute9;
934: ben_ext_person.g_pl_attr_2 := enrt.pln_attribute2;
935: ben_ext_person.g_pl_attr_3 := enrt.pln_attribute3;
936: ben_ext_person.g_pl_attr_4 := enrt.pln_attribute4;
937: ben_ext_person.g_pl_attr_5 := enrt.pln_attribute5;
938: ben_ext_person.g_pl_attr_6 := enrt.pln_attribute6;
939: ben_ext_person.g_pl_attr_7 := enrt.pln_attribute7;
940: ben_ext_person.g_pl_attr_8 := enrt.pln_attribute8;
941: ben_ext_person.g_pl_attr_9 := enrt.pln_attribute9;
942: ben_ext_person.g_pl_attr_10 := enrt.pln_attribute10;
935: ben_ext_person.g_pl_attr_3 := enrt.pln_attribute3;
936: ben_ext_person.g_pl_attr_4 := enrt.pln_attribute4;
937: ben_ext_person.g_pl_attr_5 := enrt.pln_attribute5;
938: ben_ext_person.g_pl_attr_6 := enrt.pln_attribute6;
939: ben_ext_person.g_pl_attr_7 := enrt.pln_attribute7;
940: ben_ext_person.g_pl_attr_8 := enrt.pln_attribute8;
941: ben_ext_person.g_pl_attr_9 := enrt.pln_attribute9;
942: ben_ext_person.g_pl_attr_10 := enrt.pln_attribute10;
943: ben_ext_person.g_ptp_attr_1 := enrt.ptp_attribute1;
936: ben_ext_person.g_pl_attr_4 := enrt.pln_attribute4;
937: ben_ext_person.g_pl_attr_5 := enrt.pln_attribute5;
938: ben_ext_person.g_pl_attr_6 := enrt.pln_attribute6;
939: ben_ext_person.g_pl_attr_7 := enrt.pln_attribute7;
940: ben_ext_person.g_pl_attr_8 := enrt.pln_attribute8;
941: ben_ext_person.g_pl_attr_9 := enrt.pln_attribute9;
942: ben_ext_person.g_pl_attr_10 := enrt.pln_attribute10;
943: ben_ext_person.g_ptp_attr_1 := enrt.ptp_attribute1;
944: ben_ext_person.g_ptp_attr_2 := enrt.ptp_attribute2;
937: ben_ext_person.g_pl_attr_5 := enrt.pln_attribute5;
938: ben_ext_person.g_pl_attr_6 := enrt.pln_attribute6;
939: ben_ext_person.g_pl_attr_7 := enrt.pln_attribute7;
940: ben_ext_person.g_pl_attr_8 := enrt.pln_attribute8;
941: ben_ext_person.g_pl_attr_9 := enrt.pln_attribute9;
942: ben_ext_person.g_pl_attr_10 := enrt.pln_attribute10;
943: ben_ext_person.g_ptp_attr_1 := enrt.ptp_attribute1;
944: ben_ext_person.g_ptp_attr_2 := enrt.ptp_attribute2;
945: ben_ext_person.g_ptp_attr_3 := enrt.ptp_attribute3;
938: ben_ext_person.g_pl_attr_6 := enrt.pln_attribute6;
939: ben_ext_person.g_pl_attr_7 := enrt.pln_attribute7;
940: ben_ext_person.g_pl_attr_8 := enrt.pln_attribute8;
941: ben_ext_person.g_pl_attr_9 := enrt.pln_attribute9;
942: ben_ext_person.g_pl_attr_10 := enrt.pln_attribute10;
943: ben_ext_person.g_ptp_attr_1 := enrt.ptp_attribute1;
944: ben_ext_person.g_ptp_attr_2 := enrt.ptp_attribute2;
945: ben_ext_person.g_ptp_attr_3 := enrt.ptp_attribute3;
946: ben_ext_person.g_ptp_attr_4 := enrt.ptp_attribute4;
939: ben_ext_person.g_pl_attr_7 := enrt.pln_attribute7;
940: ben_ext_person.g_pl_attr_8 := enrt.pln_attribute8;
941: ben_ext_person.g_pl_attr_9 := enrt.pln_attribute9;
942: ben_ext_person.g_pl_attr_10 := enrt.pln_attribute10;
943: ben_ext_person.g_ptp_attr_1 := enrt.ptp_attribute1;
944: ben_ext_person.g_ptp_attr_2 := enrt.ptp_attribute2;
945: ben_ext_person.g_ptp_attr_3 := enrt.ptp_attribute3;
946: ben_ext_person.g_ptp_attr_4 := enrt.ptp_attribute4;
947: ben_ext_person.g_ptp_attr_5 := enrt.ptp_attribute5;
940: ben_ext_person.g_pl_attr_8 := enrt.pln_attribute8;
941: ben_ext_person.g_pl_attr_9 := enrt.pln_attribute9;
942: ben_ext_person.g_pl_attr_10 := enrt.pln_attribute10;
943: ben_ext_person.g_ptp_attr_1 := enrt.ptp_attribute1;
944: ben_ext_person.g_ptp_attr_2 := enrt.ptp_attribute2;
945: ben_ext_person.g_ptp_attr_3 := enrt.ptp_attribute3;
946: ben_ext_person.g_ptp_attr_4 := enrt.ptp_attribute4;
947: ben_ext_person.g_ptp_attr_5 := enrt.ptp_attribute5;
948: ben_ext_person.g_ptp_attr_6 := enrt.ptp_attribute6;
941: ben_ext_person.g_pl_attr_9 := enrt.pln_attribute9;
942: ben_ext_person.g_pl_attr_10 := enrt.pln_attribute10;
943: ben_ext_person.g_ptp_attr_1 := enrt.ptp_attribute1;
944: ben_ext_person.g_ptp_attr_2 := enrt.ptp_attribute2;
945: ben_ext_person.g_ptp_attr_3 := enrt.ptp_attribute3;
946: ben_ext_person.g_ptp_attr_4 := enrt.ptp_attribute4;
947: ben_ext_person.g_ptp_attr_5 := enrt.ptp_attribute5;
948: ben_ext_person.g_ptp_attr_6 := enrt.ptp_attribute6;
949: ben_ext_person.g_ptp_attr_7 := enrt.ptp_attribute7;
942: ben_ext_person.g_pl_attr_10 := enrt.pln_attribute10;
943: ben_ext_person.g_ptp_attr_1 := enrt.ptp_attribute1;
944: ben_ext_person.g_ptp_attr_2 := enrt.ptp_attribute2;
945: ben_ext_person.g_ptp_attr_3 := enrt.ptp_attribute3;
946: ben_ext_person.g_ptp_attr_4 := enrt.ptp_attribute4;
947: ben_ext_person.g_ptp_attr_5 := enrt.ptp_attribute5;
948: ben_ext_person.g_ptp_attr_6 := enrt.ptp_attribute6;
949: ben_ext_person.g_ptp_attr_7 := enrt.ptp_attribute7;
950: ben_ext_person.g_ptp_attr_8 := enrt.ptp_attribute8;
943: ben_ext_person.g_ptp_attr_1 := enrt.ptp_attribute1;
944: ben_ext_person.g_ptp_attr_2 := enrt.ptp_attribute2;
945: ben_ext_person.g_ptp_attr_3 := enrt.ptp_attribute3;
946: ben_ext_person.g_ptp_attr_4 := enrt.ptp_attribute4;
947: ben_ext_person.g_ptp_attr_5 := enrt.ptp_attribute5;
948: ben_ext_person.g_ptp_attr_6 := enrt.ptp_attribute6;
949: ben_ext_person.g_ptp_attr_7 := enrt.ptp_attribute7;
950: ben_ext_person.g_ptp_attr_8 := enrt.ptp_attribute8;
951: ben_ext_person.g_ptp_attr_9 := enrt.ptp_attribute9;
944: ben_ext_person.g_ptp_attr_2 := enrt.ptp_attribute2;
945: ben_ext_person.g_ptp_attr_3 := enrt.ptp_attribute3;
946: ben_ext_person.g_ptp_attr_4 := enrt.ptp_attribute4;
947: ben_ext_person.g_ptp_attr_5 := enrt.ptp_attribute5;
948: ben_ext_person.g_ptp_attr_6 := enrt.ptp_attribute6;
949: ben_ext_person.g_ptp_attr_7 := enrt.ptp_attribute7;
950: ben_ext_person.g_ptp_attr_8 := enrt.ptp_attribute8;
951: ben_ext_person.g_ptp_attr_9 := enrt.ptp_attribute9;
952: ben_ext_person.g_ptp_attr_10 := enrt.ptp_attribute10;
945: ben_ext_person.g_ptp_attr_3 := enrt.ptp_attribute3;
946: ben_ext_person.g_ptp_attr_4 := enrt.ptp_attribute4;
947: ben_ext_person.g_ptp_attr_5 := enrt.ptp_attribute5;
948: ben_ext_person.g_ptp_attr_6 := enrt.ptp_attribute6;
949: ben_ext_person.g_ptp_attr_7 := enrt.ptp_attribute7;
950: ben_ext_person.g_ptp_attr_8 := enrt.ptp_attribute8;
951: ben_ext_person.g_ptp_attr_9 := enrt.ptp_attribute9;
952: ben_ext_person.g_ptp_attr_10 := enrt.ptp_attribute10;
953:
946: ben_ext_person.g_ptp_attr_4 := enrt.ptp_attribute4;
947: ben_ext_person.g_ptp_attr_5 := enrt.ptp_attribute5;
948: ben_ext_person.g_ptp_attr_6 := enrt.ptp_attribute6;
949: ben_ext_person.g_ptp_attr_7 := enrt.ptp_attribute7;
950: ben_ext_person.g_ptp_attr_8 := enrt.ptp_attribute8;
951: ben_ext_person.g_ptp_attr_9 := enrt.ptp_attribute9;
952: ben_ext_person.g_ptp_attr_10 := enrt.ptp_attribute10;
953:
954: --
947: ben_ext_person.g_ptp_attr_5 := enrt.ptp_attribute5;
948: ben_ext_person.g_ptp_attr_6 := enrt.ptp_attribute6;
949: ben_ext_person.g_ptp_attr_7 := enrt.ptp_attribute7;
950: ben_ext_person.g_ptp_attr_8 := enrt.ptp_attribute8;
951: ben_ext_person.g_ptp_attr_9 := enrt.ptp_attribute9;
952: ben_ext_person.g_ptp_attr_10 := enrt.ptp_attribute10;
953:
954: --
955: ben_ext_person.g_enrt_lfevt_name := l_pil_rslt.ler_name;
948: ben_ext_person.g_ptp_attr_6 := enrt.ptp_attribute6;
949: ben_ext_person.g_ptp_attr_7 := enrt.ptp_attribute7;
950: ben_ext_person.g_ptp_attr_8 := enrt.ptp_attribute8;
951: ben_ext_person.g_ptp_attr_9 := enrt.ptp_attribute9;
952: ben_ext_person.g_ptp_attr_10 := enrt.ptp_attribute10;
953:
954: --
955: ben_ext_person.g_enrt_lfevt_name := l_pil_rslt.ler_name;
956: ben_ext_person.g_enrt_lfevt_status := l_pil_rslt.per_in_ler_stat_cd;
951: ben_ext_person.g_ptp_attr_9 := enrt.ptp_attribute9;
952: ben_ext_person.g_ptp_attr_10 := enrt.ptp_attribute10;
953:
954: --
955: ben_ext_person.g_enrt_lfevt_name := l_pil_rslt.ler_name;
956: ben_ext_person.g_enrt_lfevt_status := l_pil_rslt.per_in_ler_stat_cd;
957: ben_ext_person.g_enrt_lfevt_note_dt := l_pil_rslt.ntfn_dt;
958: ben_ext_person.g_enrt_lfevt_ocrd_dt := l_pil_rslt.lf_evt_ocrd_dt;
959: --
952: ben_ext_person.g_ptp_attr_10 := enrt.ptp_attribute10;
953:
954: --
955: ben_ext_person.g_enrt_lfevt_name := l_pil_rslt.ler_name;
956: ben_ext_person.g_enrt_lfevt_status := l_pil_rslt.per_in_ler_stat_cd;
957: ben_ext_person.g_enrt_lfevt_note_dt := l_pil_rslt.ntfn_dt;
958: ben_ext_person.g_enrt_lfevt_ocrd_dt := l_pil_rslt.lf_evt_ocrd_dt;
959: --
960: ben_ext_person.g_enrt_opt_id := l_oipl_rslt.opt_id;
953:
954: --
955: ben_ext_person.g_enrt_lfevt_name := l_pil_rslt.ler_name;
956: ben_ext_person.g_enrt_lfevt_status := l_pil_rslt.per_in_ler_stat_cd;
957: ben_ext_person.g_enrt_lfevt_note_dt := l_pil_rslt.ntfn_dt;
958: ben_ext_person.g_enrt_lfevt_ocrd_dt := l_pil_rslt.lf_evt_ocrd_dt;
959: --
960: ben_ext_person.g_enrt_opt_id := l_oipl_rslt.opt_id;
961: ben_ext_person.g_enrt_opt_name := l_oipl_rslt.opt_name;
954: --
955: ben_ext_person.g_enrt_lfevt_name := l_pil_rslt.ler_name;
956: ben_ext_person.g_enrt_lfevt_status := l_pil_rslt.per_in_ler_stat_cd;
957: ben_ext_person.g_enrt_lfevt_note_dt := l_pil_rslt.ntfn_dt;
958: ben_ext_person.g_enrt_lfevt_ocrd_dt := l_pil_rslt.lf_evt_ocrd_dt;
959: --
960: ben_ext_person.g_enrt_opt_id := l_oipl_rslt.opt_id;
961: ben_ext_person.g_enrt_opt_name := l_oipl_rslt.opt_name;
962: ben_ext_person.g_oipl_attr_1 := l_oipl_rslt.cop_attribute1;
956: ben_ext_person.g_enrt_lfevt_status := l_pil_rslt.per_in_ler_stat_cd;
957: ben_ext_person.g_enrt_lfevt_note_dt := l_pil_rslt.ntfn_dt;
958: ben_ext_person.g_enrt_lfevt_ocrd_dt := l_pil_rslt.lf_evt_ocrd_dt;
959: --
960: ben_ext_person.g_enrt_opt_id := l_oipl_rslt.opt_id;
961: ben_ext_person.g_enrt_opt_name := l_oipl_rslt.opt_name;
962: ben_ext_person.g_oipl_attr_1 := l_oipl_rslt.cop_attribute1;
963: ben_ext_person.g_oipl_attr_2 := l_oipl_rslt.cop_attribute2;
964: ben_ext_person.g_oipl_attr_3 := l_oipl_rslt.cop_attribute3;
957: ben_ext_person.g_enrt_lfevt_note_dt := l_pil_rslt.ntfn_dt;
958: ben_ext_person.g_enrt_lfevt_ocrd_dt := l_pil_rslt.lf_evt_ocrd_dt;
959: --
960: ben_ext_person.g_enrt_opt_id := l_oipl_rslt.opt_id;
961: ben_ext_person.g_enrt_opt_name := l_oipl_rslt.opt_name;
962: ben_ext_person.g_oipl_attr_1 := l_oipl_rslt.cop_attribute1;
963: ben_ext_person.g_oipl_attr_2 := l_oipl_rslt.cop_attribute2;
964: ben_ext_person.g_oipl_attr_3 := l_oipl_rslt.cop_attribute3;
965: ben_ext_person.g_oipl_attr_4 := l_oipl_rslt.cop_attribute4;
958: ben_ext_person.g_enrt_lfevt_ocrd_dt := l_pil_rslt.lf_evt_ocrd_dt;
959: --
960: ben_ext_person.g_enrt_opt_id := l_oipl_rslt.opt_id;
961: ben_ext_person.g_enrt_opt_name := l_oipl_rslt.opt_name;
962: ben_ext_person.g_oipl_attr_1 := l_oipl_rslt.cop_attribute1;
963: ben_ext_person.g_oipl_attr_2 := l_oipl_rslt.cop_attribute2;
964: ben_ext_person.g_oipl_attr_3 := l_oipl_rslt.cop_attribute3;
965: ben_ext_person.g_oipl_attr_4 := l_oipl_rslt.cop_attribute4;
966: ben_ext_person.g_oipl_attr_5 := l_oipl_rslt.cop_attribute5;
959: --
960: ben_ext_person.g_enrt_opt_id := l_oipl_rslt.opt_id;
961: ben_ext_person.g_enrt_opt_name := l_oipl_rslt.opt_name;
962: ben_ext_person.g_oipl_attr_1 := l_oipl_rslt.cop_attribute1;
963: ben_ext_person.g_oipl_attr_2 := l_oipl_rslt.cop_attribute2;
964: ben_ext_person.g_oipl_attr_3 := l_oipl_rslt.cop_attribute3;
965: ben_ext_person.g_oipl_attr_4 := l_oipl_rslt.cop_attribute4;
966: ben_ext_person.g_oipl_attr_5 := l_oipl_rslt.cop_attribute5;
967: ben_ext_person.g_oipl_attr_6 := l_oipl_rslt.cop_attribute6;
960: ben_ext_person.g_enrt_opt_id := l_oipl_rslt.opt_id;
961: ben_ext_person.g_enrt_opt_name := l_oipl_rslt.opt_name;
962: ben_ext_person.g_oipl_attr_1 := l_oipl_rslt.cop_attribute1;
963: ben_ext_person.g_oipl_attr_2 := l_oipl_rslt.cop_attribute2;
964: ben_ext_person.g_oipl_attr_3 := l_oipl_rslt.cop_attribute3;
965: ben_ext_person.g_oipl_attr_4 := l_oipl_rslt.cop_attribute4;
966: ben_ext_person.g_oipl_attr_5 := l_oipl_rslt.cop_attribute5;
967: ben_ext_person.g_oipl_attr_6 := l_oipl_rslt.cop_attribute6;
968: ben_ext_person.g_oipl_attr_7 := l_oipl_rslt.cop_attribute7;
961: ben_ext_person.g_enrt_opt_name := l_oipl_rslt.opt_name;
962: ben_ext_person.g_oipl_attr_1 := l_oipl_rslt.cop_attribute1;
963: ben_ext_person.g_oipl_attr_2 := l_oipl_rslt.cop_attribute2;
964: ben_ext_person.g_oipl_attr_3 := l_oipl_rslt.cop_attribute3;
965: ben_ext_person.g_oipl_attr_4 := l_oipl_rslt.cop_attribute4;
966: ben_ext_person.g_oipl_attr_5 := l_oipl_rslt.cop_attribute5;
967: ben_ext_person.g_oipl_attr_6 := l_oipl_rslt.cop_attribute6;
968: ben_ext_person.g_oipl_attr_7 := l_oipl_rslt.cop_attribute7;
969: ben_ext_person.g_oipl_attr_8 := l_oipl_rslt.cop_attribute8;
962: ben_ext_person.g_oipl_attr_1 := l_oipl_rslt.cop_attribute1;
963: ben_ext_person.g_oipl_attr_2 := l_oipl_rslt.cop_attribute2;
964: ben_ext_person.g_oipl_attr_3 := l_oipl_rslt.cop_attribute3;
965: ben_ext_person.g_oipl_attr_4 := l_oipl_rslt.cop_attribute4;
966: ben_ext_person.g_oipl_attr_5 := l_oipl_rslt.cop_attribute5;
967: ben_ext_person.g_oipl_attr_6 := l_oipl_rslt.cop_attribute6;
968: ben_ext_person.g_oipl_attr_7 := l_oipl_rslt.cop_attribute7;
969: ben_ext_person.g_oipl_attr_8 := l_oipl_rslt.cop_attribute8;
970: ben_ext_person.g_oipl_attr_9 := l_oipl_rslt.cop_attribute9;
963: ben_ext_person.g_oipl_attr_2 := l_oipl_rslt.cop_attribute2;
964: ben_ext_person.g_oipl_attr_3 := l_oipl_rslt.cop_attribute3;
965: ben_ext_person.g_oipl_attr_4 := l_oipl_rslt.cop_attribute4;
966: ben_ext_person.g_oipl_attr_5 := l_oipl_rslt.cop_attribute5;
967: ben_ext_person.g_oipl_attr_6 := l_oipl_rslt.cop_attribute6;
968: ben_ext_person.g_oipl_attr_7 := l_oipl_rslt.cop_attribute7;
969: ben_ext_person.g_oipl_attr_8 := l_oipl_rslt.cop_attribute8;
970: ben_ext_person.g_oipl_attr_9 := l_oipl_rslt.cop_attribute9;
971: ben_ext_person.g_oipl_attr_10 := l_oipl_rslt.cop_attribute10;
964: ben_ext_person.g_oipl_attr_3 := l_oipl_rslt.cop_attribute3;
965: ben_ext_person.g_oipl_attr_4 := l_oipl_rslt.cop_attribute4;
966: ben_ext_person.g_oipl_attr_5 := l_oipl_rslt.cop_attribute5;
967: ben_ext_person.g_oipl_attr_6 := l_oipl_rslt.cop_attribute6;
968: ben_ext_person.g_oipl_attr_7 := l_oipl_rslt.cop_attribute7;
969: ben_ext_person.g_oipl_attr_8 := l_oipl_rslt.cop_attribute8;
970: ben_ext_person.g_oipl_attr_9 := l_oipl_rslt.cop_attribute9;
971: ben_ext_person.g_oipl_attr_10 := l_oipl_rslt.cop_attribute10;
972: ben_ext_person.g_opt_attr_1 := l_oipl_rslt.opt_attribute1;
965: ben_ext_person.g_oipl_attr_4 := l_oipl_rslt.cop_attribute4;
966: ben_ext_person.g_oipl_attr_5 := l_oipl_rslt.cop_attribute5;
967: ben_ext_person.g_oipl_attr_6 := l_oipl_rslt.cop_attribute6;
968: ben_ext_person.g_oipl_attr_7 := l_oipl_rslt.cop_attribute7;
969: ben_ext_person.g_oipl_attr_8 := l_oipl_rslt.cop_attribute8;
970: ben_ext_person.g_oipl_attr_9 := l_oipl_rslt.cop_attribute9;
971: ben_ext_person.g_oipl_attr_10 := l_oipl_rslt.cop_attribute10;
972: ben_ext_person.g_opt_attr_1 := l_oipl_rslt.opt_attribute1;
973: ben_ext_person.g_opt_attr_2 := l_oipl_rslt.opt_attribute2;
966: ben_ext_person.g_oipl_attr_5 := l_oipl_rslt.cop_attribute5;
967: ben_ext_person.g_oipl_attr_6 := l_oipl_rslt.cop_attribute6;
968: ben_ext_person.g_oipl_attr_7 := l_oipl_rslt.cop_attribute7;
969: ben_ext_person.g_oipl_attr_8 := l_oipl_rslt.cop_attribute8;
970: ben_ext_person.g_oipl_attr_9 := l_oipl_rslt.cop_attribute9;
971: ben_ext_person.g_oipl_attr_10 := l_oipl_rslt.cop_attribute10;
972: ben_ext_person.g_opt_attr_1 := l_oipl_rslt.opt_attribute1;
973: ben_ext_person.g_opt_attr_2 := l_oipl_rslt.opt_attribute2;
974: ben_ext_person.g_opt_attr_3 := l_oipl_rslt.opt_attribute3;
967: ben_ext_person.g_oipl_attr_6 := l_oipl_rslt.cop_attribute6;
968: ben_ext_person.g_oipl_attr_7 := l_oipl_rslt.cop_attribute7;
969: ben_ext_person.g_oipl_attr_8 := l_oipl_rslt.cop_attribute8;
970: ben_ext_person.g_oipl_attr_9 := l_oipl_rslt.cop_attribute9;
971: ben_ext_person.g_oipl_attr_10 := l_oipl_rslt.cop_attribute10;
972: ben_ext_person.g_opt_attr_1 := l_oipl_rslt.opt_attribute1;
973: ben_ext_person.g_opt_attr_2 := l_oipl_rslt.opt_attribute2;
974: ben_ext_person.g_opt_attr_3 := l_oipl_rslt.opt_attribute3;
975: ben_ext_person.g_opt_attr_4 := l_oipl_rslt.opt_attribute4;
968: ben_ext_person.g_oipl_attr_7 := l_oipl_rslt.cop_attribute7;
969: ben_ext_person.g_oipl_attr_8 := l_oipl_rslt.cop_attribute8;
970: ben_ext_person.g_oipl_attr_9 := l_oipl_rslt.cop_attribute9;
971: ben_ext_person.g_oipl_attr_10 := l_oipl_rslt.cop_attribute10;
972: ben_ext_person.g_opt_attr_1 := l_oipl_rslt.opt_attribute1;
973: ben_ext_person.g_opt_attr_2 := l_oipl_rslt.opt_attribute2;
974: ben_ext_person.g_opt_attr_3 := l_oipl_rslt.opt_attribute3;
975: ben_ext_person.g_opt_attr_4 := l_oipl_rslt.opt_attribute4;
976: ben_ext_person.g_opt_attr_5 := l_oipl_rslt.opt_attribute5;
969: ben_ext_person.g_oipl_attr_8 := l_oipl_rslt.cop_attribute8;
970: ben_ext_person.g_oipl_attr_9 := l_oipl_rslt.cop_attribute9;
971: ben_ext_person.g_oipl_attr_10 := l_oipl_rslt.cop_attribute10;
972: ben_ext_person.g_opt_attr_1 := l_oipl_rslt.opt_attribute1;
973: ben_ext_person.g_opt_attr_2 := l_oipl_rslt.opt_attribute2;
974: ben_ext_person.g_opt_attr_3 := l_oipl_rslt.opt_attribute3;
975: ben_ext_person.g_opt_attr_4 := l_oipl_rslt.opt_attribute4;
976: ben_ext_person.g_opt_attr_5 := l_oipl_rslt.opt_attribute5;
977: ben_ext_person.g_opt_attr_6 := l_oipl_rslt.opt_attribute6;
970: ben_ext_person.g_oipl_attr_9 := l_oipl_rslt.cop_attribute9;
971: ben_ext_person.g_oipl_attr_10 := l_oipl_rslt.cop_attribute10;
972: ben_ext_person.g_opt_attr_1 := l_oipl_rslt.opt_attribute1;
973: ben_ext_person.g_opt_attr_2 := l_oipl_rslt.opt_attribute2;
974: ben_ext_person.g_opt_attr_3 := l_oipl_rslt.opt_attribute3;
975: ben_ext_person.g_opt_attr_4 := l_oipl_rslt.opt_attribute4;
976: ben_ext_person.g_opt_attr_5 := l_oipl_rslt.opt_attribute5;
977: ben_ext_person.g_opt_attr_6 := l_oipl_rslt.opt_attribute6;
978: ben_ext_person.g_opt_attr_7 := l_oipl_rslt.opt_attribute7;
971: ben_ext_person.g_oipl_attr_10 := l_oipl_rslt.cop_attribute10;
972: ben_ext_person.g_opt_attr_1 := l_oipl_rslt.opt_attribute1;
973: ben_ext_person.g_opt_attr_2 := l_oipl_rslt.opt_attribute2;
974: ben_ext_person.g_opt_attr_3 := l_oipl_rslt.opt_attribute3;
975: ben_ext_person.g_opt_attr_4 := l_oipl_rslt.opt_attribute4;
976: ben_ext_person.g_opt_attr_5 := l_oipl_rslt.opt_attribute5;
977: ben_ext_person.g_opt_attr_6 := l_oipl_rslt.opt_attribute6;
978: ben_ext_person.g_opt_attr_7 := l_oipl_rslt.opt_attribute7;
979: ben_ext_person.g_opt_attr_8 := l_oipl_rslt.opt_attribute8;
972: ben_ext_person.g_opt_attr_1 := l_oipl_rslt.opt_attribute1;
973: ben_ext_person.g_opt_attr_2 := l_oipl_rslt.opt_attribute2;
974: ben_ext_person.g_opt_attr_3 := l_oipl_rslt.opt_attribute3;
975: ben_ext_person.g_opt_attr_4 := l_oipl_rslt.opt_attribute4;
976: ben_ext_person.g_opt_attr_5 := l_oipl_rslt.opt_attribute5;
977: ben_ext_person.g_opt_attr_6 := l_oipl_rslt.opt_attribute6;
978: ben_ext_person.g_opt_attr_7 := l_oipl_rslt.opt_attribute7;
979: ben_ext_person.g_opt_attr_8 := l_oipl_rslt.opt_attribute8;
980: ben_ext_person.g_opt_attr_9 := l_oipl_rslt.opt_attribute9;
973: ben_ext_person.g_opt_attr_2 := l_oipl_rslt.opt_attribute2;
974: ben_ext_person.g_opt_attr_3 := l_oipl_rslt.opt_attribute3;
975: ben_ext_person.g_opt_attr_4 := l_oipl_rslt.opt_attribute4;
976: ben_ext_person.g_opt_attr_5 := l_oipl_rslt.opt_attribute5;
977: ben_ext_person.g_opt_attr_6 := l_oipl_rslt.opt_attribute6;
978: ben_ext_person.g_opt_attr_7 := l_oipl_rslt.opt_attribute7;
979: ben_ext_person.g_opt_attr_8 := l_oipl_rslt.opt_attribute8;
980: ben_ext_person.g_opt_attr_9 := l_oipl_rslt.opt_attribute9;
981: ben_ext_person.g_opt_attr_10 := l_oipl_rslt.opt_attribute10;
974: ben_ext_person.g_opt_attr_3 := l_oipl_rslt.opt_attribute3;
975: ben_ext_person.g_opt_attr_4 := l_oipl_rslt.opt_attribute4;
976: ben_ext_person.g_opt_attr_5 := l_oipl_rslt.opt_attribute5;
977: ben_ext_person.g_opt_attr_6 := l_oipl_rslt.opt_attribute6;
978: ben_ext_person.g_opt_attr_7 := l_oipl_rslt.opt_attribute7;
979: ben_ext_person.g_opt_attr_8 := l_oipl_rslt.opt_attribute8;
980: ben_ext_person.g_opt_attr_9 := l_oipl_rslt.opt_attribute9;
981: ben_ext_person.g_opt_attr_10 := l_oipl_rslt.opt_attribute10;
982: ben_ext_person.g_enrt_opt_fd_name := l_oipl_rslt.opt_fd_name ;
975: ben_ext_person.g_opt_attr_4 := l_oipl_rslt.opt_attribute4;
976: ben_ext_person.g_opt_attr_5 := l_oipl_rslt.opt_attribute5;
977: ben_ext_person.g_opt_attr_6 := l_oipl_rslt.opt_attribute6;
978: ben_ext_person.g_opt_attr_7 := l_oipl_rslt.opt_attribute7;
979: ben_ext_person.g_opt_attr_8 := l_oipl_rslt.opt_attribute8;
980: ben_ext_person.g_opt_attr_9 := l_oipl_rslt.opt_attribute9;
981: ben_ext_person.g_opt_attr_10 := l_oipl_rslt.opt_attribute10;
982: ben_ext_person.g_enrt_opt_fd_name := l_oipl_rslt.opt_fd_name ;
983: ben_ext_person.g_enrt_opt_fd_code := l_oipl_rslt.opt_fd_code ;
976: ben_ext_person.g_opt_attr_5 := l_oipl_rslt.opt_attribute5;
977: ben_ext_person.g_opt_attr_6 := l_oipl_rslt.opt_attribute6;
978: ben_ext_person.g_opt_attr_7 := l_oipl_rslt.opt_attribute7;
979: ben_ext_person.g_opt_attr_8 := l_oipl_rslt.opt_attribute8;
980: ben_ext_person.g_opt_attr_9 := l_oipl_rslt.opt_attribute9;
981: ben_ext_person.g_opt_attr_10 := l_oipl_rslt.opt_attribute10;
982: ben_ext_person.g_enrt_opt_fd_name := l_oipl_rslt.opt_fd_name ;
983: ben_ext_person.g_enrt_opt_fd_code := l_oipl_rslt.opt_fd_code ;
984: ben_ext_person.g_enrt_opt_pl_fd_name := l_oipl_rslt.oipl_fd_name ;
977: ben_ext_person.g_opt_attr_6 := l_oipl_rslt.opt_attribute6;
978: ben_ext_person.g_opt_attr_7 := l_oipl_rslt.opt_attribute7;
979: ben_ext_person.g_opt_attr_8 := l_oipl_rslt.opt_attribute8;
980: ben_ext_person.g_opt_attr_9 := l_oipl_rslt.opt_attribute9;
981: ben_ext_person.g_opt_attr_10 := l_oipl_rslt.opt_attribute10;
982: ben_ext_person.g_enrt_opt_fd_name := l_oipl_rslt.opt_fd_name ;
983: ben_ext_person.g_enrt_opt_fd_code := l_oipl_rslt.opt_fd_code ;
984: ben_ext_person.g_enrt_opt_pl_fd_name := l_oipl_rslt.oipl_fd_name ;
985: ben_ext_person.g_enrt_opt_pl_fd_code := l_oipl_rslt.oipl_fd_code ;
978: ben_ext_person.g_opt_attr_7 := l_oipl_rslt.opt_attribute7;
979: ben_ext_person.g_opt_attr_8 := l_oipl_rslt.opt_attribute8;
980: ben_ext_person.g_opt_attr_9 := l_oipl_rslt.opt_attribute9;
981: ben_ext_person.g_opt_attr_10 := l_oipl_rslt.opt_attribute10;
982: ben_ext_person.g_enrt_opt_fd_name := l_oipl_rslt.opt_fd_name ;
983: ben_ext_person.g_enrt_opt_fd_code := l_oipl_rslt.opt_fd_code ;
984: ben_ext_person.g_enrt_opt_pl_fd_name := l_oipl_rslt.oipl_fd_name ;
985: ben_ext_person.g_enrt_opt_pl_fd_code := l_oipl_rslt.oipl_fd_code ;
986: --2559743
979: ben_ext_person.g_opt_attr_8 := l_oipl_rslt.opt_attribute8;
980: ben_ext_person.g_opt_attr_9 := l_oipl_rslt.opt_attribute9;
981: ben_ext_person.g_opt_attr_10 := l_oipl_rslt.opt_attribute10;
982: ben_ext_person.g_enrt_opt_fd_name := l_oipl_rslt.opt_fd_name ;
983: ben_ext_person.g_enrt_opt_fd_code := l_oipl_rslt.opt_fd_code ;
984: ben_ext_person.g_enrt_opt_pl_fd_name := l_oipl_rslt.oipl_fd_name ;
985: ben_ext_person.g_enrt_opt_pl_fd_code := l_oipl_rslt.oipl_fd_code ;
986: --2559743
987: ben_ext_person.g_enrt_pl_fd_name := enrt.pl_fd_name ;
980: ben_ext_person.g_opt_attr_9 := l_oipl_rslt.opt_attribute9;
981: ben_ext_person.g_opt_attr_10 := l_oipl_rslt.opt_attribute10;
982: ben_ext_person.g_enrt_opt_fd_name := l_oipl_rslt.opt_fd_name ;
983: ben_ext_person.g_enrt_opt_fd_code := l_oipl_rslt.opt_fd_code ;
984: ben_ext_person.g_enrt_opt_pl_fd_name := l_oipl_rslt.oipl_fd_name ;
985: ben_ext_person.g_enrt_opt_pl_fd_code := l_oipl_rslt.oipl_fd_code ;
986: --2559743
987: ben_ext_person.g_enrt_pl_fd_name := enrt.pl_fd_name ;
988: ben_ext_person.g_enrt_pl_fd_code := enrt.pl_fd_code ;
981: ben_ext_person.g_opt_attr_10 := l_oipl_rslt.opt_attribute10;
982: ben_ext_person.g_enrt_opt_fd_name := l_oipl_rslt.opt_fd_name ;
983: ben_ext_person.g_enrt_opt_fd_code := l_oipl_rslt.opt_fd_code ;
984: ben_ext_person.g_enrt_opt_pl_fd_name := l_oipl_rslt.oipl_fd_name ;
985: ben_ext_person.g_enrt_opt_pl_fd_code := l_oipl_rslt.oipl_fd_code ;
986: --2559743
987: ben_ext_person.g_enrt_pl_fd_name := enrt.pl_fd_name ;
988: ben_ext_person.g_enrt_pl_fd_code := enrt.pl_fd_code ;
989: ben_ext_person.g_enrt_pl_typ_fd_name := enrt.ptp_fd_name ;
983: ben_ext_person.g_enrt_opt_fd_code := l_oipl_rslt.opt_fd_code ;
984: ben_ext_person.g_enrt_opt_pl_fd_name := l_oipl_rslt.oipl_fd_name ;
985: ben_ext_person.g_enrt_opt_pl_fd_code := l_oipl_rslt.oipl_fd_code ;
986: --2559743
987: ben_ext_person.g_enrt_pl_fd_name := enrt.pl_fd_name ;
988: ben_ext_person.g_enrt_pl_fd_code := enrt.pl_fd_code ;
989: ben_ext_person.g_enrt_pl_typ_fd_name := enrt.ptp_fd_name ;
990: ben_ext_person.g_enrt_pl_typ_fd_code := enrt.ptp_fd_code ;
991: ----
984: ben_ext_person.g_enrt_opt_pl_fd_name := l_oipl_rslt.oipl_fd_name ;
985: ben_ext_person.g_enrt_opt_pl_fd_code := l_oipl_rslt.oipl_fd_code ;
986: --2559743
987: ben_ext_person.g_enrt_pl_fd_name := enrt.pl_fd_name ;
988: ben_ext_person.g_enrt_pl_fd_code := enrt.pl_fd_code ;
989: ben_ext_person.g_enrt_pl_typ_fd_name := enrt.ptp_fd_name ;
990: ben_ext_person.g_enrt_pl_typ_fd_code := enrt.ptp_fd_code ;
991: ----
992:
985: ben_ext_person.g_enrt_opt_pl_fd_code := l_oipl_rslt.oipl_fd_code ;
986: --2559743
987: ben_ext_person.g_enrt_pl_fd_name := enrt.pl_fd_name ;
988: ben_ext_person.g_enrt_pl_fd_code := enrt.pl_fd_code ;
989: ben_ext_person.g_enrt_pl_typ_fd_name := enrt.ptp_fd_name ;
990: ben_ext_person.g_enrt_pl_typ_fd_code := enrt.ptp_fd_code ;
991: ----
992:
993: if enrt.pgm_id is not null then
986: --2559743
987: ben_ext_person.g_enrt_pl_fd_name := enrt.pl_fd_name ;
988: ben_ext_person.g_enrt_pl_fd_code := enrt.pl_fd_code ;
989: ben_ext_person.g_enrt_pl_typ_fd_name := enrt.ptp_fd_name ;
990: ben_ext_person.g_enrt_pl_typ_fd_code := enrt.ptp_fd_code ;
991: ----
992:
993: if enrt.pgm_id is not null then
994: open c_pgm_rslt(enrt.pgm_id ) ;
992:
993: if enrt.pgm_id is not null then
994: open c_pgm_rslt(enrt.pgm_id ) ;
995: fetch c_pgm_rslt into
996: ben_ext_person.g_enrt_pgm_name
997: , ben_ext_person.g_enrt_pgm_fd_name
998: , ben_ext_person.g_enrt_pgm_fd_code
999: , ben_ext_person.g_pgm_attr_1
1000: , ben_ext_person.g_pgm_attr_2
993: if enrt.pgm_id is not null then
994: open c_pgm_rslt(enrt.pgm_id ) ;
995: fetch c_pgm_rslt into
996: ben_ext_person.g_enrt_pgm_name
997: , ben_ext_person.g_enrt_pgm_fd_name
998: , ben_ext_person.g_enrt_pgm_fd_code
999: , ben_ext_person.g_pgm_attr_1
1000: , ben_ext_person.g_pgm_attr_2
1001: , ben_ext_person.g_pgm_attr_3
994: open c_pgm_rslt(enrt.pgm_id ) ;
995: fetch c_pgm_rslt into
996: ben_ext_person.g_enrt_pgm_name
997: , ben_ext_person.g_enrt_pgm_fd_name
998: , ben_ext_person.g_enrt_pgm_fd_code
999: , ben_ext_person.g_pgm_attr_1
1000: , ben_ext_person.g_pgm_attr_2
1001: , ben_ext_person.g_pgm_attr_3
1002: , ben_ext_person.g_pgm_attr_4
995: fetch c_pgm_rslt into
996: ben_ext_person.g_enrt_pgm_name
997: , ben_ext_person.g_enrt_pgm_fd_name
998: , ben_ext_person.g_enrt_pgm_fd_code
999: , ben_ext_person.g_pgm_attr_1
1000: , ben_ext_person.g_pgm_attr_2
1001: , ben_ext_person.g_pgm_attr_3
1002: , ben_ext_person.g_pgm_attr_4
1003: , ben_ext_person.g_pgm_attr_5
996: ben_ext_person.g_enrt_pgm_name
997: , ben_ext_person.g_enrt_pgm_fd_name
998: , ben_ext_person.g_enrt_pgm_fd_code
999: , ben_ext_person.g_pgm_attr_1
1000: , ben_ext_person.g_pgm_attr_2
1001: , ben_ext_person.g_pgm_attr_3
1002: , ben_ext_person.g_pgm_attr_4
1003: , ben_ext_person.g_pgm_attr_5
1004: , ben_ext_person.g_pgm_attr_6
997: , ben_ext_person.g_enrt_pgm_fd_name
998: , ben_ext_person.g_enrt_pgm_fd_code
999: , ben_ext_person.g_pgm_attr_1
1000: , ben_ext_person.g_pgm_attr_2
1001: , ben_ext_person.g_pgm_attr_3
1002: , ben_ext_person.g_pgm_attr_4
1003: , ben_ext_person.g_pgm_attr_5
1004: , ben_ext_person.g_pgm_attr_6
1005: , ben_ext_person.g_pgm_attr_7
998: , ben_ext_person.g_enrt_pgm_fd_code
999: , ben_ext_person.g_pgm_attr_1
1000: , ben_ext_person.g_pgm_attr_2
1001: , ben_ext_person.g_pgm_attr_3
1002: , ben_ext_person.g_pgm_attr_4
1003: , ben_ext_person.g_pgm_attr_5
1004: , ben_ext_person.g_pgm_attr_6
1005: , ben_ext_person.g_pgm_attr_7
1006: , ben_ext_person.g_pgm_attr_8
999: , ben_ext_person.g_pgm_attr_1
1000: , ben_ext_person.g_pgm_attr_2
1001: , ben_ext_person.g_pgm_attr_3
1002: , ben_ext_person.g_pgm_attr_4
1003: , ben_ext_person.g_pgm_attr_5
1004: , ben_ext_person.g_pgm_attr_6
1005: , ben_ext_person.g_pgm_attr_7
1006: , ben_ext_person.g_pgm_attr_8
1007: , ben_ext_person.g_pgm_attr_9
1000: , ben_ext_person.g_pgm_attr_2
1001: , ben_ext_person.g_pgm_attr_3
1002: , ben_ext_person.g_pgm_attr_4
1003: , ben_ext_person.g_pgm_attr_5
1004: , ben_ext_person.g_pgm_attr_6
1005: , ben_ext_person.g_pgm_attr_7
1006: , ben_ext_person.g_pgm_attr_8
1007: , ben_ext_person.g_pgm_attr_9
1008: , ben_ext_person.g_pgm_attr_10
1001: , ben_ext_person.g_pgm_attr_3
1002: , ben_ext_person.g_pgm_attr_4
1003: , ben_ext_person.g_pgm_attr_5
1004: , ben_ext_person.g_pgm_attr_6
1005: , ben_ext_person.g_pgm_attr_7
1006: , ben_ext_person.g_pgm_attr_8
1007: , ben_ext_person.g_pgm_attr_9
1008: , ben_ext_person.g_pgm_attr_10
1009: ;
1002: , ben_ext_person.g_pgm_attr_4
1003: , ben_ext_person.g_pgm_attr_5
1004: , ben_ext_person.g_pgm_attr_6
1005: , ben_ext_person.g_pgm_attr_7
1006: , ben_ext_person.g_pgm_attr_8
1007: , ben_ext_person.g_pgm_attr_9
1008: , ben_ext_person.g_pgm_attr_10
1009: ;
1010: close c_pgm_rslt ;
1003: , ben_ext_person.g_pgm_attr_5
1004: , ben_ext_person.g_pgm_attr_6
1005: , ben_ext_person.g_pgm_attr_7
1006: , ben_ext_person.g_pgm_attr_8
1007: , ben_ext_person.g_pgm_attr_9
1008: , ben_ext_person.g_pgm_attr_10
1009: ;
1010: close c_pgm_rslt ;
1011: end if ;
1004: , ben_ext_person.g_pgm_attr_6
1005: , ben_ext_person.g_pgm_attr_7
1006: , ben_ext_person.g_pgm_attr_8
1007: , ben_ext_person.g_pgm_attr_9
1008: , ben_ext_person.g_pgm_attr_10
1009: ;
1010: close c_pgm_rslt ;
1011: end if ;
1012:
1013: if enrt.pgm_id is not null and enrt.pl_id is not null then
1014: open c_plip_rslt (enrt.pgm_id ,
1015: enrt.pl_id ) ;
1016: fetch c_plip_rslt into
1017: ben_ext_person.g_plip_attr_1
1018: ,ben_ext_person.g_plip_attr_2
1019: ,ben_ext_person.g_plip_attr_3
1020: ,ben_ext_person.g_plip_attr_4
1021: ,ben_ext_person.g_plip_attr_5
1014: open c_plip_rslt (enrt.pgm_id ,
1015: enrt.pl_id ) ;
1016: fetch c_plip_rslt into
1017: ben_ext_person.g_plip_attr_1
1018: ,ben_ext_person.g_plip_attr_2
1019: ,ben_ext_person.g_plip_attr_3
1020: ,ben_ext_person.g_plip_attr_4
1021: ,ben_ext_person.g_plip_attr_5
1022: ,ben_ext_person.g_plip_attr_6
1015: enrt.pl_id ) ;
1016: fetch c_plip_rslt into
1017: ben_ext_person.g_plip_attr_1
1018: ,ben_ext_person.g_plip_attr_2
1019: ,ben_ext_person.g_plip_attr_3
1020: ,ben_ext_person.g_plip_attr_4
1021: ,ben_ext_person.g_plip_attr_5
1022: ,ben_ext_person.g_plip_attr_6
1023: ,ben_ext_person.g_plip_attr_7
1016: fetch c_plip_rslt into
1017: ben_ext_person.g_plip_attr_1
1018: ,ben_ext_person.g_plip_attr_2
1019: ,ben_ext_person.g_plip_attr_3
1020: ,ben_ext_person.g_plip_attr_4
1021: ,ben_ext_person.g_plip_attr_5
1022: ,ben_ext_person.g_plip_attr_6
1023: ,ben_ext_person.g_plip_attr_7
1024: ,ben_ext_person.g_plip_attr_8
1017: ben_ext_person.g_plip_attr_1
1018: ,ben_ext_person.g_plip_attr_2
1019: ,ben_ext_person.g_plip_attr_3
1020: ,ben_ext_person.g_plip_attr_4
1021: ,ben_ext_person.g_plip_attr_5
1022: ,ben_ext_person.g_plip_attr_6
1023: ,ben_ext_person.g_plip_attr_7
1024: ,ben_ext_person.g_plip_attr_8
1025: ,ben_ext_person.g_plip_attr_9
1018: ,ben_ext_person.g_plip_attr_2
1019: ,ben_ext_person.g_plip_attr_3
1020: ,ben_ext_person.g_plip_attr_4
1021: ,ben_ext_person.g_plip_attr_5
1022: ,ben_ext_person.g_plip_attr_6
1023: ,ben_ext_person.g_plip_attr_7
1024: ,ben_ext_person.g_plip_attr_8
1025: ,ben_ext_person.g_plip_attr_9
1026: ,ben_ext_person.g_plip_attr_10
1019: ,ben_ext_person.g_plip_attr_3
1020: ,ben_ext_person.g_plip_attr_4
1021: ,ben_ext_person.g_plip_attr_5
1022: ,ben_ext_person.g_plip_attr_6
1023: ,ben_ext_person.g_plip_attr_7
1024: ,ben_ext_person.g_plip_attr_8
1025: ,ben_ext_person.g_plip_attr_9
1026: ,ben_ext_person.g_plip_attr_10
1027: ,ben_ext_person.g_enrt_pl_pgm_fd_name
1020: ,ben_ext_person.g_plip_attr_4
1021: ,ben_ext_person.g_plip_attr_5
1022: ,ben_ext_person.g_plip_attr_6
1023: ,ben_ext_person.g_plip_attr_7
1024: ,ben_ext_person.g_plip_attr_8
1025: ,ben_ext_person.g_plip_attr_9
1026: ,ben_ext_person.g_plip_attr_10
1027: ,ben_ext_person.g_enrt_pl_pgm_fd_name
1028: ,ben_ext_person.g_enrt_pl_pgm_fd_code
1021: ,ben_ext_person.g_plip_attr_5
1022: ,ben_ext_person.g_plip_attr_6
1023: ,ben_ext_person.g_plip_attr_7
1024: ,ben_ext_person.g_plip_attr_8
1025: ,ben_ext_person.g_plip_attr_9
1026: ,ben_ext_person.g_plip_attr_10
1027: ,ben_ext_person.g_enrt_pl_pgm_fd_name
1028: ,ben_ext_person.g_enrt_pl_pgm_fd_code
1029: ;
1022: ,ben_ext_person.g_plip_attr_6
1023: ,ben_ext_person.g_plip_attr_7
1024: ,ben_ext_person.g_plip_attr_8
1025: ,ben_ext_person.g_plip_attr_9
1026: ,ben_ext_person.g_plip_attr_10
1027: ,ben_ext_person.g_enrt_pl_pgm_fd_name
1028: ,ben_ext_person.g_enrt_pl_pgm_fd_code
1029: ;
1030: close c_plip_rslt ;
1023: ,ben_ext_person.g_plip_attr_7
1024: ,ben_ext_person.g_plip_attr_8
1025: ,ben_ext_person.g_plip_attr_9
1026: ,ben_ext_person.g_plip_attr_10
1027: ,ben_ext_person.g_enrt_pl_pgm_fd_name
1028: ,ben_ext_person.g_enrt_pl_pgm_fd_code
1029: ;
1030: close c_plip_rslt ;
1031: end if ;
1024: ,ben_ext_person.g_plip_attr_8
1025: ,ben_ext_person.g_plip_attr_9
1026: ,ben_ext_person.g_plip_attr_10
1027: ,ben_ext_person.g_enrt_pl_pgm_fd_name
1028: ,ben_ext_person.g_enrt_pl_pgm_fd_code
1029: ;
1030: close c_plip_rslt ;
1031: end if ;
1032:
1032:
1033: open c_popl_rslt(enrt.pgm_id ,
1034: enrt.pl_id ,
1035: enrt.per_in_ler_id ) ;
1036: fetch c_popl_rslt into ben_ext_person.g_enrt_elec_made_dt ;
1037:
1038: close c_popl_rslt ;
1039:
1040:
1044: --
1045: -- retrieve policy or group number if required
1046: if ben_extract.g_pgn_csr = 'Y' then
1047: open plcy_c(enrt.pl_id);
1048: fetch plcy_c into ben_ext_person.g_enrt_plcy_r_grp;
1049: close plcy_c;
1050: end if;
1051: --
1052: -- retrieve primary care provider info if required
1051: --
1052: -- retrieve primary care provider info if required
1053: if ben_extract.g_ppcp_csr = 'Y' then
1054: open c_prmry_care_prvdr(enrt.prtt_enrt_rslt_id);
1055: fetch c_prmry_care_prvdr into ben_ext_person.g_ppr_name
1056: ,ben_ext_person.g_ppr_ident
1057: ,ben_ext_person.g_ppr_typ
1058: ,ben_ext_person.g_ppr_strt_dt
1059: ,ben_ext_person.g_ppr_end_dt;
1052: -- retrieve primary care provider info if required
1053: if ben_extract.g_ppcp_csr = 'Y' then
1054: open c_prmry_care_prvdr(enrt.prtt_enrt_rslt_id);
1055: fetch c_prmry_care_prvdr into ben_ext_person.g_ppr_name
1056: ,ben_ext_person.g_ppr_ident
1057: ,ben_ext_person.g_ppr_typ
1058: ,ben_ext_person.g_ppr_strt_dt
1059: ,ben_ext_person.g_ppr_end_dt;
1060: close c_prmry_care_prvdr;
1053: if ben_extract.g_ppcp_csr = 'Y' then
1054: open c_prmry_care_prvdr(enrt.prtt_enrt_rslt_id);
1055: fetch c_prmry_care_prvdr into ben_ext_person.g_ppr_name
1056: ,ben_ext_person.g_ppr_ident
1057: ,ben_ext_person.g_ppr_typ
1058: ,ben_ext_person.g_ppr_strt_dt
1059: ,ben_ext_person.g_ppr_end_dt;
1060: close c_prmry_care_prvdr;
1061: end if;
1054: open c_prmry_care_prvdr(enrt.prtt_enrt_rslt_id);
1055: fetch c_prmry_care_prvdr into ben_ext_person.g_ppr_name
1056: ,ben_ext_person.g_ppr_ident
1057: ,ben_ext_person.g_ppr_typ
1058: ,ben_ext_person.g_ppr_strt_dt
1059: ,ben_ext_person.g_ppr_end_dt;
1060: close c_prmry_care_prvdr;
1061: end if;
1062: --
1055: fetch c_prmry_care_prvdr into ben_ext_person.g_ppr_name
1056: ,ben_ext_person.g_ppr_ident
1057: ,ben_ext_person.g_ppr_typ
1058: ,ben_ext_person.g_ppr_strt_dt
1059: ,ben_ext_person.g_ppr_end_dt;
1060: close c_prmry_care_prvdr;
1061: end if;
1062: --
1063: if ben_extract.g_rt_csr = 'Y' then
1071: --
1072: -- retrieve total premium info if required
1073: if ben_extract.g_pprem_csr = 'Y' then
1074: open prem_tot_c(enrt.prtt_enrt_rslt_id);
1075: fetch prem_tot_c into ben_ext_person.g_enrt_total_premium_amt
1076: ,ben_ext_person.g_enrt_total_premium_uom;
1077: close prem_tot_c;
1078: end if;
1079: --
1072: -- retrieve total premium info if required
1073: if ben_extract.g_pprem_csr = 'Y' then
1074: open prem_tot_c(enrt.prtt_enrt_rslt_id);
1075: fetch prem_tot_c into ben_ext_person.g_enrt_total_premium_amt
1076: ,ben_ext_person.g_enrt_total_premium_uom;
1077: close prem_tot_c;
1078: end if;
1079: --
1080: -- this is for person level so moving benxpers
1083: if ben_extract.g_flxcr_csr = 'Y' then
1084: hr_utility.set_location('entering to open flex credit ' ,160);
1085: hr_utility.set_location('entering to open flex credit '|| enrt.prtt_enrt_rslt_id ,160);
1086: open flex_cred_info_c(enrt.prtt_enrt_rslt_id);
1087: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided
1088: ,ben_ext_person.g_flex_credit_forfited
1089: ,ben_ext_person.g_flex_credit_used;
1090:
1091: ben_ext_person.g_flex_credit_excess :=
1084: hr_utility.set_location('entering to open flex credit ' ,160);
1085: hr_utility.set_location('entering to open flex credit '|| enrt.prtt_enrt_rslt_id ,160);
1086: open flex_cred_info_c(enrt.prtt_enrt_rslt_id);
1087: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided
1088: ,ben_ext_person.g_flex_credit_forfited
1089: ,ben_ext_person.g_flex_credit_used;
1090:
1091: ben_ext_person.g_flex_credit_excess :=
1092: nvl(ben_ext_person.g_flex_credit_provided,0) -
1085: hr_utility.set_location('entering to open flex credit '|| enrt.prtt_enrt_rslt_id ,160);
1086: open flex_cred_info_c(enrt.prtt_enrt_rslt_id);
1087: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided
1088: ,ben_ext_person.g_flex_credit_forfited
1089: ,ben_ext_person.g_flex_credit_used;
1090:
1091: ben_ext_person.g_flex_credit_excess :=
1092: nvl(ben_ext_person.g_flex_credit_provided,0) -
1093: nvl(ben_ext_person.g_flex_credit_forfited,0) -
1087: fetch flex_cred_info_c into ben_ext_person.g_flex_credit_provided
1088: ,ben_ext_person.g_flex_credit_forfited
1089: ,ben_ext_person.g_flex_credit_used;
1090:
1091: ben_ext_person.g_flex_credit_excess :=
1092: nvl(ben_ext_person.g_flex_credit_provided,0) -
1093: nvl(ben_ext_person.g_flex_credit_forfited,0) -
1094: nvl(ben_ext_person.g_flex_credit_used,0);
1095: close flex_cred_info_c;
1088: ,ben_ext_person.g_flex_credit_forfited
1089: ,ben_ext_person.g_flex_credit_used;
1090:
1091: ben_ext_person.g_flex_credit_excess :=
1092: nvl(ben_ext_person.g_flex_credit_provided,0) -
1093: nvl(ben_ext_person.g_flex_credit_forfited,0) -
1094: nvl(ben_ext_person.g_flex_credit_used,0);
1095: close flex_cred_info_c;
1096: end if;
1089: ,ben_ext_person.g_flex_credit_used;
1090:
1091: ben_ext_person.g_flex_credit_excess :=
1092: nvl(ben_ext_person.g_flex_credit_provided,0) -
1093: nvl(ben_ext_person.g_flex_credit_forfited,0) -
1094: nvl(ben_ext_person.g_flex_credit_used,0);
1095: close flex_cred_info_c;
1096: end if;
1097: */
1090:
1091: ben_ext_person.g_flex_credit_excess :=
1092: nvl(ben_ext_person.g_flex_credit_provided,0) -
1093: nvl(ben_ext_person.g_flex_credit_forfited,0) -
1094: nvl(ben_ext_person.g_flex_credit_used,0);
1095: close flex_cred_info_c;
1096: end if;
1097: */
1098: --
1100: -- Reporting group informations
1101: --
1102: if ben_extract.g_prgrp_csr = 'Y' then
1103: open c_rpt_grp(enrt.prtt_enrt_rslt_id);
1104: fetch c_rpt_grp into ben_ext_person.g_enrt_rpt_group_id,
1105: ben_ext_person.g_enrt_rpt_group_name;
1106: close c_rpt_grp;
1107: end if;
1108: --
1101: --
1102: if ben_extract.g_prgrp_csr = 'Y' then
1103: open c_rpt_grp(enrt.prtt_enrt_rslt_id);
1104: fetch c_rpt_grp into ben_ext_person.g_enrt_rpt_group_id,
1105: ben_ext_person.g_enrt_rpt_group_name;
1106: close c_rpt_grp;
1107: end if;
1108: --
1109: --
1110: -- Plan Year Informations
1111: -- --B.Burns #: 1641610
1112: if ben_extract.g_pplyr_csr = 'Y' then
1113: open c_pl_yr(enrt.prtt_enrt_rslt_id);
1114: fetch c_pl_yr into ben_ext_person.g_enrt_pl_yr_strdt,
1115: ben_ext_person.g_enrt_pl_yr_enddt;
1116: if c_pl_yr%notfound then
1117: open c_pgm_yr(enrt.prtt_enrt_rslt_id);
1118: fetch c_pgm_yr into ben_ext_person.g_enrt_pl_yr_strdt,
1111: -- --B.Burns #: 1641610
1112: if ben_extract.g_pplyr_csr = 'Y' then
1113: open c_pl_yr(enrt.prtt_enrt_rslt_id);
1114: fetch c_pl_yr into ben_ext_person.g_enrt_pl_yr_strdt,
1115: ben_ext_person.g_enrt_pl_yr_enddt;
1116: if c_pl_yr%notfound then
1117: open c_pgm_yr(enrt.prtt_enrt_rslt_id);
1118: fetch c_pgm_yr into ben_ext_person.g_enrt_pl_yr_strdt,
1119: ben_ext_person.g_enrt_pl_yr_enddt;
1114: fetch c_pl_yr into ben_ext_person.g_enrt_pl_yr_strdt,
1115: ben_ext_person.g_enrt_pl_yr_enddt;
1116: if c_pl_yr%notfound then
1117: open c_pgm_yr(enrt.prtt_enrt_rslt_id);
1118: fetch c_pgm_yr into ben_ext_person.g_enrt_pl_yr_strdt,
1119: ben_ext_person.g_enrt_pl_yr_enddt;
1120: close c_pgm_yr;
1121: end if;
1122: close c_pl_yr;
1115: ben_ext_person.g_enrt_pl_yr_enddt;
1116: if c_pl_yr%notfound then
1117: open c_pgm_yr(enrt.prtt_enrt_rslt_id);
1118: fetch c_pgm_yr into ben_ext_person.g_enrt_pl_yr_strdt,
1119: ben_ext_person.g_enrt_pl_yr_enddt;
1120: close c_pgm_yr;
1121: end if;
1122: close c_pl_yr;
1123: end if;
1145: if enrt.rplcs_sspndd_rslt_id is not null and enrt.sspndd_flag = 'Y' then
1146: open c_interim(enrt.rplcs_sspndd_rslt_id);
1147: fetch c_interim into l_interim;
1148: if c_interim%FOUND then
1149: ben_ext_person.g_enrt_int_pl_id := l_interim.pl_id;
1150: ben_ext_person.g_enrt_int_pl_name := l_interim.pl_name;
1151: ben_ext_person.g_enrt_int_opt_id := l_interim.opt_id;
1152: ben_ext_person.g_enrt_int_opt_name:= l_interim.opt_name;
1153: ben_ext_person.g_enrt_int_cvg_amt := l_interim.cvg_amt;
1146: open c_interim(enrt.rplcs_sspndd_rslt_id);
1147: fetch c_interim into l_interim;
1148: if c_interim%FOUND then
1149: ben_ext_person.g_enrt_int_pl_id := l_interim.pl_id;
1150: ben_ext_person.g_enrt_int_pl_name := l_interim.pl_name;
1151: ben_ext_person.g_enrt_int_opt_id := l_interim.opt_id;
1152: ben_ext_person.g_enrt_int_opt_name:= l_interim.opt_name;
1153: ben_ext_person.g_enrt_int_cvg_amt := l_interim.cvg_amt;
1154: close c_interim;
1147: fetch c_interim into l_interim;
1148: if c_interim%FOUND then
1149: ben_ext_person.g_enrt_int_pl_id := l_interim.pl_id;
1150: ben_ext_person.g_enrt_int_pl_name := l_interim.pl_name;
1151: ben_ext_person.g_enrt_int_opt_id := l_interim.opt_id;
1152: ben_ext_person.g_enrt_int_opt_name:= l_interim.opt_name;
1153: ben_ext_person.g_enrt_int_cvg_amt := l_interim.cvg_amt;
1154: close c_interim;
1155: else
1148: if c_interim%FOUND then
1149: ben_ext_person.g_enrt_int_pl_id := l_interim.pl_id;
1150: ben_ext_person.g_enrt_int_pl_name := l_interim.pl_name;
1151: ben_ext_person.g_enrt_int_opt_id := l_interim.opt_id;
1152: ben_ext_person.g_enrt_int_opt_name:= l_interim.opt_name;
1153: ben_ext_person.g_enrt_int_cvg_amt := l_interim.cvg_amt;
1154: close c_interim;
1155: else
1156: close c_interim;
1149: ben_ext_person.g_enrt_int_pl_id := l_interim.pl_id;
1150: ben_ext_person.g_enrt_int_pl_name := l_interim.pl_name;
1151: ben_ext_person.g_enrt_int_opt_id := l_interim.opt_id;
1152: ben_ext_person.g_enrt_int_opt_name:= l_interim.opt_name;
1153: ben_ext_person.g_enrt_int_cvg_amt := l_interim.cvg_amt;
1154: close c_interim;
1155: else
1156: close c_interim;
1157: end if;
1163: if ben_extract.g_intrm_csr = 'Y' then
1164: open c_intrm(enrt.prtt_enrt_rslt_id);
1165: fetch c_intrm into l_dummy;
1166: if c_intrm%FOUND then
1167: ben_ext_person.g_enrt_intrcovg_flag := 'Y';
1168: else
1169: ben_ext_person.g_enrt_intrcovg_flag := 'N';
1170: end if;
1171: close c_intrm;
1165: fetch c_intrm into l_dummy;
1166: if c_intrm%FOUND then
1167: ben_ext_person.g_enrt_intrcovg_flag := 'Y';
1168: else
1169: ben_ext_person.g_enrt_intrcovg_flag := 'N';
1170: end if;
1171: close c_intrm;
1172: end if;
1173: --