eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_ELIG_DPNT dependencies on BEN_EXT_PERSON

Line 31: ben_ext_person.g_elig_dpnt_elig_strt_dt := null;

27: --
28: hr_utility.set_location('Entering'||l_proc, 5);
29: --
30: --
31: ben_ext_person.g_elig_dpnt_elig_strt_dt := null;
32: ben_ext_person.g_elig_dpnt_elig_thru_dt := null;
33: ben_ext_person.g_elig_dpnt_create_dt := null;
34: ben_ext_person.g_elig_dpnt_ovrdn_flag := null;
35: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := null;

Line 32: ben_ext_person.g_elig_dpnt_elig_thru_dt := null;

28: hr_utility.set_location('Entering'||l_proc, 5);
29: --
30: --
31: ben_ext_person.g_elig_dpnt_elig_strt_dt := null;
32: ben_ext_person.g_elig_dpnt_elig_thru_dt := null;
33: ben_ext_person.g_elig_dpnt_create_dt := null;
34: ben_ext_person.g_elig_dpnt_ovrdn_flag := null;
35: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := null;
36: ben_ext_person.g_elig_dpnt_rlshp_type := null;

Line 33: ben_ext_person.g_elig_dpnt_create_dt := null;

29: --
30: --
31: ben_ext_person.g_elig_dpnt_elig_strt_dt := null;
32: ben_ext_person.g_elig_dpnt_elig_thru_dt := null;
33: ben_ext_person.g_elig_dpnt_create_dt := null;
34: ben_ext_person.g_elig_dpnt_ovrdn_flag := null;
35: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := null;
36: ben_ext_person.g_elig_dpnt_rlshp_type := null;
37: ben_ext_person.g_elig_dpnt_contact_seq_num := null;

Line 34: ben_ext_person.g_elig_dpnt_ovrdn_flag := null;

30: --
31: ben_ext_person.g_elig_dpnt_elig_strt_dt := null;
32: ben_ext_person.g_elig_dpnt_elig_thru_dt := null;
33: ben_ext_person.g_elig_dpnt_create_dt := null;
34: ben_ext_person.g_elig_dpnt_ovrdn_flag := null;
35: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := null;
36: ben_ext_person.g_elig_dpnt_rlshp_type := null;
37: ben_ext_person.g_elig_dpnt_contact_seq_num := null;
38: ben_ext_person.g_elig_dpnt_shared_resd_flag := null;

Line 35: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := null;

31: ben_ext_person.g_elig_dpnt_elig_strt_dt := null;
32: ben_ext_person.g_elig_dpnt_elig_thru_dt := null;
33: ben_ext_person.g_elig_dpnt_create_dt := null;
34: ben_ext_person.g_elig_dpnt_ovrdn_flag := null;
35: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := null;
36: ben_ext_person.g_elig_dpnt_rlshp_type := null;
37: ben_ext_person.g_elig_dpnt_contact_seq_num := null;
38: ben_ext_person.g_elig_dpnt_shared_resd_flag := null;
39: ben_ext_person.g_elig_dpnt_national_ident := null;

Line 36: ben_ext_person.g_elig_dpnt_rlshp_type := null;

32: ben_ext_person.g_elig_dpnt_elig_thru_dt := null;
33: ben_ext_person.g_elig_dpnt_create_dt := null;
34: ben_ext_person.g_elig_dpnt_ovrdn_flag := null;
35: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := null;
36: ben_ext_person.g_elig_dpnt_rlshp_type := null;
37: ben_ext_person.g_elig_dpnt_contact_seq_num := null;
38: ben_ext_person.g_elig_dpnt_shared_resd_flag := null;
39: ben_ext_person.g_elig_dpnt_national_ident := null;
40: ben_ext_person.g_elig_dpnt_last_name := null;

Line 37: ben_ext_person.g_elig_dpnt_contact_seq_num := null;

33: ben_ext_person.g_elig_dpnt_create_dt := null;
34: ben_ext_person.g_elig_dpnt_ovrdn_flag := null;
35: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := null;
36: ben_ext_person.g_elig_dpnt_rlshp_type := null;
37: ben_ext_person.g_elig_dpnt_contact_seq_num := null;
38: ben_ext_person.g_elig_dpnt_shared_resd_flag := null;
39: ben_ext_person.g_elig_dpnt_national_ident := null;
40: ben_ext_person.g_elig_dpnt_last_name := null;
41: ben_ext_person.g_elig_dpnt_first_name := null;

Line 38: ben_ext_person.g_elig_dpnt_shared_resd_flag := null;

34: ben_ext_person.g_elig_dpnt_ovrdn_flag := null;
35: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := null;
36: ben_ext_person.g_elig_dpnt_rlshp_type := null;
37: ben_ext_person.g_elig_dpnt_contact_seq_num := null;
38: ben_ext_person.g_elig_dpnt_shared_resd_flag := null;
39: ben_ext_person.g_elig_dpnt_national_ident := null;
40: ben_ext_person.g_elig_dpnt_last_name := null;
41: ben_ext_person.g_elig_dpnt_first_name := null;
42: ben_ext_person.g_elig_dpnt_middle_names := null;

Line 39: ben_ext_person.g_elig_dpnt_national_ident := null;

35: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := null;
36: ben_ext_person.g_elig_dpnt_rlshp_type := null;
37: ben_ext_person.g_elig_dpnt_contact_seq_num := null;
38: ben_ext_person.g_elig_dpnt_shared_resd_flag := null;
39: ben_ext_person.g_elig_dpnt_national_ident := null;
40: ben_ext_person.g_elig_dpnt_last_name := null;
41: ben_ext_person.g_elig_dpnt_first_name := null;
42: ben_ext_person.g_elig_dpnt_middle_names := null;
43: ben_ext_person.g_elig_dpnt_full_name := null;

Line 40: ben_ext_person.g_elig_dpnt_last_name := null;

36: ben_ext_person.g_elig_dpnt_rlshp_type := null;
37: ben_ext_person.g_elig_dpnt_contact_seq_num := null;
38: ben_ext_person.g_elig_dpnt_shared_resd_flag := null;
39: ben_ext_person.g_elig_dpnt_national_ident := null;
40: ben_ext_person.g_elig_dpnt_last_name := null;
41: ben_ext_person.g_elig_dpnt_first_name := null;
42: ben_ext_person.g_elig_dpnt_middle_names := null;
43: ben_ext_person.g_elig_dpnt_full_name := null;
44: ben_ext_person.g_elig_dpnt_suffix := null;

Line 41: ben_ext_person.g_elig_dpnt_first_name := null;

37: ben_ext_person.g_elig_dpnt_contact_seq_num := null;
38: ben_ext_person.g_elig_dpnt_shared_resd_flag := null;
39: ben_ext_person.g_elig_dpnt_national_ident := null;
40: ben_ext_person.g_elig_dpnt_last_name := null;
41: ben_ext_person.g_elig_dpnt_first_name := null;
42: ben_ext_person.g_elig_dpnt_middle_names := null;
43: ben_ext_person.g_elig_dpnt_full_name := null;
44: ben_ext_person.g_elig_dpnt_suffix := null;
45: ben_ext_person.g_elig_dpnt_title := null;

Line 42: ben_ext_person.g_elig_dpnt_middle_names := null;

38: ben_ext_person.g_elig_dpnt_shared_resd_flag := null;
39: ben_ext_person.g_elig_dpnt_national_ident := null;
40: ben_ext_person.g_elig_dpnt_last_name := null;
41: ben_ext_person.g_elig_dpnt_first_name := null;
42: ben_ext_person.g_elig_dpnt_middle_names := null;
43: ben_ext_person.g_elig_dpnt_full_name := null;
44: ben_ext_person.g_elig_dpnt_suffix := null;
45: ben_ext_person.g_elig_dpnt_title := null;
46: ben_ext_person.g_elig_dpnt_date_of_birth := null;

Line 43: ben_ext_person.g_elig_dpnt_full_name := null;

39: ben_ext_person.g_elig_dpnt_national_ident := null;
40: ben_ext_person.g_elig_dpnt_last_name := null;
41: ben_ext_person.g_elig_dpnt_first_name := null;
42: ben_ext_person.g_elig_dpnt_middle_names := null;
43: ben_ext_person.g_elig_dpnt_full_name := null;
44: ben_ext_person.g_elig_dpnt_suffix := null;
45: ben_ext_person.g_elig_dpnt_title := null;
46: ben_ext_person.g_elig_dpnt_date_of_birth := null;
47: ben_ext_person.g_elig_dpnt_marital_status := null;

Line 44: ben_ext_person.g_elig_dpnt_suffix := null;

40: ben_ext_person.g_elig_dpnt_last_name := null;
41: ben_ext_person.g_elig_dpnt_first_name := null;
42: ben_ext_person.g_elig_dpnt_middle_names := null;
43: ben_ext_person.g_elig_dpnt_full_name := null;
44: ben_ext_person.g_elig_dpnt_suffix := null;
45: ben_ext_person.g_elig_dpnt_title := null;
46: ben_ext_person.g_elig_dpnt_date_of_birth := null;
47: ben_ext_person.g_elig_dpnt_marital_status := null;
48: ben_ext_person.g_elig_dpnt_sex := null;

