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_DPNT dependencies on BEN_EXT_PERSON

Line 24: ben_ext_person.g_dpnt_cvrd_dpnt_id := null;

20: --
21: hr_utility.set_location('Entering'||l_proc, 5);
22: --
23: --
24: ben_ext_person.g_dpnt_cvrd_dpnt_id := null;
25: ben_ext_person.g_dpnt_cvg_strt_dt := null;
26: ben_ext_person.g_dpnt_cvg_thru_dt := null;
27: ben_ext_person.g_dpnt_rlshp_type := null;
28: ben_ext_person.g_dpnt_contact_seq_num := null;

Line 25: ben_ext_person.g_dpnt_cvg_strt_dt := null;

21: hr_utility.set_location('Entering'||l_proc, 5);
22: --
23: --
24: ben_ext_person.g_dpnt_cvrd_dpnt_id := null;
25: ben_ext_person.g_dpnt_cvg_strt_dt := null;
26: ben_ext_person.g_dpnt_cvg_thru_dt := null;
27: ben_ext_person.g_dpnt_rlshp_type := null;
28: ben_ext_person.g_dpnt_contact_seq_num := null;
29: ben_ext_person.g_dpnt_shared_resd_flag := null;

Line 26: ben_ext_person.g_dpnt_cvg_thru_dt := null;

22: --
23: --
24: ben_ext_person.g_dpnt_cvrd_dpnt_id := null;
25: ben_ext_person.g_dpnt_cvg_strt_dt := null;
26: ben_ext_person.g_dpnt_cvg_thru_dt := null;
27: ben_ext_person.g_dpnt_rlshp_type := null;
28: ben_ext_person.g_dpnt_contact_seq_num := null;
29: ben_ext_person.g_dpnt_shared_resd_flag := null;
30: ben_ext_person.g_dpnt_national_identifier := null;

Line 27: ben_ext_person.g_dpnt_rlshp_type := null;

23: --
24: ben_ext_person.g_dpnt_cvrd_dpnt_id := null;
25: ben_ext_person.g_dpnt_cvg_strt_dt := null;
26: ben_ext_person.g_dpnt_cvg_thru_dt := null;
27: ben_ext_person.g_dpnt_rlshp_type := null;
28: ben_ext_person.g_dpnt_contact_seq_num := null;
29: ben_ext_person.g_dpnt_shared_resd_flag := null;
30: ben_ext_person.g_dpnt_national_identifier := null;
31: ben_ext_person.g_dpnt_last_name := null;

Line 28: ben_ext_person.g_dpnt_contact_seq_num := null;

24: ben_ext_person.g_dpnt_cvrd_dpnt_id := null;
25: ben_ext_person.g_dpnt_cvg_strt_dt := null;
26: ben_ext_person.g_dpnt_cvg_thru_dt := null;
27: ben_ext_person.g_dpnt_rlshp_type := null;
28: ben_ext_person.g_dpnt_contact_seq_num := null;
29: ben_ext_person.g_dpnt_shared_resd_flag := null;
30: ben_ext_person.g_dpnt_national_identifier := null;
31: ben_ext_person.g_dpnt_last_name := null;
32: ben_ext_person.g_dpnt_first_name := null;

Line 29: ben_ext_person.g_dpnt_shared_resd_flag := null;

25: ben_ext_person.g_dpnt_cvg_strt_dt := null;
26: ben_ext_person.g_dpnt_cvg_thru_dt := null;
27: ben_ext_person.g_dpnt_rlshp_type := null;
28: ben_ext_person.g_dpnt_contact_seq_num := null;
29: ben_ext_person.g_dpnt_shared_resd_flag := null;
30: ben_ext_person.g_dpnt_national_identifier := null;
31: ben_ext_person.g_dpnt_last_name := null;
32: ben_ext_person.g_dpnt_first_name := null;
33: ben_ext_person.g_dpnt_middle_names := null;

Line 30: ben_ext_person.g_dpnt_national_identifier := null;

26: ben_ext_person.g_dpnt_cvg_thru_dt := null;
27: ben_ext_person.g_dpnt_rlshp_type := null;
28: ben_ext_person.g_dpnt_contact_seq_num := null;
29: ben_ext_person.g_dpnt_shared_resd_flag := null;
30: ben_ext_person.g_dpnt_national_identifier := null;
31: ben_ext_person.g_dpnt_last_name := null;
32: ben_ext_person.g_dpnt_first_name := null;
33: ben_ext_person.g_dpnt_middle_names := null;
34: ben_ext_person.g_dpnt_full_name := null;

Line 31: ben_ext_person.g_dpnt_last_name := null;

27: ben_ext_person.g_dpnt_rlshp_type := null;
28: ben_ext_person.g_dpnt_contact_seq_num := null;
29: ben_ext_person.g_dpnt_shared_resd_flag := null;
30: ben_ext_person.g_dpnt_national_identifier := null;
31: ben_ext_person.g_dpnt_last_name := null;
32: ben_ext_person.g_dpnt_first_name := null;
33: ben_ext_person.g_dpnt_middle_names := null;
34: ben_ext_person.g_dpnt_full_name := null;
35: ben_ext_person.g_dpnt_suffix := null;

Line 32: ben_ext_person.g_dpnt_first_name := null;

28: ben_ext_person.g_dpnt_contact_seq_num := null;
29: ben_ext_person.g_dpnt_shared_resd_flag := null;
30: ben_ext_person.g_dpnt_national_identifier := null;
31: ben_ext_person.g_dpnt_last_name := null;
32: ben_ext_person.g_dpnt_first_name := null;
33: ben_ext_person.g_dpnt_middle_names := null;
34: ben_ext_person.g_dpnt_full_name := null;
35: ben_ext_person.g_dpnt_suffix := null;
36: ben_ext_person.g_dpnt_prefix := null;

Line 33: ben_ext_person.g_dpnt_middle_names := null;

29: ben_ext_person.g_dpnt_shared_resd_flag := null;
30: ben_ext_person.g_dpnt_national_identifier := null;
31: ben_ext_person.g_dpnt_last_name := null;
32: ben_ext_person.g_dpnt_first_name := null;
33: ben_ext_person.g_dpnt_middle_names := null;
34: ben_ext_person.g_dpnt_full_name := null;
35: ben_ext_person.g_dpnt_suffix := null;
36: ben_ext_person.g_dpnt_prefix := null;
37: ben_ext_person.g_dpnt_title := null;

Line 34: ben_ext_person.g_dpnt_full_name := null;

30: ben_ext_person.g_dpnt_national_identifier := null;
31: ben_ext_person.g_dpnt_last_name := null;
32: ben_ext_person.g_dpnt_first_name := null;
33: ben_ext_person.g_dpnt_middle_names := null;
34: ben_ext_person.g_dpnt_full_name := null;
35: ben_ext_person.g_dpnt_suffix := null;
36: ben_ext_person.g_dpnt_prefix := null;
37: ben_ext_person.g_dpnt_title := null;
38: ben_ext_person.g_dpnt_date_of_birth := null;

Line 35: ben_ext_person.g_dpnt_suffix := null;

31: ben_ext_person.g_dpnt_last_name := null;
32: ben_ext_person.g_dpnt_first_name := null;
33: ben_ext_person.g_dpnt_middle_names := null;
34: ben_ext_person.g_dpnt_full_name := null;
35: ben_ext_person.g_dpnt_suffix := null;
36: ben_ext_person.g_dpnt_prefix := null;
37: ben_ext_person.g_dpnt_title := null;
38: ben_ext_person.g_dpnt_date_of_birth := null;
39: ben_ext_person.g_dpnt_marital_status := null;

Line 36: ben_ext_person.g_dpnt_prefix := null;

32: ben_ext_person.g_dpnt_first_name := null;
33: ben_ext_person.g_dpnt_middle_names := null;
34: ben_ext_person.g_dpnt_full_name := null;
35: ben_ext_person.g_dpnt_suffix := null;
36: ben_ext_person.g_dpnt_prefix := null;
37: ben_ext_person.g_dpnt_title := null;
38: ben_ext_person.g_dpnt_date_of_birth := null;
39: ben_ext_person.g_dpnt_marital_status := null;
40: ben_ext_person.g_dpnt_sex := null;

Line 37: ben_ext_person.g_dpnt_title := null;

33: ben_ext_person.g_dpnt_middle_names := null;
34: ben_ext_person.g_dpnt_full_name := null;
35: ben_ext_person.g_dpnt_suffix := null;
36: ben_ext_person.g_dpnt_prefix := null;
37: ben_ext_person.g_dpnt_title := null;
38: ben_ext_person.g_dpnt_date_of_birth := null;
39: ben_ext_person.g_dpnt_marital_status := null;
40: ben_ext_person.g_dpnt_sex := null;
41: ben_ext_person.g_dpnt_disabled_flag := null;

Line 38: ben_ext_person.g_dpnt_date_of_birth := null;

34: ben_ext_person.g_dpnt_full_name := null;
35: ben_ext_person.g_dpnt_suffix := null;
36: ben_ext_person.g_dpnt_prefix := null;
37: ben_ext_person.g_dpnt_title := null;
38: ben_ext_person.g_dpnt_date_of_birth := null;
39: ben_ext_person.g_dpnt_marital_status := null;
40: ben_ext_person.g_dpnt_sex := null;
41: ben_ext_person.g_dpnt_disabled_flag := null;
42: ben_ext_person.g_dpnt_student_status := null;

Line 39: ben_ext_person.g_dpnt_marital_status := null;

35: ben_ext_person.g_dpnt_suffix := null;
36: ben_ext_person.g_dpnt_prefix := null;
37: ben_ext_person.g_dpnt_title := null;
38: ben_ext_person.g_dpnt_date_of_birth := null;
39: ben_ext_person.g_dpnt_marital_status := null;
40: ben_ext_person.g_dpnt_sex := null;
41: ben_ext_person.g_dpnt_disabled_flag := null;
42: ben_ext_person.g_dpnt_student_status := null;
43: ben_ext_person.g_dpnt_date_of_death := null;