Line 45: ben_ext_person.g_elig_dpnt_title := null;

41: ben_ext_person.g_elig_dpnt_first_name := null;
42: ben_ext_person.g_elig_dpnt_middle_names := null;
43: ben_ext_person.g_elig_dpnt_full_name := null;
44: ben_ext_person.g_elig_dpnt_suffix := null;
45: ben_ext_person.g_elig_dpnt_title := null;
46: ben_ext_person.g_elig_dpnt_date_of_birth := null;
47: ben_ext_person.g_elig_dpnt_marital_status := null;
48: ben_ext_person.g_elig_dpnt_sex := null;
49: ben_ext_person.g_elig_dpnt_disabled_flag := null;

Line 46: ben_ext_person.g_elig_dpnt_date_of_birth := null;

42: ben_ext_person.g_elig_dpnt_middle_names := null;
43: ben_ext_person.g_elig_dpnt_full_name := null;
44: ben_ext_person.g_elig_dpnt_suffix := null;
45: ben_ext_person.g_elig_dpnt_title := null;
46: ben_ext_person.g_elig_dpnt_date_of_birth := null;
47: ben_ext_person.g_elig_dpnt_marital_status := null;
48: ben_ext_person.g_elig_dpnt_sex := null;
49: ben_ext_person.g_elig_dpnt_disabled_flag := null;
50: ben_ext_person.g_elig_dpnt_student_status := null;

Line 47: ben_ext_person.g_elig_dpnt_marital_status := null;

43: ben_ext_person.g_elig_dpnt_full_name := null;
44: ben_ext_person.g_elig_dpnt_suffix := null;
45: ben_ext_person.g_elig_dpnt_title := null;
46: ben_ext_person.g_elig_dpnt_date_of_birth := null;
47: ben_ext_person.g_elig_dpnt_marital_status := null;
48: ben_ext_person.g_elig_dpnt_sex := null;
49: ben_ext_person.g_elig_dpnt_disabled_flag := null;
50: ben_ext_person.g_elig_dpnt_student_status := null;
51: ben_ext_person.g_elig_dpnt_date_of_death := null;

Line 48: ben_ext_person.g_elig_dpnt_sex := null;

44: ben_ext_person.g_elig_dpnt_suffix := null;
45: ben_ext_person.g_elig_dpnt_title := null;
46: ben_ext_person.g_elig_dpnt_date_of_birth := null;
47: ben_ext_person.g_elig_dpnt_marital_status := null;
48: ben_ext_person.g_elig_dpnt_sex := null;
49: ben_ext_person.g_elig_dpnt_disabled_flag := null;
50: ben_ext_person.g_elig_dpnt_student_status := null;
51: ben_ext_person.g_elig_dpnt_date_of_death := null;
52: ben_ext_person.g_elig_dpnt_language := null;

Line 49: ben_ext_person.g_elig_dpnt_disabled_flag := null;

45: ben_ext_person.g_elig_dpnt_title := null;
46: ben_ext_person.g_elig_dpnt_date_of_birth := null;
47: ben_ext_person.g_elig_dpnt_marital_status := null;
48: ben_ext_person.g_elig_dpnt_sex := null;
49: ben_ext_person.g_elig_dpnt_disabled_flag := null;
50: ben_ext_person.g_elig_dpnt_student_status := null;
51: ben_ext_person.g_elig_dpnt_date_of_death := null;
52: ben_ext_person.g_elig_dpnt_language := null;
53: ben_ext_person.g_elig_dpnt_nationality := null;

Line 50: ben_ext_person.g_elig_dpnt_student_status := null;

46: ben_ext_person.g_elig_dpnt_date_of_birth := null;
47: ben_ext_person.g_elig_dpnt_marital_status := null;
48: ben_ext_person.g_elig_dpnt_sex := null;
49: ben_ext_person.g_elig_dpnt_disabled_flag := null;
50: ben_ext_person.g_elig_dpnt_student_status := null;
51: ben_ext_person.g_elig_dpnt_date_of_death := null;
52: ben_ext_person.g_elig_dpnt_language := null;
53: ben_ext_person.g_elig_dpnt_nationality := null;
54: ben_ext_person.g_elig_dpnt_email_address := null;

Line 51: ben_ext_person.g_elig_dpnt_date_of_death := null;

47: ben_ext_person.g_elig_dpnt_marital_status := null;
48: ben_ext_person.g_elig_dpnt_sex := null;
49: ben_ext_person.g_elig_dpnt_disabled_flag := null;
50: ben_ext_person.g_elig_dpnt_student_status := null;
51: ben_ext_person.g_elig_dpnt_date_of_death := null;
52: ben_ext_person.g_elig_dpnt_language := null;
53: ben_ext_person.g_elig_dpnt_nationality := null;
54: ben_ext_person.g_elig_dpnt_email_address := null;
55: ben_ext_person.g_elig_dpnt_known_as := null;

Line 52: ben_ext_person.g_elig_dpnt_language := null;

48: ben_ext_person.g_elig_dpnt_sex := null;
49: ben_ext_person.g_elig_dpnt_disabled_flag := null;
50: ben_ext_person.g_elig_dpnt_student_status := null;
51: ben_ext_person.g_elig_dpnt_date_of_death := null;
52: ben_ext_person.g_elig_dpnt_language := null;
53: ben_ext_person.g_elig_dpnt_nationality := null;
54: ben_ext_person.g_elig_dpnt_email_address := null;
55: ben_ext_person.g_elig_dpnt_known_as := null;
56: ben_ext_person.g_elig_dpnt_pre_name_adjunct := null;

Line 53: ben_ext_person.g_elig_dpnt_nationality := null;

49: ben_ext_person.g_elig_dpnt_disabled_flag := null;
50: ben_ext_person.g_elig_dpnt_student_status := null;
51: ben_ext_person.g_elig_dpnt_date_of_death := null;
52: ben_ext_person.g_elig_dpnt_language := null;
53: ben_ext_person.g_elig_dpnt_nationality := null;
54: ben_ext_person.g_elig_dpnt_email_address := null;
55: ben_ext_person.g_elig_dpnt_known_as := null;
56: ben_ext_person.g_elig_dpnt_pre_name_adjunct := null;
57: ben_ext_person.g_elig_dpnt_tobacco_usage := null;

Line 54: ben_ext_person.g_elig_dpnt_email_address := null;

50: ben_ext_person.g_elig_dpnt_student_status := null;
51: ben_ext_person.g_elig_dpnt_date_of_death := null;
52: ben_ext_person.g_elig_dpnt_language := null;
53: ben_ext_person.g_elig_dpnt_nationality := null;
54: ben_ext_person.g_elig_dpnt_email_address := null;
55: ben_ext_person.g_elig_dpnt_known_as := null;
56: ben_ext_person.g_elig_dpnt_pre_name_adjunct := null;
57: ben_ext_person.g_elig_dpnt_tobacco_usage := null;
58: ben_ext_person.g_elig_dpnt_prev_last_name := null;

Line 55: ben_ext_person.g_elig_dpnt_known_as := null;

51: ben_ext_person.g_elig_dpnt_date_of_death := null;
52: ben_ext_person.g_elig_dpnt_language := null;
53: ben_ext_person.g_elig_dpnt_nationality := null;
54: ben_ext_person.g_elig_dpnt_email_address := null;
55: ben_ext_person.g_elig_dpnt_known_as := null;
56: ben_ext_person.g_elig_dpnt_pre_name_adjunct := null;
57: ben_ext_person.g_elig_dpnt_tobacco_usage := null;
58: ben_ext_person.g_elig_dpnt_prev_last_name := null;
59: ben_ext_person.g_elig_dpnt_prim_address1 := null;

Line 56: ben_ext_person.g_elig_dpnt_pre_name_adjunct := null;

52: ben_ext_person.g_elig_dpnt_language := null;
53: ben_ext_person.g_elig_dpnt_nationality := null;
54: ben_ext_person.g_elig_dpnt_email_address := null;
55: ben_ext_person.g_elig_dpnt_known_as := null;
56: ben_ext_person.g_elig_dpnt_pre_name_adjunct := null;
57: ben_ext_person.g_elig_dpnt_tobacco_usage := null;
58: ben_ext_person.g_elig_dpnt_prev_last_name := null;
59: ben_ext_person.g_elig_dpnt_prim_address1 := null;
60: ben_ext_person.g_elig_dpnt_prim_address2 := null;

Line 57: ben_ext_person.g_elig_dpnt_tobacco_usage := null;

53: ben_ext_person.g_elig_dpnt_nationality := null;
54: ben_ext_person.g_elig_dpnt_email_address := null;
55: ben_ext_person.g_elig_dpnt_known_as := null;
56: ben_ext_person.g_elig_dpnt_pre_name_adjunct := null;
57: ben_ext_person.g_elig_dpnt_tobacco_usage := null;
58: ben_ext_person.g_elig_dpnt_prev_last_name := null;
59: ben_ext_person.g_elig_dpnt_prim_address1 := null;
60: ben_ext_person.g_elig_dpnt_prim_address2 := null;
61: ben_ext_person.g_elig_dpnt_prim_address3 := null;

Line 58: ben_ext_person.g_elig_dpnt_prev_last_name := null;

54: ben_ext_person.g_elig_dpnt_email_address := null;
55: ben_ext_person.g_elig_dpnt_known_as := null;
56: ben_ext_person.g_elig_dpnt_pre_name_adjunct := null;
57: ben_ext_person.g_elig_dpnt_tobacco_usage := null;
58: ben_ext_person.g_elig_dpnt_prev_last_name := null;
59: ben_ext_person.g_elig_dpnt_prim_address1 := null;
60: ben_ext_person.g_elig_dpnt_prim_address2 := null;
61: ben_ext_person.g_elig_dpnt_prim_address3 := null;
62: ben_ext_person.g_elig_dpnt_prim_city := null;

Line 59: ben_ext_person.g_elig_dpnt_prim_address1 := null;

55: ben_ext_person.g_elig_dpnt_known_as := null;
56: ben_ext_person.g_elig_dpnt_pre_name_adjunct := null;
57: ben_ext_person.g_elig_dpnt_tobacco_usage := null;
58: ben_ext_person.g_elig_dpnt_prev_last_name := null;
59: ben_ext_person.g_elig_dpnt_prim_address1 := null;
60: ben_ext_person.g_elig_dpnt_prim_address2 := null;
61: ben_ext_person.g_elig_dpnt_prim_address3 := null;
62: ben_ext_person.g_elig_dpnt_prim_city := null;
63: ben_ext_person.g_elig_dpnt_prim_state := null;

Line 60: ben_ext_person.g_elig_dpnt_prim_address2 := null;

56: ben_ext_person.g_elig_dpnt_pre_name_adjunct := null;
57: ben_ext_person.g_elig_dpnt_tobacco_usage := null;
58: ben_ext_person.g_elig_dpnt_prev_last_name := null;
59: ben_ext_person.g_elig_dpnt_prim_address1 := null;
60: ben_ext_person.g_elig_dpnt_prim_address2 := null;
61: ben_ext_person.g_elig_dpnt_prim_address3 := null;
62: ben_ext_person.g_elig_dpnt_prim_city := null;
63: ben_ext_person.g_elig_dpnt_prim_state := null;
64: ben_ext_person.g_elig_dpnt_prim_postal_code := null;

Line 61: ben_ext_person.g_elig_dpnt_prim_address3 := null;

57: ben_ext_person.g_elig_dpnt_tobacco_usage := null;
58: ben_ext_person.g_elig_dpnt_prev_last_name := null;
59: ben_ext_person.g_elig_dpnt_prim_address1 := null;
60: ben_ext_person.g_elig_dpnt_prim_address2 := null;
61: ben_ext_person.g_elig_dpnt_prim_address3 := null;
62: ben_ext_person.g_elig_dpnt_prim_city := null;
63: ben_ext_person.g_elig_dpnt_prim_state := null;
64: ben_ext_person.g_elig_dpnt_prim_postal_code := null;
65: ben_ext_person.g_elig_dpnt_prim_country := null;

Line 62: ben_ext_person.g_elig_dpnt_prim_city := null;

58: ben_ext_person.g_elig_dpnt_prev_last_name := null;
59: ben_ext_person.g_elig_dpnt_prim_address1 := null;
60: ben_ext_person.g_elig_dpnt_prim_address2 := null;
61: ben_ext_person.g_elig_dpnt_prim_address3 := null;
62: ben_ext_person.g_elig_dpnt_prim_city := null;
63: ben_ext_person.g_elig_dpnt_prim_state := null;
64: ben_ext_person.g_elig_dpnt_prim_postal_code := null;
65: ben_ext_person.g_elig_dpnt_prim_country := null;
66: ben_ext_person.g_elig_dpnt_prim_effect_date := null;

Line 63: ben_ext_person.g_elig_dpnt_prim_state := null;

59: ben_ext_person.g_elig_dpnt_prim_address1 := null;
60: ben_ext_person.g_elig_dpnt_prim_address2 := null;
61: ben_ext_person.g_elig_dpnt_prim_address3 := null;
62: ben_ext_person.g_elig_dpnt_prim_city := null;
63: ben_ext_person.g_elig_dpnt_prim_state := null;
64: ben_ext_person.g_elig_dpnt_prim_postal_code := null;
65: ben_ext_person.g_elig_dpnt_prim_country := null;
66: ben_ext_person.g_elig_dpnt_prim_effect_date := null;
67: ben_ext_person.g_elig_dpnt_prim_region := null;

Line 64: ben_ext_person.g_elig_dpnt_prim_postal_code := null;

60: ben_ext_person.g_elig_dpnt_prim_address2 := null;
61: ben_ext_person.g_elig_dpnt_prim_address3 := null;
62: ben_ext_person.g_elig_dpnt_prim_city := null;
63: ben_ext_person.g_elig_dpnt_prim_state := null;
64: ben_ext_person.g_elig_dpnt_prim_postal_code := null;
65: ben_ext_person.g_elig_dpnt_prim_country := null;
66: ben_ext_person.g_elig_dpnt_prim_effect_date := null;
67: ben_ext_person.g_elig_dpnt_prim_region := null;
68: ben_ext_person.g_elig_dpnt_home_phone := null;

Line 65: ben_ext_person.g_elig_dpnt_prim_country := null;

61: ben_ext_person.g_elig_dpnt_prim_address3 := null;
62: ben_ext_person.g_elig_dpnt_prim_city := null;
63: ben_ext_person.g_elig_dpnt_prim_state := null;
64: ben_ext_person.g_elig_dpnt_prim_postal_code := null;
65: ben_ext_person.g_elig_dpnt_prim_country := null;
66: ben_ext_person.g_elig_dpnt_prim_effect_date := null;
67: ben_ext_person.g_elig_dpnt_prim_region := null;
68: ben_ext_person.g_elig_dpnt_home_phone := null;
69: ben_ext_person.g_elig_dpnt_work_phone := null;

Line 66: ben_ext_person.g_elig_dpnt_prim_effect_date := null;

62: ben_ext_person.g_elig_dpnt_prim_city := null;
63: ben_ext_person.g_elig_dpnt_prim_state := null;
64: ben_ext_person.g_elig_dpnt_prim_postal_code := null;
65: ben_ext_person.g_elig_dpnt_prim_country := null;
66: ben_ext_person.g_elig_dpnt_prim_effect_date := null;
67: ben_ext_person.g_elig_dpnt_prim_region := null;
68: ben_ext_person.g_elig_dpnt_home_phone := null;
69: ben_ext_person.g_elig_dpnt_work_phone := null;
70: ben_ext_person.g_elig_dpnt_fax := null;

Line 67: ben_ext_person.g_elig_dpnt_prim_region := null;

63: ben_ext_person.g_elig_dpnt_prim_state := null;
64: ben_ext_person.g_elig_dpnt_prim_postal_code := null;
65: ben_ext_person.g_elig_dpnt_prim_country := null;
66: ben_ext_person.g_elig_dpnt_prim_effect_date := null;
67: ben_ext_person.g_elig_dpnt_prim_region := null;
68: ben_ext_person.g_elig_dpnt_home_phone := null;
69: ben_ext_person.g_elig_dpnt_work_phone := null;
70: ben_ext_person.g_elig_dpnt_fax := null;
71: ben_ext_person.g_elig_dpnt_mobile := null;

Line 68: ben_ext_person.g_elig_dpnt_home_phone := null;

64: ben_ext_person.g_elig_dpnt_prim_postal_code := null;
65: ben_ext_person.g_elig_dpnt_prim_country := null;
66: ben_ext_person.g_elig_dpnt_prim_effect_date := null;
67: ben_ext_person.g_elig_dpnt_prim_region := null;
68: ben_ext_person.g_elig_dpnt_home_phone := null;
69: ben_ext_person.g_elig_dpnt_work_phone := null;
70: ben_ext_person.g_elig_dpnt_fax := null;
71: ben_ext_person.g_elig_dpnt_mobile := null;
72: ben_ext_person.g_elig_dpnt_id := null;

Line 69: ben_ext_person.g_elig_dpnt_work_phone := null;

65: ben_ext_person.g_elig_dpnt_prim_country := null;
66: ben_ext_person.g_elig_dpnt_prim_effect_date := null;
67: ben_ext_person.g_elig_dpnt_prim_region := null;
68: ben_ext_person.g_elig_dpnt_home_phone := null;
69: ben_ext_person.g_elig_dpnt_work_phone := null;
70: ben_ext_person.g_elig_dpnt_fax := null;
71: ben_ext_person.g_elig_dpnt_mobile := null;
72: ben_ext_person.g_elig_dpnt_id := null;
73: --

Line 70: ben_ext_person.g_elig_dpnt_fax := null;

66: ben_ext_person.g_elig_dpnt_prim_effect_date := null;
67: ben_ext_person.g_elig_dpnt_prim_region := null;
68: ben_ext_person.g_elig_dpnt_home_phone := null;
69: ben_ext_person.g_elig_dpnt_work_phone := null;
70: ben_ext_person.g_elig_dpnt_fax := null;
71: ben_ext_person.g_elig_dpnt_mobile := null;
72: ben_ext_person.g_elig_dpnt_id := null;
73: --
74: --