Line 40: ben_ext_person.g_dpnt_sex := null;

36: ben_ext_person.g_dpnt_prefix := null;
37: ben_ext_person.g_dpnt_title := null;
38: ben_ext_person.g_dpnt_date_of_birth := null;
39: ben_ext_person.g_dpnt_marital_status := null;
40: ben_ext_person.g_dpnt_sex := null;
41: ben_ext_person.g_dpnt_disabled_flag := null;
42: ben_ext_person.g_dpnt_student_status := null;
43: ben_ext_person.g_dpnt_date_of_death := null;
44: ben_ext_person.g_dpnt_language := null;

Line 41: ben_ext_person.g_dpnt_disabled_flag := null;

37: ben_ext_person.g_dpnt_title := null;
38: ben_ext_person.g_dpnt_date_of_birth := null;
39: ben_ext_person.g_dpnt_marital_status := null;
40: ben_ext_person.g_dpnt_sex := null;
41: ben_ext_person.g_dpnt_disabled_flag := null;
42: ben_ext_person.g_dpnt_student_status := null;
43: ben_ext_person.g_dpnt_date_of_death := null;
44: ben_ext_person.g_dpnt_language := null;
45: ben_ext_person.g_dpnt_nationality := null;

Line 42: ben_ext_person.g_dpnt_student_status := null;

38: ben_ext_person.g_dpnt_date_of_birth := null;
39: ben_ext_person.g_dpnt_marital_status := null;
40: ben_ext_person.g_dpnt_sex := null;
41: ben_ext_person.g_dpnt_disabled_flag := null;
42: ben_ext_person.g_dpnt_student_status := null;
43: ben_ext_person.g_dpnt_date_of_death := null;
44: ben_ext_person.g_dpnt_language := null;
45: ben_ext_person.g_dpnt_nationality := null;
46: ben_ext_person.g_dpnt_email_address := null;

Line 43: ben_ext_person.g_dpnt_date_of_death := null;

39: ben_ext_person.g_dpnt_marital_status := null;
40: ben_ext_person.g_dpnt_sex := null;
41: ben_ext_person.g_dpnt_disabled_flag := null;
42: ben_ext_person.g_dpnt_student_status := null;
43: ben_ext_person.g_dpnt_date_of_death := null;
44: ben_ext_person.g_dpnt_language := null;
45: ben_ext_person.g_dpnt_nationality := null;
46: ben_ext_person.g_dpnt_email_address := null;
47: ben_ext_person.g_dpnt_known_as := null;

Line 44: ben_ext_person.g_dpnt_language := null;

40: ben_ext_person.g_dpnt_sex := null;
41: ben_ext_person.g_dpnt_disabled_flag := null;
42: ben_ext_person.g_dpnt_student_status := null;
43: ben_ext_person.g_dpnt_date_of_death := null;
44: ben_ext_person.g_dpnt_language := null;
45: ben_ext_person.g_dpnt_nationality := null;
46: ben_ext_person.g_dpnt_email_address := null;
47: ben_ext_person.g_dpnt_known_as := null;
48: ben_ext_person.g_dpnt_known_as := null;

Line 45: ben_ext_person.g_dpnt_nationality := null;

41: ben_ext_person.g_dpnt_disabled_flag := null;
42: ben_ext_person.g_dpnt_student_status := null;
43: ben_ext_person.g_dpnt_date_of_death := null;
44: ben_ext_person.g_dpnt_language := null;
45: ben_ext_person.g_dpnt_nationality := null;
46: ben_ext_person.g_dpnt_email_address := null;
47: ben_ext_person.g_dpnt_known_as := null;
48: ben_ext_person.g_dpnt_known_as := null;
49: ben_ext_person.g_dpnt_pre_name_adjunct := null;

Line 46: ben_ext_person.g_dpnt_email_address := null;

42: ben_ext_person.g_dpnt_student_status := null;
43: ben_ext_person.g_dpnt_date_of_death := null;
44: ben_ext_person.g_dpnt_language := null;
45: ben_ext_person.g_dpnt_nationality := null;
46: ben_ext_person.g_dpnt_email_address := null;
47: ben_ext_person.g_dpnt_known_as := null;
48: ben_ext_person.g_dpnt_known_as := null;
49: ben_ext_person.g_dpnt_pre_name_adjunct := null;
50: ben_ext_person.g_dpnt_tobacco_usage := null;

Line 47: ben_ext_person.g_dpnt_known_as := null;

43: ben_ext_person.g_dpnt_date_of_death := null;
44: ben_ext_person.g_dpnt_language := null;
45: ben_ext_person.g_dpnt_nationality := null;
46: ben_ext_person.g_dpnt_email_address := null;
47: ben_ext_person.g_dpnt_known_as := null;
48: ben_ext_person.g_dpnt_known_as := null;
49: ben_ext_person.g_dpnt_pre_name_adjunct := null;
50: ben_ext_person.g_dpnt_tobacco_usage := null;
51: ben_ext_person.g_dpnt_prev_last_name := null;

Line 48: ben_ext_person.g_dpnt_known_as := null;

44: ben_ext_person.g_dpnt_language := null;
45: ben_ext_person.g_dpnt_nationality := null;
46: ben_ext_person.g_dpnt_email_address := null;
47: ben_ext_person.g_dpnt_known_as := null;
48: ben_ext_person.g_dpnt_known_as := null;
49: ben_ext_person.g_dpnt_pre_name_adjunct := null;
50: ben_ext_person.g_dpnt_tobacco_usage := null;
51: ben_ext_person.g_dpnt_prev_last_name := null;
52: ben_ext_person.g_dpnt_prim_address1 := null;

Line 49: ben_ext_person.g_dpnt_pre_name_adjunct := null;

45: ben_ext_person.g_dpnt_nationality := null;
46: ben_ext_person.g_dpnt_email_address := null;
47: ben_ext_person.g_dpnt_known_as := null;
48: ben_ext_person.g_dpnt_known_as := null;
49: ben_ext_person.g_dpnt_pre_name_adjunct := null;
50: ben_ext_person.g_dpnt_tobacco_usage := null;
51: ben_ext_person.g_dpnt_prev_last_name := null;
52: ben_ext_person.g_dpnt_prim_address1 := null;
53: ben_ext_person.g_dpnt_prim_address2 := null;

Line 50: ben_ext_person.g_dpnt_tobacco_usage := null;

46: ben_ext_person.g_dpnt_email_address := null;
47: ben_ext_person.g_dpnt_known_as := null;
48: ben_ext_person.g_dpnt_known_as := null;
49: ben_ext_person.g_dpnt_pre_name_adjunct := null;
50: ben_ext_person.g_dpnt_tobacco_usage := null;
51: ben_ext_person.g_dpnt_prev_last_name := null;
52: ben_ext_person.g_dpnt_prim_address1 := null;
53: ben_ext_person.g_dpnt_prim_address2 := null;
54: ben_ext_person.g_dpnt_prim_address3 := null;

Line 51: ben_ext_person.g_dpnt_prev_last_name := null;

47: ben_ext_person.g_dpnt_known_as := null;
48: ben_ext_person.g_dpnt_known_as := null;
49: ben_ext_person.g_dpnt_pre_name_adjunct := null;
50: ben_ext_person.g_dpnt_tobacco_usage := null;
51: ben_ext_person.g_dpnt_prev_last_name := null;
52: ben_ext_person.g_dpnt_prim_address1 := null;
53: ben_ext_person.g_dpnt_prim_address2 := null;
54: ben_ext_person.g_dpnt_prim_address3 := null;
55: ben_ext_person.g_dpnt_prim_city := null;

Line 52: ben_ext_person.g_dpnt_prim_address1 := null;

48: ben_ext_person.g_dpnt_known_as := null;
49: ben_ext_person.g_dpnt_pre_name_adjunct := null;
50: ben_ext_person.g_dpnt_tobacco_usage := null;
51: ben_ext_person.g_dpnt_prev_last_name := null;
52: ben_ext_person.g_dpnt_prim_address1 := null;
53: ben_ext_person.g_dpnt_prim_address2 := null;
54: ben_ext_person.g_dpnt_prim_address3 := null;
55: ben_ext_person.g_dpnt_prim_city := null;
56: ben_ext_person.g_dpnt_prim_state := null;

Line 53: ben_ext_person.g_dpnt_prim_address2 := null;

49: ben_ext_person.g_dpnt_pre_name_adjunct := null;
50: ben_ext_person.g_dpnt_tobacco_usage := null;
51: ben_ext_person.g_dpnt_prev_last_name := null;
52: ben_ext_person.g_dpnt_prim_address1 := null;
53: ben_ext_person.g_dpnt_prim_address2 := null;
54: ben_ext_person.g_dpnt_prim_address3 := null;
55: ben_ext_person.g_dpnt_prim_city := null;
56: ben_ext_person.g_dpnt_prim_state := null;
57: ben_ext_person.g_dpnt_prim_postal_code := null;

Line 54: ben_ext_person.g_dpnt_prim_address3 := null;

50: ben_ext_person.g_dpnt_tobacco_usage := null;
51: ben_ext_person.g_dpnt_prev_last_name := null;
52: ben_ext_person.g_dpnt_prim_address1 := null;
53: ben_ext_person.g_dpnt_prim_address2 := null;
54: ben_ext_person.g_dpnt_prim_address3 := null;
55: ben_ext_person.g_dpnt_prim_city := null;
56: ben_ext_person.g_dpnt_prim_state := null;
57: ben_ext_person.g_dpnt_prim_postal_code := null;
58: ben_ext_person.g_dpnt_prim_country := null;