Line 71: ben_ext_person.g_elig_dpnt_mobile := null;

67: ben_ext_person.g_elig_dpnt_prim_region := null;
68: ben_ext_person.g_elig_dpnt_home_phone := null;
69: ben_ext_person.g_elig_dpnt_work_phone := null;
70: ben_ext_person.g_elig_dpnt_fax := null;
71: ben_ext_person.g_elig_dpnt_mobile := null;
72: ben_ext_person.g_elig_dpnt_id := null;
73: --
74: --
75: hr_utility.set_location('Exiting'||l_proc, 15);

Line 72: ben_ext_person.g_elig_dpnt_id := null;

68: ben_ext_person.g_elig_dpnt_home_phone := null;
69: ben_ext_person.g_elig_dpnt_work_phone := null;
70: ben_ext_person.g_elig_dpnt_fax := null;
71: ben_ext_person.g_elig_dpnt_mobile := null;
72: ben_ext_person.g_elig_dpnt_id := null;
73: --
74: --
75: hr_utility.set_location('Exiting'||l_proc, 15);
76: --

Line 304: ben_ext_person.g_elig_dpnt_id := l_dpel_elig_dpnt_id_va(i) ;

300: initialize_globals;
301: --
302: -- fetch dependent information into globals
303: --
304: ben_ext_person.g_elig_dpnt_id := l_dpel_elig_dpnt_id_va(i) ;
305: ben_ext_person.g_elig_dpnt_create_dt := l_dpel_create_dt_va(i) ;
306: ben_ext_person.g_elig_dpnt_elig_strt_dt := l_dpel_elig_strt_dt_va(i) ;
307: ben_ext_person.g_elig_dpnt_elig_thru_dt := l_dpel_elig_thru_dt_va(i) ;
308: ben_ext_person.g_elig_dpnt_ovrdn_flag := l_dpel_ovrdn_flag_va(i) ;

Line 305: ben_ext_person.g_elig_dpnt_create_dt := l_dpel_create_dt_va(i) ;

301: --
302: -- fetch dependent information into globals
303: --
304: ben_ext_person.g_elig_dpnt_id := l_dpel_elig_dpnt_id_va(i) ;
305: ben_ext_person.g_elig_dpnt_create_dt := l_dpel_create_dt_va(i) ;
306: ben_ext_person.g_elig_dpnt_elig_strt_dt := l_dpel_elig_strt_dt_va(i) ;
307: ben_ext_person.g_elig_dpnt_elig_thru_dt := l_dpel_elig_thru_dt_va(i) ;
308: ben_ext_person.g_elig_dpnt_ovrdn_flag := l_dpel_ovrdn_flag_va(i) ;
309: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := l_dpel_ovrdn_thru_dt_va(i) ;

Line 306: ben_ext_person.g_elig_dpnt_elig_strt_dt := l_dpel_elig_strt_dt_va(i) ;

302: -- fetch dependent information into globals
303: --
304: ben_ext_person.g_elig_dpnt_id := l_dpel_elig_dpnt_id_va(i) ;
305: ben_ext_person.g_elig_dpnt_create_dt := l_dpel_create_dt_va(i) ;
306: ben_ext_person.g_elig_dpnt_elig_strt_dt := l_dpel_elig_strt_dt_va(i) ;
307: ben_ext_person.g_elig_dpnt_elig_thru_dt := l_dpel_elig_thru_dt_va(i) ;
308: ben_ext_person.g_elig_dpnt_ovrdn_flag := l_dpel_ovrdn_flag_va(i) ;
309: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := l_dpel_ovrdn_thru_dt_va(i) ;
310: ben_ext_person.g_elig_dpnt_rlshp_type := l_dpel_contact_type_va(i) ;

Line 307: ben_ext_person.g_elig_dpnt_elig_thru_dt := l_dpel_elig_thru_dt_va(i) ;

303: --
304: ben_ext_person.g_elig_dpnt_id := l_dpel_elig_dpnt_id_va(i) ;
305: ben_ext_person.g_elig_dpnt_create_dt := l_dpel_create_dt_va(i) ;
306: ben_ext_person.g_elig_dpnt_elig_strt_dt := l_dpel_elig_strt_dt_va(i) ;
307: ben_ext_person.g_elig_dpnt_elig_thru_dt := l_dpel_elig_thru_dt_va(i) ;
308: ben_ext_person.g_elig_dpnt_ovrdn_flag := l_dpel_ovrdn_flag_va(i) ;
309: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := l_dpel_ovrdn_thru_dt_va(i) ;
310: ben_ext_person.g_elig_dpnt_rlshp_type := l_dpel_contact_type_va(i) ;
311: ben_ext_person.g_elig_dpnt_contact_seq_num := l_dpel_sequence_number_va(i) ;

Line 308: ben_ext_person.g_elig_dpnt_ovrdn_flag := l_dpel_ovrdn_flag_va(i) ;

304: ben_ext_person.g_elig_dpnt_id := l_dpel_elig_dpnt_id_va(i) ;
305: ben_ext_person.g_elig_dpnt_create_dt := l_dpel_create_dt_va(i) ;
306: ben_ext_person.g_elig_dpnt_elig_strt_dt := l_dpel_elig_strt_dt_va(i) ;
307: ben_ext_person.g_elig_dpnt_elig_thru_dt := l_dpel_elig_thru_dt_va(i) ;
308: ben_ext_person.g_elig_dpnt_ovrdn_flag := l_dpel_ovrdn_flag_va(i) ;
309: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := l_dpel_ovrdn_thru_dt_va(i) ;
310: ben_ext_person.g_elig_dpnt_rlshp_type := l_dpel_contact_type_va(i) ;
311: ben_ext_person.g_elig_dpnt_contact_seq_num := l_dpel_sequence_number_va(i) ;
312: ben_ext_person.g_elig_dpnt_shared_resd_flag := l_dpel_rltd_per_dsgntr_flag_va(i) ;

Line 309: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := l_dpel_ovrdn_thru_dt_va(i) ;

305: ben_ext_person.g_elig_dpnt_create_dt := l_dpel_create_dt_va(i) ;
306: ben_ext_person.g_elig_dpnt_elig_strt_dt := l_dpel_elig_strt_dt_va(i) ;
307: ben_ext_person.g_elig_dpnt_elig_thru_dt := l_dpel_elig_thru_dt_va(i) ;
308: ben_ext_person.g_elig_dpnt_ovrdn_flag := l_dpel_ovrdn_flag_va(i) ;
309: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := l_dpel_ovrdn_thru_dt_va(i) ;
310: ben_ext_person.g_elig_dpnt_rlshp_type := l_dpel_contact_type_va(i) ;
311: ben_ext_person.g_elig_dpnt_contact_seq_num := l_dpel_sequence_number_va(i) ;
312: ben_ext_person.g_elig_dpnt_shared_resd_flag := l_dpel_rltd_per_dsgntr_flag_va(i) ;
313: ben_ext_person.g_elig_dpnt_national_ident := l_dpel_national_identifier_va(i) ;

Line 310: ben_ext_person.g_elig_dpnt_rlshp_type := l_dpel_contact_type_va(i) ;

306: ben_ext_person.g_elig_dpnt_elig_strt_dt := l_dpel_elig_strt_dt_va(i) ;
307: ben_ext_person.g_elig_dpnt_elig_thru_dt := l_dpel_elig_thru_dt_va(i) ;
308: ben_ext_person.g_elig_dpnt_ovrdn_flag := l_dpel_ovrdn_flag_va(i) ;
309: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := l_dpel_ovrdn_thru_dt_va(i) ;
310: ben_ext_person.g_elig_dpnt_rlshp_type := l_dpel_contact_type_va(i) ;
311: ben_ext_person.g_elig_dpnt_contact_seq_num := l_dpel_sequence_number_va(i) ;
312: ben_ext_person.g_elig_dpnt_shared_resd_flag := l_dpel_rltd_per_dsgntr_flag_va(i) ;
313: ben_ext_person.g_elig_dpnt_national_ident := l_dpel_national_identifier_va(i) ;
314: ben_ext_person.g_elig_dpnt_last_name := l_dpel_last_name_va(i) ;

Line 311: ben_ext_person.g_elig_dpnt_contact_seq_num := l_dpel_sequence_number_va(i) ;

307: ben_ext_person.g_elig_dpnt_elig_thru_dt := l_dpel_elig_thru_dt_va(i) ;
308: ben_ext_person.g_elig_dpnt_ovrdn_flag := l_dpel_ovrdn_flag_va(i) ;
309: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := l_dpel_ovrdn_thru_dt_va(i) ;
310: ben_ext_person.g_elig_dpnt_rlshp_type := l_dpel_contact_type_va(i) ;
311: ben_ext_person.g_elig_dpnt_contact_seq_num := l_dpel_sequence_number_va(i) ;
312: ben_ext_person.g_elig_dpnt_shared_resd_flag := l_dpel_rltd_per_dsgntr_flag_va(i) ;
313: ben_ext_person.g_elig_dpnt_national_ident := l_dpel_national_identifier_va(i) ;
314: ben_ext_person.g_elig_dpnt_last_name := l_dpel_last_name_va(i) ;
315: ben_ext_person.g_elig_dpnt_first_name := l_dpel_first_name_va(i) ;

Line 312: ben_ext_person.g_elig_dpnt_shared_resd_flag := l_dpel_rltd_per_dsgntr_flag_va(i) ;

308: ben_ext_person.g_elig_dpnt_ovrdn_flag := l_dpel_ovrdn_flag_va(i) ;
309: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := l_dpel_ovrdn_thru_dt_va(i) ;
310: ben_ext_person.g_elig_dpnt_rlshp_type := l_dpel_contact_type_va(i) ;
311: ben_ext_person.g_elig_dpnt_contact_seq_num := l_dpel_sequence_number_va(i) ;
312: ben_ext_person.g_elig_dpnt_shared_resd_flag := l_dpel_rltd_per_dsgntr_flag_va(i) ;
313: ben_ext_person.g_elig_dpnt_national_ident := l_dpel_national_identifier_va(i) ;
314: ben_ext_person.g_elig_dpnt_last_name := l_dpel_last_name_va(i) ;
315: ben_ext_person.g_elig_dpnt_first_name := l_dpel_first_name_va(i) ;
316: ben_ext_person.g_elig_dpnt_middle_names := l_dpel_middle_names_va(i) ;

Line 313: ben_ext_person.g_elig_dpnt_national_ident := l_dpel_national_identifier_va(i) ;

309: ben_ext_person.g_elig_dpnt_ovrdn_thru_dt := l_dpel_ovrdn_thru_dt_va(i) ;
310: ben_ext_person.g_elig_dpnt_rlshp_type := l_dpel_contact_type_va(i) ;
311: ben_ext_person.g_elig_dpnt_contact_seq_num := l_dpel_sequence_number_va(i) ;
312: ben_ext_person.g_elig_dpnt_shared_resd_flag := l_dpel_rltd_per_dsgntr_flag_va(i) ;
313: ben_ext_person.g_elig_dpnt_national_ident := l_dpel_national_identifier_va(i) ;
314: ben_ext_person.g_elig_dpnt_last_name := l_dpel_last_name_va(i) ;
315: ben_ext_person.g_elig_dpnt_first_name := l_dpel_first_name_va(i) ;
316: ben_ext_person.g_elig_dpnt_middle_names := l_dpel_middle_names_va(i) ;
317: ben_ext_person.g_elig_dpnt_full_name := l_dpel_full_name_va(i) ;

Line 314: ben_ext_person.g_elig_dpnt_last_name := l_dpel_last_name_va(i) ;

310: ben_ext_person.g_elig_dpnt_rlshp_type := l_dpel_contact_type_va(i) ;
311: ben_ext_person.g_elig_dpnt_contact_seq_num := l_dpel_sequence_number_va(i) ;
312: ben_ext_person.g_elig_dpnt_shared_resd_flag := l_dpel_rltd_per_dsgntr_flag_va(i) ;
313: ben_ext_person.g_elig_dpnt_national_ident := l_dpel_national_identifier_va(i) ;
314: ben_ext_person.g_elig_dpnt_last_name := l_dpel_last_name_va(i) ;
315: ben_ext_person.g_elig_dpnt_first_name := l_dpel_first_name_va(i) ;
316: ben_ext_person.g_elig_dpnt_middle_names := l_dpel_middle_names_va(i) ;
317: ben_ext_person.g_elig_dpnt_full_name := l_dpel_full_name_va(i) ;
318: ben_ext_person.g_elig_dpnt_suffix := l_dpel_suffix_va(i) ;

Line 315: ben_ext_person.g_elig_dpnt_first_name := l_dpel_first_name_va(i) ;

311: ben_ext_person.g_elig_dpnt_contact_seq_num := l_dpel_sequence_number_va(i) ;
312: ben_ext_person.g_elig_dpnt_shared_resd_flag := l_dpel_rltd_per_dsgntr_flag_va(i) ;
313: ben_ext_person.g_elig_dpnt_national_ident := l_dpel_national_identifier_va(i) ;
314: ben_ext_person.g_elig_dpnt_last_name := l_dpel_last_name_va(i) ;
315: ben_ext_person.g_elig_dpnt_first_name := l_dpel_first_name_va(i) ;
316: ben_ext_person.g_elig_dpnt_middle_names := l_dpel_middle_names_va(i) ;
317: ben_ext_person.g_elig_dpnt_full_name := l_dpel_full_name_va(i) ;
318: ben_ext_person.g_elig_dpnt_suffix := l_dpel_suffix_va(i) ;
319: ben_ext_person.g_elig_dpnt_title := l_dpel_title_va(i) ;

Line 316: ben_ext_person.g_elig_dpnt_middle_names := l_dpel_middle_names_va(i) ;

312: ben_ext_person.g_elig_dpnt_shared_resd_flag := l_dpel_rltd_per_dsgntr_flag_va(i) ;
313: ben_ext_person.g_elig_dpnt_national_ident := l_dpel_national_identifier_va(i) ;
314: ben_ext_person.g_elig_dpnt_last_name := l_dpel_last_name_va(i) ;
315: ben_ext_person.g_elig_dpnt_first_name := l_dpel_first_name_va(i) ;
316: ben_ext_person.g_elig_dpnt_middle_names := l_dpel_middle_names_va(i) ;
317: ben_ext_person.g_elig_dpnt_full_name := l_dpel_full_name_va(i) ;
318: ben_ext_person.g_elig_dpnt_suffix := l_dpel_suffix_va(i) ;
319: ben_ext_person.g_elig_dpnt_title := l_dpel_title_va(i) ;
320: ben_ext_person.g_elig_dpnt_date_of_birth := l_dpel_date_of_birth_va(i) ;

Line 317: ben_ext_person.g_elig_dpnt_full_name := l_dpel_full_name_va(i) ;

313: ben_ext_person.g_elig_dpnt_national_ident := l_dpel_national_identifier_va(i) ;
314: ben_ext_person.g_elig_dpnt_last_name := l_dpel_last_name_va(i) ;
315: ben_ext_person.g_elig_dpnt_first_name := l_dpel_first_name_va(i) ;
316: ben_ext_person.g_elig_dpnt_middle_names := l_dpel_middle_names_va(i) ;
317: ben_ext_person.g_elig_dpnt_full_name := l_dpel_full_name_va(i) ;
318: ben_ext_person.g_elig_dpnt_suffix := l_dpel_suffix_va(i) ;
319: ben_ext_person.g_elig_dpnt_title := l_dpel_title_va(i) ;
320: ben_ext_person.g_elig_dpnt_date_of_birth := l_dpel_date_of_birth_va(i) ;
321: ben_ext_person.g_elig_dpnt_marital_status := l_dpel_marital_status_va(i) ;

Line 318: ben_ext_person.g_elig_dpnt_suffix := l_dpel_suffix_va(i) ;

314: ben_ext_person.g_elig_dpnt_last_name := l_dpel_last_name_va(i) ;
315: ben_ext_person.g_elig_dpnt_first_name := l_dpel_first_name_va(i) ;
316: ben_ext_person.g_elig_dpnt_middle_names := l_dpel_middle_names_va(i) ;
317: ben_ext_person.g_elig_dpnt_full_name := l_dpel_full_name_va(i) ;
318: ben_ext_person.g_elig_dpnt_suffix := l_dpel_suffix_va(i) ;
319: ben_ext_person.g_elig_dpnt_title := l_dpel_title_va(i) ;
320: ben_ext_person.g_elig_dpnt_date_of_birth := l_dpel_date_of_birth_va(i) ;
321: ben_ext_person.g_elig_dpnt_marital_status := l_dpel_marital_status_va(i) ;
322: ben_ext_person.g_elig_dpnt_sex := l_dpel_sex_va(i) ;

Line 319: ben_ext_person.g_elig_dpnt_title := l_dpel_title_va(i) ;

315: ben_ext_person.g_elig_dpnt_first_name := l_dpel_first_name_va(i) ;
316: ben_ext_person.g_elig_dpnt_middle_names := l_dpel_middle_names_va(i) ;
317: ben_ext_person.g_elig_dpnt_full_name := l_dpel_full_name_va(i) ;
318: ben_ext_person.g_elig_dpnt_suffix := l_dpel_suffix_va(i) ;
319: ben_ext_person.g_elig_dpnt_title := l_dpel_title_va(i) ;
320: ben_ext_person.g_elig_dpnt_date_of_birth := l_dpel_date_of_birth_va(i) ;
321: ben_ext_person.g_elig_dpnt_marital_status := l_dpel_marital_status_va(i) ;
322: ben_ext_person.g_elig_dpnt_sex := l_dpel_sex_va(i) ;
323: ben_ext_person.g_elig_dpnt_disabled_flag := l_dpel_disabled_flag_va(i) ;

Line 320: ben_ext_person.g_elig_dpnt_date_of_birth := l_dpel_date_of_birth_va(i) ;