Line 55: ben_ext_person.g_dpnt_prim_city := null;

51: ben_ext_person.g_dpnt_prev_last_name := null;
52: ben_ext_person.g_dpnt_prim_address1 := null;
53: ben_ext_person.g_dpnt_prim_address2 := null;
54: ben_ext_person.g_dpnt_prim_address3 := null;
55: ben_ext_person.g_dpnt_prim_city := null;
56: ben_ext_person.g_dpnt_prim_state := null;
57: ben_ext_person.g_dpnt_prim_postal_code := null;
58: ben_ext_person.g_dpnt_prim_country := null;
59: ben_ext_person.g_dpnt_prim_effect_date := null;

Line 56: ben_ext_person.g_dpnt_prim_state := null;

52: ben_ext_person.g_dpnt_prim_address1 := null;
53: ben_ext_person.g_dpnt_prim_address2 := null;
54: ben_ext_person.g_dpnt_prim_address3 := null;
55: ben_ext_person.g_dpnt_prim_city := null;
56: ben_ext_person.g_dpnt_prim_state := null;
57: ben_ext_person.g_dpnt_prim_postal_code := null;
58: ben_ext_person.g_dpnt_prim_country := null;
59: ben_ext_person.g_dpnt_prim_effect_date := null;
60: ben_ext_person.g_dpnt_prim_region := null;

Line 57: ben_ext_person.g_dpnt_prim_postal_code := null;

53: ben_ext_person.g_dpnt_prim_address2 := null;
54: ben_ext_person.g_dpnt_prim_address3 := null;
55: ben_ext_person.g_dpnt_prim_city := null;
56: ben_ext_person.g_dpnt_prim_state := null;
57: ben_ext_person.g_dpnt_prim_postal_code := null;
58: ben_ext_person.g_dpnt_prim_country := null;
59: ben_ext_person.g_dpnt_prim_effect_date := null;
60: ben_ext_person.g_dpnt_prim_region := null;
61: ben_ext_person.g_dpnt_home_phone := null;

Line 58: ben_ext_person.g_dpnt_prim_country := null;

54: ben_ext_person.g_dpnt_prim_address3 := null;
55: ben_ext_person.g_dpnt_prim_city := null;
56: ben_ext_person.g_dpnt_prim_state := null;
57: ben_ext_person.g_dpnt_prim_postal_code := null;
58: ben_ext_person.g_dpnt_prim_country := null;
59: ben_ext_person.g_dpnt_prim_effect_date := null;
60: ben_ext_person.g_dpnt_prim_region := null;
61: ben_ext_person.g_dpnt_home_phone := null;
62: ben_ext_person.g_dpnt_work_phone := null;

Line 59: ben_ext_person.g_dpnt_prim_effect_date := null;

55: ben_ext_person.g_dpnt_prim_city := null;
56: ben_ext_person.g_dpnt_prim_state := null;
57: ben_ext_person.g_dpnt_prim_postal_code := null;
58: ben_ext_person.g_dpnt_prim_country := null;
59: ben_ext_person.g_dpnt_prim_effect_date := null;
60: ben_ext_person.g_dpnt_prim_region := null;
61: ben_ext_person.g_dpnt_home_phone := null;
62: ben_ext_person.g_dpnt_work_phone := null;
63: ben_ext_person.g_dpnt_fax := null;

Line 60: ben_ext_person.g_dpnt_prim_region := null;

56: ben_ext_person.g_dpnt_prim_state := null;
57: ben_ext_person.g_dpnt_prim_postal_code := null;
58: ben_ext_person.g_dpnt_prim_country := null;
59: ben_ext_person.g_dpnt_prim_effect_date := null;
60: ben_ext_person.g_dpnt_prim_region := null;
61: ben_ext_person.g_dpnt_home_phone := null;
62: ben_ext_person.g_dpnt_work_phone := null;
63: ben_ext_person.g_dpnt_fax := null;
64: ben_ext_person.g_dpnt_mobile := null;

Line 61: ben_ext_person.g_dpnt_home_phone := null;

57: ben_ext_person.g_dpnt_prim_postal_code := null;
58: ben_ext_person.g_dpnt_prim_country := null;
59: ben_ext_person.g_dpnt_prim_effect_date := null;
60: ben_ext_person.g_dpnt_prim_region := null;
61: ben_ext_person.g_dpnt_home_phone := null;
62: ben_ext_person.g_dpnt_work_phone := null;
63: ben_ext_person.g_dpnt_fax := null;
64: ben_ext_person.g_dpnt_mobile := null;
65: ben_ext_person.g_dpnt_ppr_name := null;

Line 62: ben_ext_person.g_dpnt_work_phone := null;

58: ben_ext_person.g_dpnt_prim_country := null;
59: ben_ext_person.g_dpnt_prim_effect_date := null;
60: ben_ext_person.g_dpnt_prim_region := null;
61: ben_ext_person.g_dpnt_home_phone := null;
62: ben_ext_person.g_dpnt_work_phone := null;
63: ben_ext_person.g_dpnt_fax := null;
64: ben_ext_person.g_dpnt_mobile := null;
65: ben_ext_person.g_dpnt_ppr_name := null;
66: ben_ext_person.g_dpnt_ppr_ident := null;

Line 63: ben_ext_person.g_dpnt_fax := null;

59: ben_ext_person.g_dpnt_prim_effect_date := null;
60: ben_ext_person.g_dpnt_prim_region := null;
61: ben_ext_person.g_dpnt_home_phone := null;
62: ben_ext_person.g_dpnt_work_phone := null;
63: ben_ext_person.g_dpnt_fax := null;
64: ben_ext_person.g_dpnt_mobile := null;
65: ben_ext_person.g_dpnt_ppr_name := null;
66: ben_ext_person.g_dpnt_ppr_ident := null;
67: ben_ext_person.g_dpnt_ppr_typ := null;

Line 64: ben_ext_person.g_dpnt_mobile := null;

60: ben_ext_person.g_dpnt_prim_region := null;
61: ben_ext_person.g_dpnt_home_phone := null;
62: ben_ext_person.g_dpnt_work_phone := null;
63: ben_ext_person.g_dpnt_fax := null;
64: ben_ext_person.g_dpnt_mobile := null;
65: ben_ext_person.g_dpnt_ppr_name := null;
66: ben_ext_person.g_dpnt_ppr_ident := null;
67: ben_ext_person.g_dpnt_ppr_typ := null;
68: ben_ext_person.g_dpnt_ppr_strt_dt := null;

Line 65: ben_ext_person.g_dpnt_ppr_name := null;

61: ben_ext_person.g_dpnt_home_phone := null;
62: ben_ext_person.g_dpnt_work_phone := null;
63: ben_ext_person.g_dpnt_fax := null;
64: ben_ext_person.g_dpnt_mobile := null;
65: ben_ext_person.g_dpnt_ppr_name := null;
66: ben_ext_person.g_dpnt_ppr_ident := null;
67: ben_ext_person.g_dpnt_ppr_typ := null;
68: ben_ext_person.g_dpnt_ppr_strt_dt := null;
69: ben_ext_person.g_dpnt_ppr_end_dt := null;

Line 66: ben_ext_person.g_dpnt_ppr_ident := null;

62: ben_ext_person.g_dpnt_work_phone := null;
63: ben_ext_person.g_dpnt_fax := null;
64: ben_ext_person.g_dpnt_mobile := null;
65: ben_ext_person.g_dpnt_ppr_name := null;
66: ben_ext_person.g_dpnt_ppr_ident := null;
67: ben_ext_person.g_dpnt_ppr_typ := null;
68: ben_ext_person.g_dpnt_ppr_strt_dt := null;
69: ben_ext_person.g_dpnt_ppr_end_dt := null;
70: --

Line 67: ben_ext_person.g_dpnt_ppr_typ := null;

63: ben_ext_person.g_dpnt_fax := null;
64: ben_ext_person.g_dpnt_mobile := null;
65: ben_ext_person.g_dpnt_ppr_name := null;
66: ben_ext_person.g_dpnt_ppr_ident := null;
67: ben_ext_person.g_dpnt_ppr_typ := null;
68: ben_ext_person.g_dpnt_ppr_strt_dt := null;
69: ben_ext_person.g_dpnt_ppr_end_dt := null;
70: --
71: --

Line 68: ben_ext_person.g_dpnt_ppr_strt_dt := null;

64: ben_ext_person.g_dpnt_mobile := null;
65: ben_ext_person.g_dpnt_ppr_name := null;
66: ben_ext_person.g_dpnt_ppr_ident := null;
67: ben_ext_person.g_dpnt_ppr_typ := null;
68: ben_ext_person.g_dpnt_ppr_strt_dt := null;
69: ben_ext_person.g_dpnt_ppr_end_dt := null;
70: --
71: --
72: hr_utility.set_location('Exiting'||l_proc, 15);

Line 69: ben_ext_person.g_dpnt_ppr_end_dt := null;

65: ben_ext_person.g_dpnt_ppr_name := null;
66: ben_ext_person.g_dpnt_ppr_ident := null;
67: ben_ext_person.g_dpnt_ppr_typ := null;
68: ben_ext_person.g_dpnt_ppr_strt_dt := null;
69: ben_ext_person.g_dpnt_ppr_end_dt := null;
70: --
71: --
72: hr_utility.set_location('Exiting'||l_proc, 15);
73: --

Line 275: hr_utility.set_location('param ' || ben_ext_person.g_chg_prmtr_06 ,88);

271: initialize_globals;
272: --validationg the coverage date
273: --if it is change event and for the dependent then
274: --extract only the dependent
275: hr_utility.set_location('param ' || ben_ext_person.g_chg_prmtr_06 ,88);
276: hr_utility.set_location('dependent ' || dpnt.dpnt_person_id ,88);
277: hr_utility.set_location('rslt ' || ben_ext_person.g_chg_prmtr_06 ,88);
278: hr_utility.set_location('prm rslt ' || p_prtt_enrt_rslt_id ,88);
279:

Line 277: hr_utility.set_location('rslt ' || ben_ext_person.g_chg_prmtr_06 ,88);

273: --if it is change event and for the dependent then
274: --extract only the dependent
275: hr_utility.set_location('param ' || ben_ext_person.g_chg_prmtr_06 ,88);
276: hr_utility.set_location('dependent ' || dpnt.dpnt_person_id ,88);
277: hr_utility.set_location('rslt ' || ben_ext_person.g_chg_prmtr_06 ,88);
278: hr_utility.set_location('prm rslt ' || p_prtt_enrt_rslt_id ,88);
279:
280:
281: --- get the pil info from ecdpnt per in ler id

Line 295: p_pl_id => ben_ext_person.g_enrt_pl_id ,

291:
292: ben_ext_evaluate_inclusion.evaluate_benefit_incl(
293: p_enrt_cvg_strt_dt => dpnt.cvg_strt_dt,
294: p_enrt_cvg_thru_dt => dpnt.cvg_thru_dt,
295: p_pl_id => ben_ext_person.g_enrt_pl_id ,
296: p_sspndd_flag => ben_ext_person.g_enrt_suspended_flag,
297: p_prtt_enrt_rslt_stat_cd => ben_ext_person.g_enrt_status_cd,
298: p_enrt_mthd_cd => ben_ext_person.g_enrt_method,
299: p_pgm_id => ben_ext_person.g_enrt_pgm_id ,

Line 296: p_sspndd_flag => ben_ext_person.g_enrt_suspended_flag,

292: ben_ext_evaluate_inclusion.evaluate_benefit_incl(
293: p_enrt_cvg_strt_dt => dpnt.cvg_strt_dt,
294: p_enrt_cvg_thru_dt => dpnt.cvg_thru_dt,
295: p_pl_id => ben_ext_person.g_enrt_pl_id ,
296: p_sspndd_flag => ben_ext_person.g_enrt_suspended_flag,
297: p_prtt_enrt_rslt_stat_cd => ben_ext_person.g_enrt_status_cd,
298: p_enrt_mthd_cd => ben_ext_person.g_enrt_method,
299: p_pgm_id => ben_ext_person.g_enrt_pgm_id ,
300: p_pl_typ_id => ben_ext_person.g_enrt_pl_typ_id,

Line 297: p_prtt_enrt_rslt_stat_cd => ben_ext_person.g_enrt_status_cd,

293: p_enrt_cvg_strt_dt => dpnt.cvg_strt_dt,
294: p_enrt_cvg_thru_dt => dpnt.cvg_thru_dt,
295: p_pl_id => ben_ext_person.g_enrt_pl_id ,
296: p_sspndd_flag => ben_ext_person.g_enrt_suspended_flag,
297: p_prtt_enrt_rslt_stat_cd => ben_ext_person.g_enrt_status_cd,
298: p_enrt_mthd_cd => ben_ext_person.g_enrt_method,
299: p_pgm_id => ben_ext_person.g_enrt_pgm_id ,
300: p_pl_typ_id => ben_ext_person.g_enrt_pl_typ_id,
301: p_last_update_date => dpnt.last_update_date,

Line 298: p_enrt_mthd_cd => ben_ext_person.g_enrt_method,

294: p_enrt_cvg_thru_dt => dpnt.cvg_thru_dt,
295: p_pl_id => ben_ext_person.g_enrt_pl_id ,
296: p_sspndd_flag => ben_ext_person.g_enrt_suspended_flag,
297: p_prtt_enrt_rslt_stat_cd => ben_ext_person.g_enrt_status_cd,
298: p_enrt_mthd_cd => ben_ext_person.g_enrt_method,
299: p_pgm_id => ben_ext_person.g_enrt_pgm_id ,
300: p_pl_typ_id => ben_ext_person.g_enrt_pl_typ_id,
301: p_last_update_date => dpnt.last_update_date,
302: p_ler_id => nvl(l_ler_id,ben_ext_person.g_enrt_ler_id),

Line 299: p_pgm_id => ben_ext_person.g_enrt_pgm_id ,

295: p_pl_id => ben_ext_person.g_enrt_pl_id ,
296: p_sspndd_flag => ben_ext_person.g_enrt_suspended_flag,
297: p_prtt_enrt_rslt_stat_cd => ben_ext_person.g_enrt_status_cd,
298: p_enrt_mthd_cd => ben_ext_person.g_enrt_method,
299: p_pgm_id => ben_ext_person.g_enrt_pgm_id ,
300: p_pl_typ_id => ben_ext_person.g_enrt_pl_typ_id,
301: p_last_update_date => dpnt.last_update_date,
302: p_ler_id => nvl(l_ler_id,ben_ext_person.g_enrt_ler_id),
303: p_ntfn_dt => nvl(l_NTFN_DT,ben_ext_person.g_enrt_lfevt_note_dt),

Line 300: p_pl_typ_id => ben_ext_person.g_enrt_pl_typ_id,

296: p_sspndd_flag => ben_ext_person.g_enrt_suspended_flag,
297: p_prtt_enrt_rslt_stat_cd => ben_ext_person.g_enrt_status_cd,
298: p_enrt_mthd_cd => ben_ext_person.g_enrt_method,
299: p_pgm_id => ben_ext_person.g_enrt_pgm_id ,
300: p_pl_typ_id => ben_ext_person.g_enrt_pl_typ_id,
301: p_last_update_date => dpnt.last_update_date,
302: p_ler_id => nvl(l_ler_id,ben_ext_person.g_enrt_ler_id),
303: p_ntfn_dt => nvl(l_NTFN_DT,ben_ext_person.g_enrt_lfevt_note_dt),
304: p_lf_evt_ocrd_dt => nvl(l_LF_EVT_OCRD_DT,ben_ext_person.g_enrt_lfevt_ocrd_dt) ,

Line 302: p_ler_id => nvl(l_ler_id,ben_ext_person.g_enrt_ler_id),

298: p_enrt_mthd_cd => ben_ext_person.g_enrt_method,
299: p_pgm_id => ben_ext_person.g_enrt_pgm_id ,
300: p_pl_typ_id => ben_ext_person.g_enrt_pl_typ_id,
301: p_last_update_date => dpnt.last_update_date,
302: p_ler_id => nvl(l_ler_id,ben_ext_person.g_enrt_ler_id),
303: p_ntfn_dt => nvl(l_NTFN_DT,ben_ext_person.g_enrt_lfevt_note_dt),
304: p_lf_evt_ocrd_dt => nvl(l_LF_EVT_OCRD_DT,ben_ext_person.g_enrt_lfevt_ocrd_dt) ,
305: p_per_in_ler_stat_cd => nvl(l_per_in_ler_stat_cd,ben_ext_person.g_enrt_lfevt_status),
306: p_per_in_ler_id => dpnt.per_in_ler_id,

Line 303: p_ntfn_dt => nvl(l_NTFN_DT,ben_ext_person.g_enrt_lfevt_note_dt),

299: p_pgm_id => ben_ext_person.g_enrt_pgm_id ,
300: p_pl_typ_id => ben_ext_person.g_enrt_pl_typ_id,
301: p_last_update_date => dpnt.last_update_date,
302: p_ler_id => nvl(l_ler_id,ben_ext_person.g_enrt_ler_id),
303: p_ntfn_dt => nvl(l_NTFN_DT,ben_ext_person.g_enrt_lfevt_note_dt),
304: p_lf_evt_ocrd_dt => nvl(l_LF_EVT_OCRD_DT,ben_ext_person.g_enrt_lfevt_ocrd_dt) ,
305: p_per_in_ler_stat_cd => nvl(l_per_in_ler_stat_cd,ben_ext_person.g_enrt_lfevt_status),
306: p_per_in_ler_id => dpnt.per_in_ler_id,
307: p_prtt_enrt_rslt_id => dpnt.prtt_enrt_rslt_id,

Line 304: p_lf_evt_ocrd_dt => nvl(l_LF_EVT_OCRD_DT,ben_ext_person.g_enrt_lfevt_ocrd_dt) ,

300: p_pl_typ_id => ben_ext_person.g_enrt_pl_typ_id,
301: p_last_update_date => dpnt.last_update_date,
302: p_ler_id => nvl(l_ler_id,ben_ext_person.g_enrt_ler_id),
303: p_ntfn_dt => nvl(l_NTFN_DT,ben_ext_person.g_enrt_lfevt_note_dt),
304: p_lf_evt_ocrd_dt => nvl(l_LF_EVT_OCRD_DT,ben_ext_person.g_enrt_lfevt_ocrd_dt) ,
305: p_per_in_ler_stat_cd => nvl(l_per_in_ler_stat_cd,ben_ext_person.g_enrt_lfevt_status),
306: p_per_in_ler_id => dpnt.per_in_ler_id,
307: p_prtt_enrt_rslt_id => dpnt.prtt_enrt_rslt_id,
308: p_effective_date => p_effective_date,

Line 305: p_per_in_ler_stat_cd => nvl(l_per_in_ler_stat_cd,ben_ext_person.g_enrt_lfevt_status),

301: p_last_update_date => dpnt.last_update_date,
302: p_ler_id => nvl(l_ler_id,ben_ext_person.g_enrt_ler_id),
303: p_ntfn_dt => nvl(l_NTFN_DT,ben_ext_person.g_enrt_lfevt_note_dt),
304: p_lf_evt_ocrd_dt => nvl(l_LF_EVT_OCRD_DT,ben_ext_person.g_enrt_lfevt_ocrd_dt) ,
305: p_per_in_ler_stat_cd => nvl(l_per_in_ler_stat_cd,ben_ext_person.g_enrt_lfevt_status),
306: p_per_in_ler_id => dpnt.per_in_ler_id,
307: p_prtt_enrt_rslt_id => dpnt.prtt_enrt_rslt_id,
308: p_effective_date => p_effective_date,
309: p_dpnt_id => dpnt.dpnt_person_id,

Line 320: ben_ext_person.g_dpnt_cvrd_dpnt_id := dpnt.elig_cvrd_dpnt_id;

316: hr_utility.set_location(' internal loo include '||dpnt.full_name ,604);
317: -- fetch dependent information into globals
318: --
319: --RCHASE - Bug#6669 - Must initialize the g_dpnt_cvrd_dpnt_id cache entry
320: ben_ext_person.g_dpnt_cvrd_dpnt_id := dpnt.elig_cvrd_dpnt_id;
321: --RCHASE - End
322: ben_ext_person.g_dpnt_cvg_strt_dt := dpnt.cvg_strt_dt;
323: ben_ext_person.g_dpnt_cvg_thru_dt := dpnt.cvg_thru_dt;
324: ben_ext_person.g_dpnt_rlshp_type := dpnt.contact_type;

Line 322: ben_ext_person.g_dpnt_cvg_strt_dt := dpnt.cvg_strt_dt;

318: --
319: --RCHASE - Bug#6669 - Must initialize the g_dpnt_cvrd_dpnt_id cache entry
320: ben_ext_person.g_dpnt_cvrd_dpnt_id := dpnt.elig_cvrd_dpnt_id;
321: --RCHASE - End
322: ben_ext_person.g_dpnt_cvg_strt_dt := dpnt.cvg_strt_dt;
323: ben_ext_person.g_dpnt_cvg_thru_dt := dpnt.cvg_thru_dt;
324: ben_ext_person.g_dpnt_rlshp_type := dpnt.contact_type;
325: ben_ext_person.g_dpnt_contact_seq_num := dpnt.sequence_number;
326: ben_ext_person.g_dpnt_shared_resd_flag := dpnt.rltd_per_rsds_w_dsgntr_flag;

Line 323: ben_ext_person.g_dpnt_cvg_thru_dt := dpnt.cvg_thru_dt;

319: --RCHASE - Bug#6669 - Must initialize the g_dpnt_cvrd_dpnt_id cache entry
320: ben_ext_person.g_dpnt_cvrd_dpnt_id := dpnt.elig_cvrd_dpnt_id;
321: --RCHASE - End
322: ben_ext_person.g_dpnt_cvg_strt_dt := dpnt.cvg_strt_dt;
323: ben_ext_person.g_dpnt_cvg_thru_dt := dpnt.cvg_thru_dt;
324: ben_ext_person.g_dpnt_rlshp_type := dpnt.contact_type;
325: ben_ext_person.g_dpnt_contact_seq_num := dpnt.sequence_number;
326: ben_ext_person.g_dpnt_shared_resd_flag := dpnt.rltd_per_rsds_w_dsgntr_flag;
327: ben_ext_person.g_dpnt_national_identifier := dpnt.national_identifier;

Line 324: ben_ext_person.g_dpnt_rlshp_type := dpnt.contact_type;

320: ben_ext_person.g_dpnt_cvrd_dpnt_id := dpnt.elig_cvrd_dpnt_id;
321: --RCHASE - End
322: ben_ext_person.g_dpnt_cvg_strt_dt := dpnt.cvg_strt_dt;
323: ben_ext_person.g_dpnt_cvg_thru_dt := dpnt.cvg_thru_dt;
324: ben_ext_person.g_dpnt_rlshp_type := dpnt.contact_type;
325: ben_ext_person.g_dpnt_contact_seq_num := dpnt.sequence_number;
326: ben_ext_person.g_dpnt_shared_resd_flag := dpnt.rltd_per_rsds_w_dsgntr_flag;
327: ben_ext_person.g_dpnt_national_identifier := dpnt.national_identifier;
328: ben_ext_person.g_dpnt_last_name := dpnt.last_name;

Line 325: ben_ext_person.g_dpnt_contact_seq_num := dpnt.sequence_number;

321: --RCHASE - End
322: ben_ext_person.g_dpnt_cvg_strt_dt := dpnt.cvg_strt_dt;
323: ben_ext_person.g_dpnt_cvg_thru_dt := dpnt.cvg_thru_dt;
324: ben_ext_person.g_dpnt_rlshp_type := dpnt.contact_type;
325: ben_ext_person.g_dpnt_contact_seq_num := dpnt.sequence_number;
326: ben_ext_person.g_dpnt_shared_resd_flag := dpnt.rltd_per_rsds_w_dsgntr_flag;
327: ben_ext_person.g_dpnt_national_identifier := dpnt.national_identifier;
328: ben_ext_person.g_dpnt_last_name := dpnt.last_name;
329: ben_ext_person.g_dpnt_first_name := dpnt.first_name;

Line 326: ben_ext_person.g_dpnt_shared_resd_flag := dpnt.rltd_per_rsds_w_dsgntr_flag;

322: ben_ext_person.g_dpnt_cvg_strt_dt := dpnt.cvg_strt_dt;
323: ben_ext_person.g_dpnt_cvg_thru_dt := dpnt.cvg_thru_dt;
324: ben_ext_person.g_dpnt_rlshp_type := dpnt.contact_type;
325: ben_ext_person.g_dpnt_contact_seq_num := dpnt.sequence_number;
326: ben_ext_person.g_dpnt_shared_resd_flag := dpnt.rltd_per_rsds_w_dsgntr_flag;
327: ben_ext_person.g_dpnt_national_identifier := dpnt.national_identifier;
328: ben_ext_person.g_dpnt_last_name := dpnt.last_name;
329: ben_ext_person.g_dpnt_first_name := dpnt.first_name;
330: ben_ext_person.g_dpnt_middle_names := dpnt.middle_names;

Line 327: ben_ext_person.g_dpnt_national_identifier := dpnt.national_identifier;

323: ben_ext_person.g_dpnt_cvg_thru_dt := dpnt.cvg_thru_dt;
324: ben_ext_person.g_dpnt_rlshp_type := dpnt.contact_type;
325: ben_ext_person.g_dpnt_contact_seq_num := dpnt.sequence_number;
326: ben_ext_person.g_dpnt_shared_resd_flag := dpnt.rltd_per_rsds_w_dsgntr_flag;
327: ben_ext_person.g_dpnt_national_identifier := dpnt.national_identifier;
328: ben_ext_person.g_dpnt_last_name := dpnt.last_name;
329: ben_ext_person.g_dpnt_first_name := dpnt.first_name;
330: ben_ext_person.g_dpnt_middle_names := dpnt.middle_names;
331: ben_ext_person.g_dpnt_full_name := dpnt.full_name;

Line 328: ben_ext_person.g_dpnt_last_name := dpnt.last_name;

324: ben_ext_person.g_dpnt_rlshp_type := dpnt.contact_type;
325: ben_ext_person.g_dpnt_contact_seq_num := dpnt.sequence_number;
326: ben_ext_person.g_dpnt_shared_resd_flag := dpnt.rltd_per_rsds_w_dsgntr_flag;
327: ben_ext_person.g_dpnt_national_identifier := dpnt.national_identifier;
328: ben_ext_person.g_dpnt_last_name := dpnt.last_name;
329: ben_ext_person.g_dpnt_first_name := dpnt.first_name;
330: ben_ext_person.g_dpnt_middle_names := dpnt.middle_names;
331: ben_ext_person.g_dpnt_full_name := dpnt.full_name;
332: ben_ext_person.g_dpnt_suffix := dpnt.suffix;

Line 329: ben_ext_person.g_dpnt_first_name := dpnt.first_name;

325: ben_ext_person.g_dpnt_contact_seq_num := dpnt.sequence_number;
326: ben_ext_person.g_dpnt_shared_resd_flag := dpnt.rltd_per_rsds_w_dsgntr_flag;
327: ben_ext_person.g_dpnt_national_identifier := dpnt.national_identifier;
328: ben_ext_person.g_dpnt_last_name := dpnt.last_name;
329: ben_ext_person.g_dpnt_first_name := dpnt.first_name;
330: ben_ext_person.g_dpnt_middle_names := dpnt.middle_names;
331: ben_ext_person.g_dpnt_full_name := dpnt.full_name;
332: ben_ext_person.g_dpnt_suffix := dpnt.suffix;
333: ben_ext_person.g_dpnt_prefix := dpnt.prefix;

Line 330: ben_ext_person.g_dpnt_middle_names := dpnt.middle_names;

326: ben_ext_person.g_dpnt_shared_resd_flag := dpnt.rltd_per_rsds_w_dsgntr_flag;
327: ben_ext_person.g_dpnt_national_identifier := dpnt.national_identifier;
328: ben_ext_person.g_dpnt_last_name := dpnt.last_name;
329: ben_ext_person.g_dpnt_first_name := dpnt.first_name;
330: ben_ext_person.g_dpnt_middle_names := dpnt.middle_names;
331: ben_ext_person.g_dpnt_full_name := dpnt.full_name;
332: ben_ext_person.g_dpnt_suffix := dpnt.suffix;
333: ben_ext_person.g_dpnt_prefix := dpnt.prefix;
334: ben_ext_person.g_dpnt_title := dpnt.title;

Line 331: ben_ext_person.g_dpnt_full_name := dpnt.full_name;

327: ben_ext_person.g_dpnt_national_identifier := dpnt.national_identifier;
328: ben_ext_person.g_dpnt_last_name := dpnt.last_name;
329: ben_ext_person.g_dpnt_first_name := dpnt.first_name;
330: ben_ext_person.g_dpnt_middle_names := dpnt.middle_names;
331: ben_ext_person.g_dpnt_full_name := dpnt.full_name;
332: ben_ext_person.g_dpnt_suffix := dpnt.suffix;
333: ben_ext_person.g_dpnt_prefix := dpnt.prefix;
334: ben_ext_person.g_dpnt_title := dpnt.title;
335: ben_ext_person.g_dpnt_date_of_birth := dpnt.date_of_birth;

Line 332: ben_ext_person.g_dpnt_suffix := dpnt.suffix;

328: ben_ext_person.g_dpnt_last_name := dpnt.last_name;
329: ben_ext_person.g_dpnt_first_name := dpnt.first_name;
330: ben_ext_person.g_dpnt_middle_names := dpnt.middle_names;
331: ben_ext_person.g_dpnt_full_name := dpnt.full_name;
332: ben_ext_person.g_dpnt_suffix := dpnt.suffix;
333: ben_ext_person.g_dpnt_prefix := dpnt.prefix;
334: ben_ext_person.g_dpnt_title := dpnt.title;
335: ben_ext_person.g_dpnt_date_of_birth := dpnt.date_of_birth;
336: ben_ext_person.g_dpnt_marital_status := dpnt.marital_status;

Line 333: ben_ext_person.g_dpnt_prefix := dpnt.prefix;

329: ben_ext_person.g_dpnt_first_name := dpnt.first_name;
330: ben_ext_person.g_dpnt_middle_names := dpnt.middle_names;
331: ben_ext_person.g_dpnt_full_name := dpnt.full_name;
332: ben_ext_person.g_dpnt_suffix := dpnt.suffix;
333: ben_ext_person.g_dpnt_prefix := dpnt.prefix;
334: ben_ext_person.g_dpnt_title := dpnt.title;
335: ben_ext_person.g_dpnt_date_of_birth := dpnt.date_of_birth;
336: ben_ext_person.g_dpnt_marital_status := dpnt.marital_status;
337: ben_ext_person.g_dpnt_sex := dpnt.sex;

Line 334: ben_ext_person.g_dpnt_title := dpnt.title;

330: ben_ext_person.g_dpnt_middle_names := dpnt.middle_names;
331: ben_ext_person.g_dpnt_full_name := dpnt.full_name;
332: ben_ext_person.g_dpnt_suffix := dpnt.suffix;
333: ben_ext_person.g_dpnt_prefix := dpnt.prefix;
334: ben_ext_person.g_dpnt_title := dpnt.title;
335: ben_ext_person.g_dpnt_date_of_birth := dpnt.date_of_birth;
336: ben_ext_person.g_dpnt_marital_status := dpnt.marital_status;
337: ben_ext_person.g_dpnt_sex := dpnt.sex;
338: ben_ext_person.g_dpnt_disabled_flag := dpnt.registered_disabled_flag;

Line 335: ben_ext_person.g_dpnt_date_of_birth := dpnt.date_of_birth;

331: ben_ext_person.g_dpnt_full_name := dpnt.full_name;
332: ben_ext_person.g_dpnt_suffix := dpnt.suffix;
333: ben_ext_person.g_dpnt_prefix := dpnt.prefix;
334: ben_ext_person.g_dpnt_title := dpnt.title;
335: ben_ext_person.g_dpnt_date_of_birth := dpnt.date_of_birth;
336: ben_ext_person.g_dpnt_marital_status := dpnt.marital_status;
337: ben_ext_person.g_dpnt_sex := dpnt.sex;
338: ben_ext_person.g_dpnt_disabled_flag := dpnt.registered_disabled_flag;
339: ben_ext_person.g_dpnt_student_status := dpnt.student_status;

Line 336: ben_ext_person.g_dpnt_marital_status := dpnt.marital_status;

332: ben_ext_person.g_dpnt_suffix := dpnt.suffix;
333: ben_ext_person.g_dpnt_prefix := dpnt.prefix;
334: ben_ext_person.g_dpnt_title := dpnt.title;
335: ben_ext_person.g_dpnt_date_of_birth := dpnt.date_of_birth;
336: ben_ext_person.g_dpnt_marital_status := dpnt.marital_status;
337: ben_ext_person.g_dpnt_sex := dpnt.sex;
338: ben_ext_person.g_dpnt_disabled_flag := dpnt.registered_disabled_flag;
339: ben_ext_person.g_dpnt_student_status := dpnt.student_status;
340: ben_ext_person.g_dpnt_date_of_death := dpnt.date_of_death;

Line 337: ben_ext_person.g_dpnt_sex := dpnt.sex;

333: ben_ext_person.g_dpnt_prefix := dpnt.prefix;
334: ben_ext_person.g_dpnt_title := dpnt.title;
335: ben_ext_person.g_dpnt_date_of_birth := dpnt.date_of_birth;
336: ben_ext_person.g_dpnt_marital_status := dpnt.marital_status;
337: ben_ext_person.g_dpnt_sex := dpnt.sex;
338: ben_ext_person.g_dpnt_disabled_flag := dpnt.registered_disabled_flag;
339: ben_ext_person.g_dpnt_student_status := dpnt.student_status;
340: ben_ext_person.g_dpnt_date_of_death := dpnt.date_of_death;
341: ben_ext_person.g_dpnt_language := dpnt.correspondence_language;

Line 338: ben_ext_person.g_dpnt_disabled_flag := dpnt.registered_disabled_flag;

334: ben_ext_person.g_dpnt_title := dpnt.title;
335: ben_ext_person.g_dpnt_date_of_birth := dpnt.date_of_birth;
336: ben_ext_person.g_dpnt_marital_status := dpnt.marital_status;
337: ben_ext_person.g_dpnt_sex := dpnt.sex;
338: ben_ext_person.g_dpnt_disabled_flag := dpnt.registered_disabled_flag;
339: ben_ext_person.g_dpnt_student_status := dpnt.student_status;
340: ben_ext_person.g_dpnt_date_of_death := dpnt.date_of_death;
341: ben_ext_person.g_dpnt_language := dpnt.correspondence_language;
342: ben_ext_person.g_dpnt_nationality := dpnt.nationality;

Line 339: ben_ext_person.g_dpnt_student_status := dpnt.student_status;

335: ben_ext_person.g_dpnt_date_of_birth := dpnt.date_of_birth;
336: ben_ext_person.g_dpnt_marital_status := dpnt.marital_status;
337: ben_ext_person.g_dpnt_sex := dpnt.sex;
338: ben_ext_person.g_dpnt_disabled_flag := dpnt.registered_disabled_flag;
339: ben_ext_person.g_dpnt_student_status := dpnt.student_status;
340: ben_ext_person.g_dpnt_date_of_death := dpnt.date_of_death;
341: ben_ext_person.g_dpnt_language := dpnt.correspondence_language;
342: ben_ext_person.g_dpnt_nationality := dpnt.nationality;
343: ben_ext_person.g_dpnt_email_address := dpnt.email_address;

Line 340: ben_ext_person.g_dpnt_date_of_death := dpnt.date_of_death;

336: ben_ext_person.g_dpnt_marital_status := dpnt.marital_status;
337: ben_ext_person.g_dpnt_sex := dpnt.sex;
338: ben_ext_person.g_dpnt_disabled_flag := dpnt.registered_disabled_flag;
339: ben_ext_person.g_dpnt_student_status := dpnt.student_status;
340: ben_ext_person.g_dpnt_date_of_death := dpnt.date_of_death;
341: ben_ext_person.g_dpnt_language := dpnt.correspondence_language;
342: ben_ext_person.g_dpnt_nationality := dpnt.nationality;
343: ben_ext_person.g_dpnt_email_address := dpnt.email_address;
344: ben_ext_person.g_dpnt_known_as := dpnt.known_as;

Line 341: ben_ext_person.g_dpnt_language := dpnt.correspondence_language;

337: ben_ext_person.g_dpnt_sex := dpnt.sex;
338: ben_ext_person.g_dpnt_disabled_flag := dpnt.registered_disabled_flag;
339: ben_ext_person.g_dpnt_student_status := dpnt.student_status;
340: ben_ext_person.g_dpnt_date_of_death := dpnt.date_of_death;
341: ben_ext_person.g_dpnt_language := dpnt.correspondence_language;
342: ben_ext_person.g_dpnt_nationality := dpnt.nationality;
343: ben_ext_person.g_dpnt_email_address := dpnt.email_address;
344: ben_ext_person.g_dpnt_known_as := dpnt.known_as;
345: ben_ext_person.g_dpnt_pre_name_adjunct := dpnt.pre_name_adjunct;

Line 342: ben_ext_person.g_dpnt_nationality := dpnt.nationality;

338: ben_ext_person.g_dpnt_disabled_flag := dpnt.registered_disabled_flag;
339: ben_ext_person.g_dpnt_student_status := dpnt.student_status;
340: ben_ext_person.g_dpnt_date_of_death := dpnt.date_of_death;
341: ben_ext_person.g_dpnt_language := dpnt.correspondence_language;
342: ben_ext_person.g_dpnt_nationality := dpnt.nationality;
343: ben_ext_person.g_dpnt_email_address := dpnt.email_address;
344: ben_ext_person.g_dpnt_known_as := dpnt.known_as;
345: ben_ext_person.g_dpnt_pre_name_adjunct := dpnt.pre_name_adjunct;
346: ben_ext_person.g_dpnt_tobacco_usage := dpnt.uses_tobacco_flag;

Line 343: ben_ext_person.g_dpnt_email_address := dpnt.email_address;

339: ben_ext_person.g_dpnt_student_status := dpnt.student_status;
340: ben_ext_person.g_dpnt_date_of_death := dpnt.date_of_death;
341: ben_ext_person.g_dpnt_language := dpnt.correspondence_language;
342: ben_ext_person.g_dpnt_nationality := dpnt.nationality;
343: ben_ext_person.g_dpnt_email_address := dpnt.email_address;
344: ben_ext_person.g_dpnt_known_as := dpnt.known_as;
345: ben_ext_person.g_dpnt_pre_name_adjunct := dpnt.pre_name_adjunct;
346: ben_ext_person.g_dpnt_tobacco_usage := dpnt.uses_tobacco_flag;
347: ben_ext_person.g_dpnt_prev_last_name := dpnt.previous_last_name;

Line 344: ben_ext_person.g_dpnt_known_as := dpnt.known_as;

340: ben_ext_person.g_dpnt_date_of_death := dpnt.date_of_death;
341: ben_ext_person.g_dpnt_language := dpnt.correspondence_language;
342: ben_ext_person.g_dpnt_nationality := dpnt.nationality;
343: ben_ext_person.g_dpnt_email_address := dpnt.email_address;
344: ben_ext_person.g_dpnt_known_as := dpnt.known_as;
345: ben_ext_person.g_dpnt_pre_name_adjunct := dpnt.pre_name_adjunct;
346: ben_ext_person.g_dpnt_tobacco_usage := dpnt.uses_tobacco_flag;
347: ben_ext_person.g_dpnt_prev_last_name := dpnt.previous_last_name;
348: -- end if ;

Line 345: ben_ext_person.g_dpnt_pre_name_adjunct := dpnt.pre_name_adjunct;

341: ben_ext_person.g_dpnt_language := dpnt.correspondence_language;
342: ben_ext_person.g_dpnt_nationality := dpnt.nationality;
343: ben_ext_person.g_dpnt_email_address := dpnt.email_address;
344: ben_ext_person.g_dpnt_known_as := dpnt.known_as;
345: ben_ext_person.g_dpnt_pre_name_adjunct := dpnt.pre_name_adjunct;
346: ben_ext_person.g_dpnt_tobacco_usage := dpnt.uses_tobacco_flag;
347: ben_ext_person.g_dpnt_prev_last_name := dpnt.previous_last_name;
348: -- end if ;
349: --

Line 346: ben_ext_person.g_dpnt_tobacco_usage := dpnt.uses_tobacco_flag;

342: ben_ext_person.g_dpnt_nationality := dpnt.nationality;
343: ben_ext_person.g_dpnt_email_address := dpnt.email_address;
344: ben_ext_person.g_dpnt_known_as := dpnt.known_as;
345: ben_ext_person.g_dpnt_pre_name_adjunct := dpnt.pre_name_adjunct;
346: ben_ext_person.g_dpnt_tobacco_usage := dpnt.uses_tobacco_flag;
347: ben_ext_person.g_dpnt_prev_last_name := dpnt.previous_last_name;
348: -- end if ;
349: --
350: -- retrieve dependent address info if required

Line 347: ben_ext_person.g_dpnt_prev_last_name := dpnt.previous_last_name;

343: ben_ext_person.g_dpnt_email_address := dpnt.email_address;
344: ben_ext_person.g_dpnt_known_as := dpnt.known_as;
345: ben_ext_person.g_dpnt_pre_name_adjunct := dpnt.pre_name_adjunct;
346: ben_ext_person.g_dpnt_tobacco_usage := dpnt.uses_tobacco_flag;
347: ben_ext_person.g_dpnt_prev_last_name := dpnt.previous_last_name;
348: -- end if ;
349: --
350: -- retrieve dependent address info if required
351: if ben_extract.g_da_csr = 'Y' then

Line 353: fetch prim_address_c into ben_ext_person.g_dpnt_prim_address1

349: --
350: -- retrieve dependent address info if required
351: if ben_extract.g_da_csr = 'Y' then
352: open prim_address_c(dpnt.dpnt_person_id);
353: fetch prim_address_c into ben_ext_person.g_dpnt_prim_address1
354: ,ben_ext_person.g_dpnt_prim_address2
355: ,ben_ext_person.g_dpnt_prim_address3
356: ,ben_ext_person.g_dpnt_prim_city
357: ,ben_ext_person.g_dpnt_prim_state

Line 354: ,ben_ext_person.g_dpnt_prim_address2

350: -- retrieve dependent address info if required
351: if ben_extract.g_da_csr = 'Y' then
352: open prim_address_c(dpnt.dpnt_person_id);
353: fetch prim_address_c into ben_ext_person.g_dpnt_prim_address1
354: ,ben_ext_person.g_dpnt_prim_address2
355: ,ben_ext_person.g_dpnt_prim_address3
356: ,ben_ext_person.g_dpnt_prim_city
357: ,ben_ext_person.g_dpnt_prim_state
358: ,ben_ext_person.g_dpnt_prim_postal_code

Line 355: ,ben_ext_person.g_dpnt_prim_address3

351: if ben_extract.g_da_csr = 'Y' then
352: open prim_address_c(dpnt.dpnt_person_id);
353: fetch prim_address_c into ben_ext_person.g_dpnt_prim_address1
354: ,ben_ext_person.g_dpnt_prim_address2
355: ,ben_ext_person.g_dpnt_prim_address3
356: ,ben_ext_person.g_dpnt_prim_city
357: ,ben_ext_person.g_dpnt_prim_state
358: ,ben_ext_person.g_dpnt_prim_postal_code
359: ,ben_ext_person.g_dpnt_prim_country

Line 356: ,ben_ext_person.g_dpnt_prim_city

352: open prim_address_c(dpnt.dpnt_person_id);
353: fetch prim_address_c into ben_ext_person.g_dpnt_prim_address1
354: ,ben_ext_person.g_dpnt_prim_address2
355: ,ben_ext_person.g_dpnt_prim_address3
356: ,ben_ext_person.g_dpnt_prim_city
357: ,ben_ext_person.g_dpnt_prim_state
358: ,ben_ext_person.g_dpnt_prim_postal_code
359: ,ben_ext_person.g_dpnt_prim_country
360: ,ben_ext_person.g_dpnt_prim_effect_date

Line 357: ,ben_ext_person.g_dpnt_prim_state

353: fetch prim_address_c into ben_ext_person.g_dpnt_prim_address1
354: ,ben_ext_person.g_dpnt_prim_address2
355: ,ben_ext_person.g_dpnt_prim_address3
356: ,ben_ext_person.g_dpnt_prim_city
357: ,ben_ext_person.g_dpnt_prim_state
358: ,ben_ext_person.g_dpnt_prim_postal_code
359: ,ben_ext_person.g_dpnt_prim_country
360: ,ben_ext_person.g_dpnt_prim_effect_date
361: ,ben_ext_person.g_dpnt_prim_region;

Line 358: ,ben_ext_person.g_dpnt_prim_postal_code

354: ,ben_ext_person.g_dpnt_prim_address2
355: ,ben_ext_person.g_dpnt_prim_address3
356: ,ben_ext_person.g_dpnt_prim_city
357: ,ben_ext_person.g_dpnt_prim_state
358: ,ben_ext_person.g_dpnt_prim_postal_code
359: ,ben_ext_person.g_dpnt_prim_country
360: ,ben_ext_person.g_dpnt_prim_effect_date
361: ,ben_ext_person.g_dpnt_prim_region;
362: if prim_address_c%notfound then

Line 359: ,ben_ext_person.g_dpnt_prim_country

355: ,ben_ext_person.g_dpnt_prim_address3
356: ,ben_ext_person.g_dpnt_prim_city
357: ,ben_ext_person.g_dpnt_prim_state
358: ,ben_ext_person.g_dpnt_prim_postal_code
359: ,ben_ext_person.g_dpnt_prim_country
360: ,ben_ext_person.g_dpnt_prim_effect_date
361: ,ben_ext_person.g_dpnt_prim_region;
362: if prim_address_c%notfound then
363: open prim_rltd_address_c(dpnt.dpnt_person_id);

Line 360: ,ben_ext_person.g_dpnt_prim_effect_date

356: ,ben_ext_person.g_dpnt_prim_city
357: ,ben_ext_person.g_dpnt_prim_state
358: ,ben_ext_person.g_dpnt_prim_postal_code
359: ,ben_ext_person.g_dpnt_prim_country
360: ,ben_ext_person.g_dpnt_prim_effect_date
361: ,ben_ext_person.g_dpnt_prim_region;
362: if prim_address_c%notfound then
363: open prim_rltd_address_c(dpnt.dpnt_person_id);
364: fetch prim_rltd_address_c into ben_ext_person.g_dpnt_prim_address1

Line 361: ,ben_ext_person.g_dpnt_prim_region;

357: ,ben_ext_person.g_dpnt_prim_state
358: ,ben_ext_person.g_dpnt_prim_postal_code
359: ,ben_ext_person.g_dpnt_prim_country
360: ,ben_ext_person.g_dpnt_prim_effect_date
361: ,ben_ext_person.g_dpnt_prim_region;
362: if prim_address_c%notfound then
363: open prim_rltd_address_c(dpnt.dpnt_person_id);
364: fetch prim_rltd_address_c into ben_ext_person.g_dpnt_prim_address1
365: , ben_ext_person.g_dpnt_prim_address2

Line 364: fetch prim_rltd_address_c into ben_ext_person.g_dpnt_prim_address1

360: ,ben_ext_person.g_dpnt_prim_effect_date
361: ,ben_ext_person.g_dpnt_prim_region;
362: if prim_address_c%notfound then
363: open prim_rltd_address_c(dpnt.dpnt_person_id);
364: fetch prim_rltd_address_c into ben_ext_person.g_dpnt_prim_address1
365: , ben_ext_person.g_dpnt_prim_address2
366: , ben_ext_person.g_dpnt_prim_address3
367: , ben_ext_person.g_dpnt_prim_city
368: , ben_ext_person.g_dpnt_prim_state

Line 365: , ben_ext_person.g_dpnt_prim_address2

361: ,ben_ext_person.g_dpnt_prim_region;
362: if prim_address_c%notfound then
363: open prim_rltd_address_c(dpnt.dpnt_person_id);
364: fetch prim_rltd_address_c into ben_ext_person.g_dpnt_prim_address1
365: , ben_ext_person.g_dpnt_prim_address2
366: , ben_ext_person.g_dpnt_prim_address3
367: , ben_ext_person.g_dpnt_prim_city
368: , ben_ext_person.g_dpnt_prim_state
369: , ben_ext_person.g_dpnt_prim_postal_code

Line 366: , ben_ext_person.g_dpnt_prim_address3

362: if prim_address_c%notfound then
363: open prim_rltd_address_c(dpnt.dpnt_person_id);
364: fetch prim_rltd_address_c into ben_ext_person.g_dpnt_prim_address1
365: , ben_ext_person.g_dpnt_prim_address2
366: , ben_ext_person.g_dpnt_prim_address3
367: , ben_ext_person.g_dpnt_prim_city
368: , ben_ext_person.g_dpnt_prim_state
369: , ben_ext_person.g_dpnt_prim_postal_code
370: , ben_ext_person.g_dpnt_prim_country

Line 367: , ben_ext_person.g_dpnt_prim_city

363: open prim_rltd_address_c(dpnt.dpnt_person_id);
364: fetch prim_rltd_address_c into ben_ext_person.g_dpnt_prim_address1
365: , ben_ext_person.g_dpnt_prim_address2
366: , ben_ext_person.g_dpnt_prim_address3
367: , ben_ext_person.g_dpnt_prim_city
368: , ben_ext_person.g_dpnt_prim_state
369: , ben_ext_person.g_dpnt_prim_postal_code
370: , ben_ext_person.g_dpnt_prim_country
371: , ben_ext_person.g_dpnt_prim_effect_date

Line 368: , ben_ext_person.g_dpnt_prim_state

364: fetch prim_rltd_address_c into ben_ext_person.g_dpnt_prim_address1
365: , ben_ext_person.g_dpnt_prim_address2
366: , ben_ext_person.g_dpnt_prim_address3
367: , ben_ext_person.g_dpnt_prim_city
368: , ben_ext_person.g_dpnt_prim_state
369: , ben_ext_person.g_dpnt_prim_postal_code
370: , ben_ext_person.g_dpnt_prim_country
371: , ben_ext_person.g_dpnt_prim_effect_date
372: , ben_ext_person.g_dpnt_prim_region;

Line 369: , ben_ext_person.g_dpnt_prim_postal_code

365: , ben_ext_person.g_dpnt_prim_address2
366: , ben_ext_person.g_dpnt_prim_address3
367: , ben_ext_person.g_dpnt_prim_city
368: , ben_ext_person.g_dpnt_prim_state
369: , ben_ext_person.g_dpnt_prim_postal_code
370: , ben_ext_person.g_dpnt_prim_country
371: , ben_ext_person.g_dpnt_prim_effect_date
372: , ben_ext_person.g_dpnt_prim_region;
373: close prim_rltd_address_c;

Line 370: , ben_ext_person.g_dpnt_prim_country

366: , ben_ext_person.g_dpnt_prim_address3
367: , ben_ext_person.g_dpnt_prim_city
368: , ben_ext_person.g_dpnt_prim_state
369: , ben_ext_person.g_dpnt_prim_postal_code
370: , ben_ext_person.g_dpnt_prim_country
371: , ben_ext_person.g_dpnt_prim_effect_date
372: , ben_ext_person.g_dpnt_prim_region;
373: close prim_rltd_address_c;
374: end if;

Line 371: , ben_ext_person.g_dpnt_prim_effect_date

367: , ben_ext_person.g_dpnt_prim_city
368: , ben_ext_person.g_dpnt_prim_state
369: , ben_ext_person.g_dpnt_prim_postal_code
370: , ben_ext_person.g_dpnt_prim_country
371: , ben_ext_person.g_dpnt_prim_effect_date
372: , ben_ext_person.g_dpnt_prim_region;
373: close prim_rltd_address_c;
374: end if;
375: close prim_address_c;

Line 372: , ben_ext_person.g_dpnt_prim_region;

368: , ben_ext_person.g_dpnt_prim_state
369: , ben_ext_person.g_dpnt_prim_postal_code
370: , ben_ext_person.g_dpnt_prim_country
371: , ben_ext_person.g_dpnt_prim_effect_date
372: , ben_ext_person.g_dpnt_prim_region;
373: close prim_rltd_address_c;
374: end if;
375: close prim_address_c;
376: end if;

Line 381: fetch ext_phone_c into ben_ext_person.g_dpnt_home_phone

377: --
378: -- retrieve dependent phone numbers if required
379: if ben_extract.g_dp_csr = 'Y' then
380: open ext_phone_c(dpnt.dpnt_person_id);
381: fetch ext_phone_c into ben_ext_person.g_dpnt_home_phone
382: ,ben_ext_person.g_dpnt_work_phone
383: ,ben_ext_person.g_dpnt_fax
384: ,ben_ext_person.g_dpnt_mobile;
385: close ext_phone_c;

Line 382: ,ben_ext_person.g_dpnt_work_phone

378: -- retrieve dependent phone numbers if required
379: if ben_extract.g_dp_csr = 'Y' then
380: open ext_phone_c(dpnt.dpnt_person_id);
381: fetch ext_phone_c into ben_ext_person.g_dpnt_home_phone
382: ,ben_ext_person.g_dpnt_work_phone
383: ,ben_ext_person.g_dpnt_fax
384: ,ben_ext_person.g_dpnt_mobile;
385: close ext_phone_c;
386: end if;

Line 383: ,ben_ext_person.g_dpnt_fax

379: if ben_extract.g_dp_csr = 'Y' then
380: open ext_phone_c(dpnt.dpnt_person_id);
381: fetch ext_phone_c into ben_ext_person.g_dpnt_home_phone
382: ,ben_ext_person.g_dpnt_work_phone
383: ,ben_ext_person.g_dpnt_fax
384: ,ben_ext_person.g_dpnt_mobile;
385: close ext_phone_c;
386: end if;
387: --

Line 384: ,ben_ext_person.g_dpnt_mobile;

380: open ext_phone_c(dpnt.dpnt_person_id);
381: fetch ext_phone_c into ben_ext_person.g_dpnt_home_phone
382: ,ben_ext_person.g_dpnt_work_phone
383: ,ben_ext_person.g_dpnt_fax
384: ,ben_ext_person.g_dpnt_mobile;
385: close ext_phone_c;
386: end if;
387: --
388: -- retrieve dependent primary care provider info if required

Line 391: fetch c_dpnt_prmry_care_prvdr into ben_ext_person.g_dpnt_ppr_name

387: --
388: -- retrieve dependent primary care provider info if required
389: if ben_extract.g_dpcp_csr = 'Y' then
390: open c_dpnt_prmry_care_prvdr(dpnt.elig_cvrd_dpnt_id);
391: fetch c_dpnt_prmry_care_prvdr into ben_ext_person.g_dpnt_ppr_name
392: ,ben_ext_person.g_dpnt_ppr_ident
393: ,ben_ext_person.g_dpnt_ppr_typ
394: ,ben_ext_person.g_dpnt_ppr_strt_dt
395: ,ben_ext_person.g_dpnt_ppr_end_dt;

Line 392: ,ben_ext_person.g_dpnt_ppr_ident

388: -- retrieve dependent primary care provider info if required
389: if ben_extract.g_dpcp_csr = 'Y' then
390: open c_dpnt_prmry_care_prvdr(dpnt.elig_cvrd_dpnt_id);
391: fetch c_dpnt_prmry_care_prvdr into ben_ext_person.g_dpnt_ppr_name
392: ,ben_ext_person.g_dpnt_ppr_ident
393: ,ben_ext_person.g_dpnt_ppr_typ
394: ,ben_ext_person.g_dpnt_ppr_strt_dt
395: ,ben_ext_person.g_dpnt_ppr_end_dt;
396: close c_dpnt_prmry_care_prvdr;

Line 393: ,ben_ext_person.g_dpnt_ppr_typ

389: if ben_extract.g_dpcp_csr = 'Y' then
390: open c_dpnt_prmry_care_prvdr(dpnt.elig_cvrd_dpnt_id);
391: fetch c_dpnt_prmry_care_prvdr into ben_ext_person.g_dpnt_ppr_name
392: ,ben_ext_person.g_dpnt_ppr_ident
393: ,ben_ext_person.g_dpnt_ppr_typ
394: ,ben_ext_person.g_dpnt_ppr_strt_dt
395: ,ben_ext_person.g_dpnt_ppr_end_dt;
396: close c_dpnt_prmry_care_prvdr;
397: end if;

Line 394: ,ben_ext_person.g_dpnt_ppr_strt_dt

390: open c_dpnt_prmry_care_prvdr(dpnt.elig_cvrd_dpnt_id);
391: fetch c_dpnt_prmry_care_prvdr into ben_ext_person.g_dpnt_ppr_name
392: ,ben_ext_person.g_dpnt_ppr_ident
393: ,ben_ext_person.g_dpnt_ppr_typ
394: ,ben_ext_person.g_dpnt_ppr_strt_dt
395: ,ben_ext_person.g_dpnt_ppr_end_dt;
396: close c_dpnt_prmry_care_prvdr;
397: end if;
398: --

Line 395: ,ben_ext_person.g_dpnt_ppr_end_dt;

391: fetch c_dpnt_prmry_care_prvdr into ben_ext_person.g_dpnt_ppr_name
392: ,ben_ext_person.g_dpnt_ppr_ident
393: ,ben_ext_person.g_dpnt_ppr_typ
394: ,ben_ext_person.g_dpnt_ppr_strt_dt
395: ,ben_ext_person.g_dpnt_ppr_end_dt;
396: close c_dpnt_prmry_care_prvdr;
397: end if;
398: --
399: -- format and write