316: ben_ext_person.g_elig_dpnt_middle_names := l_dpel_middle_names_va(i) ;
317: ben_ext_person.g_elig_dpnt_full_name := l_dpel_full_name_va(i) ;
318: ben_ext_person.g_elig_dpnt_suffix := l_dpel_suffix_va(i) ;
319: ben_ext_person.g_elig_dpnt_title := l_dpel_title_va(i) ;
320: ben_ext_person.g_elig_dpnt_date_of_birth := l_dpel_date_of_birth_va(i) ;
321: ben_ext_person.g_elig_dpnt_marital_status := l_dpel_marital_status_va(i) ;
322: ben_ext_person.g_elig_dpnt_sex := l_dpel_sex_va(i) ;
323: ben_ext_person.g_elig_dpnt_disabled_flag := l_dpel_disabled_flag_va(i) ;
324: ben_ext_person.g_elig_dpnt_student_status := l_dpel_student_status_va(i) ;

Line 321: ben_ext_person.g_elig_dpnt_marital_status := l_dpel_marital_status_va(i) ;

317: ben_ext_person.g_elig_dpnt_full_name := l_dpel_full_name_va(i) ;
318: ben_ext_person.g_elig_dpnt_suffix := l_dpel_suffix_va(i) ;
319: ben_ext_person.g_elig_dpnt_title := l_dpel_title_va(i) ;
320: ben_ext_person.g_elig_dpnt_date_of_birth := l_dpel_date_of_birth_va(i) ;
321: ben_ext_person.g_elig_dpnt_marital_status := l_dpel_marital_status_va(i) ;
322: ben_ext_person.g_elig_dpnt_sex := l_dpel_sex_va(i) ;
323: ben_ext_person.g_elig_dpnt_disabled_flag := l_dpel_disabled_flag_va(i) ;
324: ben_ext_person.g_elig_dpnt_student_status := l_dpel_student_status_va(i) ;
325: ben_ext_person.g_elig_dpnt_date_of_death := l_dpel_date_of_death_va(i) ;

Line 322: ben_ext_person.g_elig_dpnt_sex := l_dpel_sex_va(i) ;

318: ben_ext_person.g_elig_dpnt_suffix := l_dpel_suffix_va(i) ;
319: ben_ext_person.g_elig_dpnt_title := l_dpel_title_va(i) ;
320: ben_ext_person.g_elig_dpnt_date_of_birth := l_dpel_date_of_birth_va(i) ;
321: ben_ext_person.g_elig_dpnt_marital_status := l_dpel_marital_status_va(i) ;
322: ben_ext_person.g_elig_dpnt_sex := l_dpel_sex_va(i) ;
323: ben_ext_person.g_elig_dpnt_disabled_flag := l_dpel_disabled_flag_va(i) ;
324: ben_ext_person.g_elig_dpnt_student_status := l_dpel_student_status_va(i) ;
325: ben_ext_person.g_elig_dpnt_date_of_death := l_dpel_date_of_death_va(i) ;
326: ben_ext_person.g_elig_dpnt_language := l_dpel_correspondence_lang_va(i) ;

Line 323: ben_ext_person.g_elig_dpnt_disabled_flag := l_dpel_disabled_flag_va(i) ;

319: ben_ext_person.g_elig_dpnt_title := l_dpel_title_va(i) ;
320: ben_ext_person.g_elig_dpnt_date_of_birth := l_dpel_date_of_birth_va(i) ;
321: ben_ext_person.g_elig_dpnt_marital_status := l_dpel_marital_status_va(i) ;
322: ben_ext_person.g_elig_dpnt_sex := l_dpel_sex_va(i) ;
323: ben_ext_person.g_elig_dpnt_disabled_flag := l_dpel_disabled_flag_va(i) ;
324: ben_ext_person.g_elig_dpnt_student_status := l_dpel_student_status_va(i) ;
325: ben_ext_person.g_elig_dpnt_date_of_death := l_dpel_date_of_death_va(i) ;
326: ben_ext_person.g_elig_dpnt_language := l_dpel_correspondence_lang_va(i) ;
327: ben_ext_person.g_elig_dpnt_nationality := l_dpel_nationality_va(i) ;

Line 324: ben_ext_person.g_elig_dpnt_student_status := l_dpel_student_status_va(i) ;

320: ben_ext_person.g_elig_dpnt_date_of_birth := l_dpel_date_of_birth_va(i) ;
321: ben_ext_person.g_elig_dpnt_marital_status := l_dpel_marital_status_va(i) ;
322: ben_ext_person.g_elig_dpnt_sex := l_dpel_sex_va(i) ;
323: ben_ext_person.g_elig_dpnt_disabled_flag := l_dpel_disabled_flag_va(i) ;
324: ben_ext_person.g_elig_dpnt_student_status := l_dpel_student_status_va(i) ;
325: ben_ext_person.g_elig_dpnt_date_of_death := l_dpel_date_of_death_va(i) ;
326: ben_ext_person.g_elig_dpnt_language := l_dpel_correspondence_lang_va(i) ;
327: ben_ext_person.g_elig_dpnt_nationality := l_dpel_nationality_va(i) ;
328: ben_ext_person.g_elig_dpnt_email_address := l_dpel_email_address_va(i) ;

Line 325: ben_ext_person.g_elig_dpnt_date_of_death := l_dpel_date_of_death_va(i) ;

321: ben_ext_person.g_elig_dpnt_marital_status := l_dpel_marital_status_va(i) ;
322: ben_ext_person.g_elig_dpnt_sex := l_dpel_sex_va(i) ;
323: ben_ext_person.g_elig_dpnt_disabled_flag := l_dpel_disabled_flag_va(i) ;
324: ben_ext_person.g_elig_dpnt_student_status := l_dpel_student_status_va(i) ;
325: ben_ext_person.g_elig_dpnt_date_of_death := l_dpel_date_of_death_va(i) ;
326: ben_ext_person.g_elig_dpnt_language := l_dpel_correspondence_lang_va(i) ;
327: ben_ext_person.g_elig_dpnt_nationality := l_dpel_nationality_va(i) ;
328: ben_ext_person.g_elig_dpnt_email_address := l_dpel_email_address_va(i) ;
329: ben_ext_person.g_elig_dpnt_known_as := l_dpel_known_as_va(i) ;

Line 326: ben_ext_person.g_elig_dpnt_language := l_dpel_correspondence_lang_va(i) ;

322: ben_ext_person.g_elig_dpnt_sex := l_dpel_sex_va(i) ;
323: ben_ext_person.g_elig_dpnt_disabled_flag := l_dpel_disabled_flag_va(i) ;
324: ben_ext_person.g_elig_dpnt_student_status := l_dpel_student_status_va(i) ;
325: ben_ext_person.g_elig_dpnt_date_of_death := l_dpel_date_of_death_va(i) ;
326: ben_ext_person.g_elig_dpnt_language := l_dpel_correspondence_lang_va(i) ;
327: ben_ext_person.g_elig_dpnt_nationality := l_dpel_nationality_va(i) ;
328: ben_ext_person.g_elig_dpnt_email_address := l_dpel_email_address_va(i) ;
329: ben_ext_person.g_elig_dpnt_known_as := l_dpel_known_as_va(i) ;
330: ben_ext_person.g_elig_dpnt_pre_name_adjunct := l_dpel_pre_name_adjunct_va(i) ;

Line 327: ben_ext_person.g_elig_dpnt_nationality := l_dpel_nationality_va(i) ;

323: ben_ext_person.g_elig_dpnt_disabled_flag := l_dpel_disabled_flag_va(i) ;
324: ben_ext_person.g_elig_dpnt_student_status := l_dpel_student_status_va(i) ;
325: ben_ext_person.g_elig_dpnt_date_of_death := l_dpel_date_of_death_va(i) ;
326: ben_ext_person.g_elig_dpnt_language := l_dpel_correspondence_lang_va(i) ;
327: ben_ext_person.g_elig_dpnt_nationality := l_dpel_nationality_va(i) ;
328: ben_ext_person.g_elig_dpnt_email_address := l_dpel_email_address_va(i) ;
329: ben_ext_person.g_elig_dpnt_known_as := l_dpel_known_as_va(i) ;
330: ben_ext_person.g_elig_dpnt_pre_name_adjunct := l_dpel_pre_name_adjunct_va(i) ;
331: ben_ext_person.g_elig_dpnt_tobacco_usage := l_dpel_uses_tobacco_flag_va(i) ;

Line 328: ben_ext_person.g_elig_dpnt_email_address := l_dpel_email_address_va(i) ;

324: ben_ext_person.g_elig_dpnt_student_status := l_dpel_student_status_va(i) ;
325: ben_ext_person.g_elig_dpnt_date_of_death := l_dpel_date_of_death_va(i) ;
326: ben_ext_person.g_elig_dpnt_language := l_dpel_correspondence_lang_va(i) ;
327: ben_ext_person.g_elig_dpnt_nationality := l_dpel_nationality_va(i) ;
328: ben_ext_person.g_elig_dpnt_email_address := l_dpel_email_address_va(i) ;
329: ben_ext_person.g_elig_dpnt_known_as := l_dpel_known_as_va(i) ;
330: ben_ext_person.g_elig_dpnt_pre_name_adjunct := l_dpel_pre_name_adjunct_va(i) ;
331: ben_ext_person.g_elig_dpnt_tobacco_usage := l_dpel_uses_tobacco_flag_va(i) ;
332: ben_ext_person.g_elig_dpnt_prev_last_name := l_dpel_previous_last_name_va(i) ;

Line 329: ben_ext_person.g_elig_dpnt_known_as := l_dpel_known_as_va(i) ;

325: ben_ext_person.g_elig_dpnt_date_of_death := l_dpel_date_of_death_va(i) ;
326: ben_ext_person.g_elig_dpnt_language := l_dpel_correspondence_lang_va(i) ;
327: ben_ext_person.g_elig_dpnt_nationality := l_dpel_nationality_va(i) ;
328: ben_ext_person.g_elig_dpnt_email_address := l_dpel_email_address_va(i) ;
329: ben_ext_person.g_elig_dpnt_known_as := l_dpel_known_as_va(i) ;
330: ben_ext_person.g_elig_dpnt_pre_name_adjunct := l_dpel_pre_name_adjunct_va(i) ;
331: ben_ext_person.g_elig_dpnt_tobacco_usage := l_dpel_uses_tobacco_flag_va(i) ;
332: ben_ext_person.g_elig_dpnt_prev_last_name := l_dpel_previous_last_name_va(i) ;
333: --

Line 330: ben_ext_person.g_elig_dpnt_pre_name_adjunct := l_dpel_pre_name_adjunct_va(i) ;

326: ben_ext_person.g_elig_dpnt_language := l_dpel_correspondence_lang_va(i) ;
327: ben_ext_person.g_elig_dpnt_nationality := l_dpel_nationality_va(i) ;
328: ben_ext_person.g_elig_dpnt_email_address := l_dpel_email_address_va(i) ;
329: ben_ext_person.g_elig_dpnt_known_as := l_dpel_known_as_va(i) ;
330: ben_ext_person.g_elig_dpnt_pre_name_adjunct := l_dpel_pre_name_adjunct_va(i) ;
331: ben_ext_person.g_elig_dpnt_tobacco_usage := l_dpel_uses_tobacco_flag_va(i) ;
332: ben_ext_person.g_elig_dpnt_prev_last_name := l_dpel_previous_last_name_va(i) ;
333: --
334: -- retrieve dependent address info if required

Line 331: ben_ext_person.g_elig_dpnt_tobacco_usage := l_dpel_uses_tobacco_flag_va(i) ;

327: ben_ext_person.g_elig_dpnt_nationality := l_dpel_nationality_va(i) ;
328: ben_ext_person.g_elig_dpnt_email_address := l_dpel_email_address_va(i) ;
329: ben_ext_person.g_elig_dpnt_known_as := l_dpel_known_as_va(i) ;
330: ben_ext_person.g_elig_dpnt_pre_name_adjunct := l_dpel_pre_name_adjunct_va(i) ;
331: ben_ext_person.g_elig_dpnt_tobacco_usage := l_dpel_uses_tobacco_flag_va(i) ;
332: ben_ext_person.g_elig_dpnt_prev_last_name := l_dpel_previous_last_name_va(i) ;
333: --
334: -- retrieve dependent address info if required
335: if ben_extract.g_eda_csr = 'Y' then

Line 332: ben_ext_person.g_elig_dpnt_prev_last_name := l_dpel_previous_last_name_va(i) ;

328: ben_ext_person.g_elig_dpnt_email_address := l_dpel_email_address_va(i) ;
329: ben_ext_person.g_elig_dpnt_known_as := l_dpel_known_as_va(i) ;
330: ben_ext_person.g_elig_dpnt_pre_name_adjunct := l_dpel_pre_name_adjunct_va(i) ;
331: ben_ext_person.g_elig_dpnt_tobacco_usage := l_dpel_uses_tobacco_flag_va(i) ;
332: ben_ext_person.g_elig_dpnt_prev_last_name := l_dpel_previous_last_name_va(i) ;
333: --
334: -- retrieve dependent address info if required
335: if ben_extract.g_eda_csr = 'Y' then
336: open prim_address_c (l_dpel_dpnt_person_id_va(i));

Line 337: fetch prim_address_c into ben_ext_person.g_elig_dpnt_prim_address1

333: --
334: -- retrieve dependent address info if required
335: if ben_extract.g_eda_csr = 'Y' then
336: open prim_address_c (l_dpel_dpnt_person_id_va(i));
337: fetch prim_address_c into ben_ext_person.g_elig_dpnt_prim_address1
338: ,ben_ext_person.g_elig_dpnt_prim_address2
339: ,ben_ext_person.g_elig_dpnt_prim_address3
340: ,ben_ext_person.g_elig_dpnt_prim_city
341: ,ben_ext_person.g_elig_dpnt_prim_state

Line 338: ,ben_ext_person.g_elig_dpnt_prim_address2

334: -- retrieve dependent address info if required
335: if ben_extract.g_eda_csr = 'Y' then
336: open prim_address_c (l_dpel_dpnt_person_id_va(i));
337: fetch prim_address_c into ben_ext_person.g_elig_dpnt_prim_address1
338: ,ben_ext_person.g_elig_dpnt_prim_address2
339: ,ben_ext_person.g_elig_dpnt_prim_address3
340: ,ben_ext_person.g_elig_dpnt_prim_city
341: ,ben_ext_person.g_elig_dpnt_prim_state
342: ,ben_ext_person.g_elig_dpnt_prim_postal_code

Line 339: ,ben_ext_person.g_elig_dpnt_prim_address3

335: if ben_extract.g_eda_csr = 'Y' then
336: open prim_address_c (l_dpel_dpnt_person_id_va(i));
337: fetch prim_address_c into ben_ext_person.g_elig_dpnt_prim_address1
338: ,ben_ext_person.g_elig_dpnt_prim_address2
339: ,ben_ext_person.g_elig_dpnt_prim_address3
340: ,ben_ext_person.g_elig_dpnt_prim_city
341: ,ben_ext_person.g_elig_dpnt_prim_state
342: ,ben_ext_person.g_elig_dpnt_prim_postal_code
343: ,ben_ext_person.g_elig_dpnt_prim_country

Line 340: ,ben_ext_person.g_elig_dpnt_prim_city

336: open prim_address_c (l_dpel_dpnt_person_id_va(i));
337: fetch prim_address_c into ben_ext_person.g_elig_dpnt_prim_address1
338: ,ben_ext_person.g_elig_dpnt_prim_address2
339: ,ben_ext_person.g_elig_dpnt_prim_address3
340: ,ben_ext_person.g_elig_dpnt_prim_city
341: ,ben_ext_person.g_elig_dpnt_prim_state
342: ,ben_ext_person.g_elig_dpnt_prim_postal_code
343: ,ben_ext_person.g_elig_dpnt_prim_country
344: ,ben_ext_person.g_elig_dpnt_prim_effect_date

Line 341: ,ben_ext_person.g_elig_dpnt_prim_state

337: fetch prim_address_c into ben_ext_person.g_elig_dpnt_prim_address1
338: ,ben_ext_person.g_elig_dpnt_prim_address2
339: ,ben_ext_person.g_elig_dpnt_prim_address3
340: ,ben_ext_person.g_elig_dpnt_prim_city
341: ,ben_ext_person.g_elig_dpnt_prim_state
342: ,ben_ext_person.g_elig_dpnt_prim_postal_code
343: ,ben_ext_person.g_elig_dpnt_prim_country
344: ,ben_ext_person.g_elig_dpnt_prim_effect_date
345: ,ben_ext_person.g_elig_dpnt_prim_region;

Line 342: ,ben_ext_person.g_elig_dpnt_prim_postal_code

338: ,ben_ext_person.g_elig_dpnt_prim_address2
339: ,ben_ext_person.g_elig_dpnt_prim_address3
340: ,ben_ext_person.g_elig_dpnt_prim_city
341: ,ben_ext_person.g_elig_dpnt_prim_state
342: ,ben_ext_person.g_elig_dpnt_prim_postal_code
343: ,ben_ext_person.g_elig_dpnt_prim_country
344: ,ben_ext_person.g_elig_dpnt_prim_effect_date
345: ,ben_ext_person.g_elig_dpnt_prim_region;
346: if prim_address_c%notfound then

Line 343: ,ben_ext_person.g_elig_dpnt_prim_country

339: ,ben_ext_person.g_elig_dpnt_prim_address3
340: ,ben_ext_person.g_elig_dpnt_prim_city
341: ,ben_ext_person.g_elig_dpnt_prim_state
342: ,ben_ext_person.g_elig_dpnt_prim_postal_code
343: ,ben_ext_person.g_elig_dpnt_prim_country
344: ,ben_ext_person.g_elig_dpnt_prim_effect_date
345: ,ben_ext_person.g_elig_dpnt_prim_region;
346: if prim_address_c%notfound then
347: open prim_rltd_address_c(l_dpel_dpnt_person_id_va(i));

Line 344: ,ben_ext_person.g_elig_dpnt_prim_effect_date

340: ,ben_ext_person.g_elig_dpnt_prim_city
341: ,ben_ext_person.g_elig_dpnt_prim_state
342: ,ben_ext_person.g_elig_dpnt_prim_postal_code
343: ,ben_ext_person.g_elig_dpnt_prim_country
344: ,ben_ext_person.g_elig_dpnt_prim_effect_date
345: ,ben_ext_person.g_elig_dpnt_prim_region;
346: if prim_address_c%notfound then
347: open prim_rltd_address_c(l_dpel_dpnt_person_id_va(i));
348: fetch prim_rltd_address_c into ben_ext_person.g_elig_dpnt_prim_address1

Line 345: ,ben_ext_person.g_elig_dpnt_prim_region;

341: ,ben_ext_person.g_elig_dpnt_prim_state
342: ,ben_ext_person.g_elig_dpnt_prim_postal_code
343: ,ben_ext_person.g_elig_dpnt_prim_country
344: ,ben_ext_person.g_elig_dpnt_prim_effect_date
345: ,ben_ext_person.g_elig_dpnt_prim_region;
346: if prim_address_c%notfound then
347: open prim_rltd_address_c(l_dpel_dpnt_person_id_va(i));
348: fetch prim_rltd_address_c into ben_ext_person.g_elig_dpnt_prim_address1
349: , ben_ext_person.g_elig_dpnt_prim_address2

Line 348: fetch prim_rltd_address_c into ben_ext_person.g_elig_dpnt_prim_address1

344: ,ben_ext_person.g_elig_dpnt_prim_effect_date
345: ,ben_ext_person.g_elig_dpnt_prim_region;
346: if prim_address_c%notfound then
347: open prim_rltd_address_c(l_dpel_dpnt_person_id_va(i));
348: fetch prim_rltd_address_c into ben_ext_person.g_elig_dpnt_prim_address1
349: , ben_ext_person.g_elig_dpnt_prim_address2
350: , ben_ext_person.g_elig_dpnt_prim_address3
351: , ben_ext_person.g_elig_dpnt_prim_city
352: , ben_ext_person.g_elig_dpnt_prim_state

Line 349: , ben_ext_person.g_elig_dpnt_prim_address2

345: ,ben_ext_person.g_elig_dpnt_prim_region;
346: if prim_address_c%notfound then
347: open prim_rltd_address_c(l_dpel_dpnt_person_id_va(i));
348: fetch prim_rltd_address_c into ben_ext_person.g_elig_dpnt_prim_address1
349: , ben_ext_person.g_elig_dpnt_prim_address2
350: , ben_ext_person.g_elig_dpnt_prim_address3
351: , ben_ext_person.g_elig_dpnt_prim_city
352: , ben_ext_person.g_elig_dpnt_prim_state
353: , ben_ext_person.g_elig_dpnt_prim_postal_code

Line 350: , ben_ext_person.g_elig_dpnt_prim_address3

346: if prim_address_c%notfound then
347: open prim_rltd_address_c(l_dpel_dpnt_person_id_va(i));
348: fetch prim_rltd_address_c into ben_ext_person.g_elig_dpnt_prim_address1
349: , ben_ext_person.g_elig_dpnt_prim_address2
350: , ben_ext_person.g_elig_dpnt_prim_address3
351: , ben_ext_person.g_elig_dpnt_prim_city
352: , ben_ext_person.g_elig_dpnt_prim_state
353: , ben_ext_person.g_elig_dpnt_prim_postal_code
354: , ben_ext_person.g_elig_dpnt_prim_country

Line 351: , ben_ext_person.g_elig_dpnt_prim_city

347: open prim_rltd_address_c(l_dpel_dpnt_person_id_va(i));
348: fetch prim_rltd_address_c into ben_ext_person.g_elig_dpnt_prim_address1
349: , ben_ext_person.g_elig_dpnt_prim_address2
350: , ben_ext_person.g_elig_dpnt_prim_address3
351: , ben_ext_person.g_elig_dpnt_prim_city
352: , ben_ext_person.g_elig_dpnt_prim_state
353: , ben_ext_person.g_elig_dpnt_prim_postal_code
354: , ben_ext_person.g_elig_dpnt_prim_country
355: , ben_ext_person.g_elig_dpnt_prim_effect_date

Line 352: , ben_ext_person.g_elig_dpnt_prim_state

348: fetch prim_rltd_address_c into ben_ext_person.g_elig_dpnt_prim_address1
349: , ben_ext_person.g_elig_dpnt_prim_address2
350: , ben_ext_person.g_elig_dpnt_prim_address3
351: , ben_ext_person.g_elig_dpnt_prim_city
352: , ben_ext_person.g_elig_dpnt_prim_state
353: , ben_ext_person.g_elig_dpnt_prim_postal_code
354: , ben_ext_person.g_elig_dpnt_prim_country
355: , ben_ext_person.g_elig_dpnt_prim_effect_date
356: , ben_ext_person.g_elig_dpnt_prim_region;

Line 353: , ben_ext_person.g_elig_dpnt_prim_postal_code

349: , ben_ext_person.g_elig_dpnt_prim_address2
350: , ben_ext_person.g_elig_dpnt_prim_address3
351: , ben_ext_person.g_elig_dpnt_prim_city
352: , ben_ext_person.g_elig_dpnt_prim_state
353: , ben_ext_person.g_elig_dpnt_prim_postal_code
354: , ben_ext_person.g_elig_dpnt_prim_country
355: , ben_ext_person.g_elig_dpnt_prim_effect_date
356: , ben_ext_person.g_elig_dpnt_prim_region;
357: close prim_rltd_address_c;

Line 354: , ben_ext_person.g_elig_dpnt_prim_country

350: , ben_ext_person.g_elig_dpnt_prim_address3
351: , ben_ext_person.g_elig_dpnt_prim_city
352: , ben_ext_person.g_elig_dpnt_prim_state
353: , ben_ext_person.g_elig_dpnt_prim_postal_code
354: , ben_ext_person.g_elig_dpnt_prim_country
355: , ben_ext_person.g_elig_dpnt_prim_effect_date
356: , ben_ext_person.g_elig_dpnt_prim_region;
357: close prim_rltd_address_c;
358: end if;

Line 355: , ben_ext_person.g_elig_dpnt_prim_effect_date

351: , ben_ext_person.g_elig_dpnt_prim_city
352: , ben_ext_person.g_elig_dpnt_prim_state
353: , ben_ext_person.g_elig_dpnt_prim_postal_code
354: , ben_ext_person.g_elig_dpnt_prim_country
355: , ben_ext_person.g_elig_dpnt_prim_effect_date
356: , ben_ext_person.g_elig_dpnt_prim_region;
357: close prim_rltd_address_c;
358: end if;
359: close prim_address_c;

Line 356: , ben_ext_person.g_elig_dpnt_prim_region;

352: , ben_ext_person.g_elig_dpnt_prim_state
353: , ben_ext_person.g_elig_dpnt_prim_postal_code
354: , ben_ext_person.g_elig_dpnt_prim_country
355: , ben_ext_person.g_elig_dpnt_prim_effect_date
356: , ben_ext_person.g_elig_dpnt_prim_region;
357: close prim_rltd_address_c;
358: end if;
359: close prim_address_c;
360: end if;

Line 365: fetch ext_phone_c into ben_ext_person.g_elig_dpnt_home_phone

361: --
362: -- retrieve dependent phone numbers if required
363: if ben_extract.g_edp_csr = 'Y' then
364: open ext_phone_c(l_dpel_dpnt_person_id_va(i));
365: fetch ext_phone_c into ben_ext_person.g_elig_dpnt_home_phone
366: ,ben_ext_person.g_elig_dpnt_work_phone
367: ,ben_ext_person.g_elig_dpnt_fax
368: ,ben_ext_person.g_elig_dpnt_mobile;
369: close ext_phone_c;

Line 366: ,ben_ext_person.g_elig_dpnt_work_phone

362: -- retrieve dependent phone numbers if required
363: if ben_extract.g_edp_csr = 'Y' then
364: open ext_phone_c(l_dpel_dpnt_person_id_va(i));
365: fetch ext_phone_c into ben_ext_person.g_elig_dpnt_home_phone
366: ,ben_ext_person.g_elig_dpnt_work_phone
367: ,ben_ext_person.g_elig_dpnt_fax
368: ,ben_ext_person.g_elig_dpnt_mobile;
369: close ext_phone_c;
370: end if;

Line 367: ,ben_ext_person.g_elig_dpnt_fax

363: if ben_extract.g_edp_csr = 'Y' then
364: open ext_phone_c(l_dpel_dpnt_person_id_va(i));
365: fetch ext_phone_c into ben_ext_person.g_elig_dpnt_home_phone
366: ,ben_ext_person.g_elig_dpnt_work_phone
367: ,ben_ext_person.g_elig_dpnt_fax
368: ,ben_ext_person.g_elig_dpnt_mobile;
369: close ext_phone_c;
370: end if;
371: --

Line 368: ,ben_ext_person.g_elig_dpnt_mobile;

364: open ext_phone_c(l_dpel_dpnt_person_id_va(i));
365: fetch ext_phone_c into ben_ext_person.g_elig_dpnt_home_phone
366: ,ben_ext_person.g_elig_dpnt_work_phone
367: ,ben_ext_person.g_elig_dpnt_fax
368: ,ben_ext_person.g_elig_dpnt_mobile;
369: close ext_phone_c;
370: end if;
371: --
372: -- format and write