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

Line 49: ben_ext_person.g_runrslt_element_name := null;

45: --
46: hr_utility.set_location('Entering'||l_proc, 5);
47: --
48: --
49: ben_ext_person.g_runrslt_element_name := null;
50: ben_ext_person.g_runrslt_element_id := null;
51: ben_ext_person.g_runrslt_reporting_name := null;
52: ben_ext_person.g_runrslt_element_description := null;
53: ben_ext_person.g_runrslt_classification := null;

Line 50: ben_ext_person.g_runrslt_element_id := null;

46: hr_utility.set_location('Entering'||l_proc, 5);
47: --
48: --
49: ben_ext_person.g_runrslt_element_name := null;
50: ben_ext_person.g_runrslt_element_id := null;
51: ben_ext_person.g_runrslt_reporting_name := null;
52: ben_ext_person.g_runrslt_element_description := null;
53: ben_ext_person.g_runrslt_classification := null;
54: ben_ext_person.g_runrslt_classification_id := null;

Line 51: ben_ext_person.g_runrslt_reporting_name := null;

47: --
48: --
49: ben_ext_person.g_runrslt_element_name := null;
50: ben_ext_person.g_runrslt_element_id := null;
51: ben_ext_person.g_runrslt_reporting_name := null;
52: ben_ext_person.g_runrslt_element_description := null;
53: ben_ext_person.g_runrslt_classification := null;
54: ben_ext_person.g_runrslt_classification_id := null;
55: ben_ext_person.g_runrslt_processing_type := null;

Line 52: ben_ext_person.g_runrslt_element_description := null;

48: --
49: ben_ext_person.g_runrslt_element_name := null;
50: ben_ext_person.g_runrslt_element_id := null;
51: ben_ext_person.g_runrslt_reporting_name := null;
52: ben_ext_person.g_runrslt_element_description := null;
53: ben_ext_person.g_runrslt_classification := null;
54: ben_ext_person.g_runrslt_classification_id := null;
55: ben_ext_person.g_runrslt_processing_type := null;
56: ben_ext_person.g_runrslt_input_currency := null;

Line 53: ben_ext_person.g_runrslt_classification := null;

49: ben_ext_person.g_runrslt_element_name := null;
50: ben_ext_person.g_runrslt_element_id := null;
51: ben_ext_person.g_runrslt_reporting_name := null;
52: ben_ext_person.g_runrslt_element_description := null;
53: ben_ext_person.g_runrslt_classification := null;
54: ben_ext_person.g_runrslt_classification_id := null;
55: ben_ext_person.g_runrslt_processing_type := null;
56: ben_ext_person.g_runrslt_input_currency := null;
57: ben_ext_person.g_runrslt_output_currency := null;

Line 54: ben_ext_person.g_runrslt_classification_id := null;

50: ben_ext_person.g_runrslt_element_id := null;
51: ben_ext_person.g_runrslt_reporting_name := null;
52: ben_ext_person.g_runrslt_element_description := null;
53: ben_ext_person.g_runrslt_classification := null;
54: ben_ext_person.g_runrslt_classification_id := null;
55: ben_ext_person.g_runrslt_processing_type := null;
56: ben_ext_person.g_runrslt_input_currency := null;
57: ben_ext_person.g_runrslt_output_currency := null;
58: ben_ext_person.g_runrslt_skip_rule := null;

Line 55: ben_ext_person.g_runrslt_processing_type := null;

51: ben_ext_person.g_runrslt_reporting_name := null;
52: ben_ext_person.g_runrslt_element_description := null;
53: ben_ext_person.g_runrslt_classification := null;
54: ben_ext_person.g_runrslt_classification_id := null;
55: ben_ext_person.g_runrslt_processing_type := null;
56: ben_ext_person.g_runrslt_input_currency := null;
57: ben_ext_person.g_runrslt_output_currency := null;
58: ben_ext_person.g_runrslt_skip_rule := null;
59: ben_ext_person.g_runrslt_skip_rule_id := null;

Line 56: ben_ext_person.g_runrslt_input_currency := null;

52: ben_ext_person.g_runrslt_element_description := null;
53: ben_ext_person.g_runrslt_classification := null;
54: ben_ext_person.g_runrslt_classification_id := null;
55: ben_ext_person.g_runrslt_processing_type := null;
56: ben_ext_person.g_runrslt_input_currency := null;
57: ben_ext_person.g_runrslt_output_currency := null;
58: ben_ext_person.g_runrslt_skip_rule := null;
59: ben_ext_person.g_runrslt_skip_rule_id := null;
60: ben_ext_person.g_runrslt_input_value_name := null;

Line 57: ben_ext_person.g_runrslt_output_currency := null;

53: ben_ext_person.g_runrslt_classification := null;
54: ben_ext_person.g_runrslt_classification_id := null;
55: ben_ext_person.g_runrslt_processing_type := null;
56: ben_ext_person.g_runrslt_input_currency := null;
57: ben_ext_person.g_runrslt_output_currency := null;
58: ben_ext_person.g_runrslt_skip_rule := null;
59: ben_ext_person.g_runrslt_skip_rule_id := null;
60: ben_ext_person.g_runrslt_input_value_name := null;
61: ben_ext_person.g_runrslt_input_value_id := null;

Line 58: ben_ext_person.g_runrslt_skip_rule := null;

54: ben_ext_person.g_runrslt_classification_id := null;
55: ben_ext_person.g_runrslt_processing_type := null;
56: ben_ext_person.g_runrslt_input_currency := null;
57: ben_ext_person.g_runrslt_output_currency := null;
58: ben_ext_person.g_runrslt_skip_rule := null;
59: ben_ext_person.g_runrslt_skip_rule_id := null;
60: ben_ext_person.g_runrslt_input_value_name := null;
61: ben_ext_person.g_runrslt_input_value_id := null;
62: ben_ext_person.g_runrslt_input_value_units := null;

Line 59: ben_ext_person.g_runrslt_skip_rule_id := null;

55: ben_ext_person.g_runrslt_processing_type := null;
56: ben_ext_person.g_runrslt_input_currency := null;
57: ben_ext_person.g_runrslt_output_currency := null;
58: ben_ext_person.g_runrslt_skip_rule := null;
59: ben_ext_person.g_runrslt_skip_rule_id := null;
60: ben_ext_person.g_runrslt_input_value_name := null;
61: ben_ext_person.g_runrslt_input_value_id := null;
62: ben_ext_person.g_runrslt_input_value_units := null;
63: ben_ext_person.g_runrslt_input_value_sequence := null;

Line 60: ben_ext_person.g_runrslt_input_value_name := null;

56: ben_ext_person.g_runrslt_input_currency := null;
57: ben_ext_person.g_runrslt_output_currency := null;
58: ben_ext_person.g_runrslt_skip_rule := null;
59: ben_ext_person.g_runrslt_skip_rule_id := null;
60: ben_ext_person.g_runrslt_input_value_name := null;
61: ben_ext_person.g_runrslt_input_value_id := null;
62: ben_ext_person.g_runrslt_input_value_units := null;
63: ben_ext_person.g_runrslt_input_value_sequence := null;
64: ben_ext_person.g_runrslt_identifier := null;

Line 61: ben_ext_person.g_runrslt_input_value_id := null;

57: ben_ext_person.g_runrslt_output_currency := null;
58: ben_ext_person.g_runrslt_skip_rule := null;
59: ben_ext_person.g_runrslt_skip_rule_id := null;
60: ben_ext_person.g_runrslt_input_value_name := null;
61: ben_ext_person.g_runrslt_input_value_id := null;
62: ben_ext_person.g_runrslt_input_value_units := null;
63: ben_ext_person.g_runrslt_input_value_sequence := null;
64: ben_ext_person.g_runrslt_identifier := null;
65: ben_ext_person.g_runrslt_jurisdiction_code := null;

Line 62: ben_ext_person.g_runrslt_input_value_units := null;

58: ben_ext_person.g_runrslt_skip_rule := null;
59: ben_ext_person.g_runrslt_skip_rule_id := null;
60: ben_ext_person.g_runrslt_input_value_name := null;
61: ben_ext_person.g_runrslt_input_value_id := null;
62: ben_ext_person.g_runrslt_input_value_units := null;
63: ben_ext_person.g_runrslt_input_value_sequence := null;
64: ben_ext_person.g_runrslt_identifier := null;
65: ben_ext_person.g_runrslt_jurisdiction_code := null;
66: ben_ext_person.g_runrslt_status := null;

Line 63: ben_ext_person.g_runrslt_input_value_sequence := null;

59: ben_ext_person.g_runrslt_skip_rule_id := null;
60: ben_ext_person.g_runrslt_input_value_name := null;
61: ben_ext_person.g_runrslt_input_value_id := null;
62: ben_ext_person.g_runrslt_input_value_units := null;
63: ben_ext_person.g_runrslt_input_value_sequence := null;
64: ben_ext_person.g_runrslt_identifier := null;
65: ben_ext_person.g_runrslt_jurisdiction_code := null;
66: ben_ext_person.g_runrslt_status := null;
67: ben_ext_person.g_runrslt_source_type := null;

Line 64: ben_ext_person.g_runrslt_identifier := null;

60: ben_ext_person.g_runrslt_input_value_name := null;
61: ben_ext_person.g_runrslt_input_value_id := null;
62: ben_ext_person.g_runrslt_input_value_units := null;
63: ben_ext_person.g_runrslt_input_value_sequence := null;
64: ben_ext_person.g_runrslt_identifier := null;
65: ben_ext_person.g_runrslt_jurisdiction_code := null;
66: ben_ext_person.g_runrslt_status := null;
67: ben_ext_person.g_runrslt_source_type := null;
68: ben_ext_person.g_runrslt_entry_type := null;

Line 65: ben_ext_person.g_runrslt_jurisdiction_code := null;

61: ben_ext_person.g_runrslt_input_value_id := null;
62: ben_ext_person.g_runrslt_input_value_units := null;
63: ben_ext_person.g_runrslt_input_value_sequence := null;
64: ben_ext_person.g_runrslt_identifier := null;
65: ben_ext_person.g_runrslt_jurisdiction_code := null;
66: ben_ext_person.g_runrslt_status := null;
67: ben_ext_person.g_runrslt_source_type := null;
68: ben_ext_person.g_runrslt_entry_type := null;
69: ben_ext_person.g_runrslt_value := null;

Line 66: ben_ext_person.g_runrslt_status := null;

62: ben_ext_person.g_runrslt_input_value_units := null;
63: ben_ext_person.g_runrslt_input_value_sequence := null;
64: ben_ext_person.g_runrslt_identifier := null;
65: ben_ext_person.g_runrslt_jurisdiction_code := null;
66: ben_ext_person.g_runrslt_status := null;
67: ben_ext_person.g_runrslt_source_type := null;
68: ben_ext_person.g_runrslt_entry_type := null;
69: ben_ext_person.g_runrslt_value := null;
70: ben_ext_person.g_runrslt_last_pay_date := null;

Line 67: ben_ext_person.g_runrslt_source_type := null;

63: ben_ext_person.g_runrslt_input_value_sequence := null;
64: ben_ext_person.g_runrslt_identifier := null;
65: ben_ext_person.g_runrslt_jurisdiction_code := null;
66: ben_ext_person.g_runrslt_status := null;
67: ben_ext_person.g_runrslt_source_type := null;
68: ben_ext_person.g_runrslt_entry_type := null;
69: ben_ext_person.g_runrslt_value := null;
70: ben_ext_person.g_runrslt_last_pay_date := null;
71: --

Line 68: ben_ext_person.g_runrslt_entry_type := null;

64: ben_ext_person.g_runrslt_identifier := null;
65: ben_ext_person.g_runrslt_jurisdiction_code := null;
66: ben_ext_person.g_runrslt_status := null;
67: ben_ext_person.g_runrslt_source_type := null;
68: ben_ext_person.g_runrslt_entry_type := null;
69: ben_ext_person.g_runrslt_value := null;
70: ben_ext_person.g_runrslt_last_pay_date := null;
71: --
72: --

Line 69: ben_ext_person.g_runrslt_value := null;

65: ben_ext_person.g_runrslt_jurisdiction_code := null;
66: ben_ext_person.g_runrslt_status := null;
67: ben_ext_person.g_runrslt_source_type := null;
68: ben_ext_person.g_runrslt_entry_type := null;
69: ben_ext_person.g_runrslt_value := null;
70: ben_ext_person.g_runrslt_last_pay_date := null;
71: --
72: --
73: hr_utility.set_location('Exiting'||l_proc, 15);

Line 70: ben_ext_person.g_runrslt_last_pay_date := null;

66: ben_ext_person.g_runrslt_status := null;
67: ben_ext_person.g_runrslt_source_type := null;
68: ben_ext_person.g_runrslt_entry_type := null;
69: ben_ext_person.g_runrslt_value := null;
70: ben_ext_person.g_runrslt_last_pay_date := null;
71: --
72: --
73: hr_utility.set_location('Exiting'||l_proc, 15);
74: --

Line 140: --and asg.assignment_id = ben_ext_person.g_assignment_id --1969853

136: pay_run_result_values rv,
137: pay_payroll_actions ppa
138: where
139: asg.person_id = p_person_id
140: --and asg.assignment_id = ben_ext_person.g_assignment_id --1969853
141: and asg.assignment_id = aac.assignment_id
142: and aac.assignment_action_id = rr.assignment_action_id
143: and iv.input_value_id = nvl(ben_ext_person.g_chg_input_value_id,iv.input_value_id)
144: and iv.element_type_id = et.element_type_id

Line 143: and iv.input_value_id = nvl(ben_ext_person.g_chg_input_value_id,iv.input_value_id)

139: asg.person_id = p_person_id
140: --and asg.assignment_id = ben_ext_person.g_assignment_id --1969853
141: and asg.assignment_id = aac.assignment_id
142: and aac.assignment_action_id = rr.assignment_action_id
143: and iv.input_value_id = nvl(ben_ext_person.g_chg_input_value_id,iv.input_value_id)
144: and iv.element_type_id = et.element_type_id
145: and aac.payroll_action_id = ppa.payroll_action_id
146: and rr.element_type_id = et.element_type_id
147: and rr.run_result_id = rv.run_result_id

Line 169: --and asg.assignment_id = ben_ext_person.g_assignment_id --1969853

165: from per_all_assignments_f asg,
166: pay_assignment_actions aac,
167: pay_payroll_actions ppa
168: where asg.person_id = p_person_id
169: --and asg.assignment_id = ben_ext_person.g_assignment_id --1969853
170: and asg.assignment_id = aac.assignment_id
171: and aac.payroll_action_id = ppa.payroll_action_id
172: and p_effective_date between asg.effective_start_date and asg.effective_end_date
173: and (p_start_date is null or (ppa.effective_date between

Line 195: and (ben_ext_person.g_chg_input_value_id is null

191: pay_input_values_f iv,
192: pay_run_result_values rv
193: where rr.assignment_action_id = c_assignment_action_id
194: and rr.element_type_id = iv.element_type_id
195: and (ben_ext_person.g_chg_input_value_id is null
196: or (iv.input_value_id = ben_ext_person.g_chg_input_value_id))
197: and rr.run_result_id = rv.run_result_id
198: and rv.input_value_id = iv.input_value_id
199: and rv.result_value is not null

Line 196: or (iv.input_value_id = ben_ext_person.g_chg_input_value_id))

192: pay_run_result_values rv
193: where rr.assignment_action_id = c_assignment_action_id
194: and rr.element_type_id = iv.element_type_id
195: and (ben_ext_person.g_chg_input_value_id is null
196: or (iv.input_value_id = ben_ext_person.g_chg_input_value_id))
197: and rr.run_result_id = rv.run_result_id
198: and rv.input_value_id = iv.input_value_id
199: and rv.result_value is not null
200: and p_effective_date between iv.effective_start_date

Line 225: and (ben_ext_person.g_chg_input_value_id is null

221: pay_input_values_f iv,
222: pay_run_result_values rv
223: where rr.assignment_action_id = c_assignment_action_id
224: and rr.element_type_id = iv.element_type_id
225: and (ben_ext_person.g_chg_input_value_id is null
226: or (iv.input_value_id = ben_ext_person.g_chg_input_value_id))
227: and iv.input_value_id = c_input_value_id
228: and iv.element_type_id = c_element_type_id
229: and rr.run_result_id = rv.run_result_id

Line 226: or (iv.input_value_id = ben_ext_person.g_chg_input_value_id))

222: pay_run_result_values rv
223: where rr.assignment_action_id = c_assignment_action_id
224: and rr.element_type_id = iv.element_type_id
225: and (ben_ext_person.g_chg_input_value_id is null
226: or (iv.input_value_id = ben_ext_person.g_chg_input_value_id))
227: and iv.input_value_id = c_input_value_id
228: and iv.element_type_id = c_element_type_id
229: and rr.run_result_id = rv.run_result_id
230: and rv.input_value_id = iv.input_value_id

Line 297: ben_ext_person.g_runrslt_element_name := runrslt.element_name;

293: IF l_include = 'Y' THEN
294: --
295: -- assign run result elemts info to global variables
296: --
297: ben_ext_person.g_runrslt_element_name := runrslt.element_name;
298: ben_ext_person.g_runrslt_element_id := runrslt.element_id;
299: ben_ext_person.g_runrslt_reporting_name := runrslt.reporting_name;
300: ben_ext_person.g_runrslt_element_description := runrslt.description;
301: ben_ext_person.g_runrslt_classification := runrslt.class_name;

Line 298: ben_ext_person.g_runrslt_element_id := runrslt.element_id;

294: --
295: -- assign run result elemts info to global variables
296: --
297: ben_ext_person.g_runrslt_element_name := runrslt.element_name;
298: ben_ext_person.g_runrslt_element_id := runrslt.element_id;
299: ben_ext_person.g_runrslt_reporting_name := runrslt.reporting_name;
300: ben_ext_person.g_runrslt_element_description := runrslt.description;
301: ben_ext_person.g_runrslt_classification := runrslt.class_name;
302: ben_ext_person.g_runrslt_classification_id := runrslt.class_id;

Line 299: ben_ext_person.g_runrslt_reporting_name := runrslt.reporting_name;

295: -- assign run result elemts info to global variables
296: --
297: ben_ext_person.g_runrslt_element_name := runrslt.element_name;
298: ben_ext_person.g_runrslt_element_id := runrslt.element_id;
299: ben_ext_person.g_runrslt_reporting_name := runrslt.reporting_name;
300: ben_ext_person.g_runrslt_element_description := runrslt.description;
301: ben_ext_person.g_runrslt_classification := runrslt.class_name;
302: ben_ext_person.g_runrslt_classification_id := runrslt.class_id;
303: ben_ext_person.g_runrslt_processing_type := runrslt.process_type;

Line 300: ben_ext_person.g_runrslt_element_description := runrslt.description;

296: --
297: ben_ext_person.g_runrslt_element_name := runrslt.element_name;
298: ben_ext_person.g_runrslt_element_id := runrslt.element_id;
299: ben_ext_person.g_runrslt_reporting_name := runrslt.reporting_name;
300: ben_ext_person.g_runrslt_element_description := runrslt.description;
301: ben_ext_person.g_runrslt_classification := runrslt.class_name;
302: ben_ext_person.g_runrslt_classification_id := runrslt.class_id;
303: ben_ext_person.g_runrslt_processing_type := runrslt.process_type;
304: ben_ext_person.g_runrslt_input_currency := runrslt.input_currency;

Line 301: ben_ext_person.g_runrslt_classification := runrslt.class_name;

297: ben_ext_person.g_runrslt_element_name := runrslt.element_name;
298: ben_ext_person.g_runrslt_element_id := runrslt.element_id;
299: ben_ext_person.g_runrslt_reporting_name := runrslt.reporting_name;
300: ben_ext_person.g_runrslt_element_description := runrslt.description;
301: ben_ext_person.g_runrslt_classification := runrslt.class_name;
302: ben_ext_person.g_runrslt_classification_id := runrslt.class_id;
303: ben_ext_person.g_runrslt_processing_type := runrslt.process_type;
304: ben_ext_person.g_runrslt_input_currency := runrslt.input_currency;
305: ben_ext_person.g_runrslt_output_currency := runrslt.output_currency;

Line 302: ben_ext_person.g_runrslt_classification_id := runrslt.class_id;

298: ben_ext_person.g_runrslt_element_id := runrslt.element_id;
299: ben_ext_person.g_runrslt_reporting_name := runrslt.reporting_name;
300: ben_ext_person.g_runrslt_element_description := runrslt.description;
301: ben_ext_person.g_runrslt_classification := runrslt.class_name;
302: ben_ext_person.g_runrslt_classification_id := runrslt.class_id;
303: ben_ext_person.g_runrslt_processing_type := runrslt.process_type;
304: ben_ext_person.g_runrslt_input_currency := runrslt.input_currency;
305: ben_ext_person.g_runrslt_output_currency := runrslt.output_currency;
306: ben_ext_person.g_runrslt_skip_rule := runrslt.skip_rule_name;

Line 303: ben_ext_person.g_runrslt_processing_type := runrslt.process_type;

299: ben_ext_person.g_runrslt_reporting_name := runrslt.reporting_name;
300: ben_ext_person.g_runrslt_element_description := runrslt.description;
301: ben_ext_person.g_runrslt_classification := runrslt.class_name;
302: ben_ext_person.g_runrslt_classification_id := runrslt.class_id;
303: ben_ext_person.g_runrslt_processing_type := runrslt.process_type;
304: ben_ext_person.g_runrslt_input_currency := runrslt.input_currency;
305: ben_ext_person.g_runrslt_output_currency := runrslt.output_currency;
306: ben_ext_person.g_runrslt_skip_rule := runrslt.skip_rule_name;
307: ben_ext_person.g_runrslt_skip_rule_id := runrslt.skip_rule_id;

Line 304: ben_ext_person.g_runrslt_input_currency := runrslt.input_currency;

300: ben_ext_person.g_runrslt_element_description := runrslt.description;
301: ben_ext_person.g_runrslt_classification := runrslt.class_name;
302: ben_ext_person.g_runrslt_classification_id := runrslt.class_id;
303: ben_ext_person.g_runrslt_processing_type := runrslt.process_type;
304: ben_ext_person.g_runrslt_input_currency := runrslt.input_currency;
305: ben_ext_person.g_runrslt_output_currency := runrslt.output_currency;
306: ben_ext_person.g_runrslt_skip_rule := runrslt.skip_rule_name;
307: ben_ext_person.g_runrslt_skip_rule_id := runrslt.skip_rule_id;
308: ben_ext_person.g_runrslt_input_value_name := runrslt.value_name;

Line 305: ben_ext_person.g_runrslt_output_currency := runrslt.output_currency;

301: ben_ext_person.g_runrslt_classification := runrslt.class_name;
302: ben_ext_person.g_runrslt_classification_id := runrslt.class_id;
303: ben_ext_person.g_runrslt_processing_type := runrslt.process_type;
304: ben_ext_person.g_runrslt_input_currency := runrslt.input_currency;
305: ben_ext_person.g_runrslt_output_currency := runrslt.output_currency;
306: ben_ext_person.g_runrslt_skip_rule := runrslt.skip_rule_name;
307: ben_ext_person.g_runrslt_skip_rule_id := runrslt.skip_rule_id;
308: ben_ext_person.g_runrslt_input_value_name := runrslt.value_name;
309: ben_ext_person.g_runrslt_input_value_id := runrslt.value_id;

Line 306: ben_ext_person.g_runrslt_skip_rule := runrslt.skip_rule_name;

302: ben_ext_person.g_runrslt_classification_id := runrslt.class_id;
303: ben_ext_person.g_runrslt_processing_type := runrslt.process_type;
304: ben_ext_person.g_runrslt_input_currency := runrslt.input_currency;
305: ben_ext_person.g_runrslt_output_currency := runrslt.output_currency;
306: ben_ext_person.g_runrslt_skip_rule := runrslt.skip_rule_name;
307: ben_ext_person.g_runrslt_skip_rule_id := runrslt.skip_rule_id;
308: ben_ext_person.g_runrslt_input_value_name := runrslt.value_name;
309: ben_ext_person.g_runrslt_input_value_id := runrslt.value_id;
310: ben_ext_person.g_runrslt_input_value_units := runrslt.value_unit;

Line 307: ben_ext_person.g_runrslt_skip_rule_id := runrslt.skip_rule_id;

303: ben_ext_person.g_runrslt_processing_type := runrslt.process_type;
304: ben_ext_person.g_runrslt_input_currency := runrslt.input_currency;
305: ben_ext_person.g_runrslt_output_currency := runrslt.output_currency;
306: ben_ext_person.g_runrslt_skip_rule := runrslt.skip_rule_name;
307: ben_ext_person.g_runrslt_skip_rule_id := runrslt.skip_rule_id;
308: ben_ext_person.g_runrslt_input_value_name := runrslt.value_name;
309: ben_ext_person.g_runrslt_input_value_id := runrslt.value_id;
310: ben_ext_person.g_runrslt_input_value_units := runrslt.value_unit;
311: ben_ext_person.g_runrslt_input_value_sequence := runrslt.value_seq;

Line 308: ben_ext_person.g_runrslt_input_value_name := runrslt.value_name;

304: ben_ext_person.g_runrslt_input_currency := runrslt.input_currency;
305: ben_ext_person.g_runrslt_output_currency := runrslt.output_currency;
306: ben_ext_person.g_runrslt_skip_rule := runrslt.skip_rule_name;
307: ben_ext_person.g_runrslt_skip_rule_id := runrslt.skip_rule_id;
308: ben_ext_person.g_runrslt_input_value_name := runrslt.value_name;
309: ben_ext_person.g_runrslt_input_value_id := runrslt.value_id;
310: ben_ext_person.g_runrslt_input_value_units := runrslt.value_unit;
311: ben_ext_person.g_runrslt_input_value_sequence := runrslt.value_seq;
312: ben_ext_person.g_runrslt_identifier := runrslt.result_id;

Line 309: ben_ext_person.g_runrslt_input_value_id := runrslt.value_id;

305: ben_ext_person.g_runrslt_output_currency := runrslt.output_currency;
306: ben_ext_person.g_runrslt_skip_rule := runrslt.skip_rule_name;
307: ben_ext_person.g_runrslt_skip_rule_id := runrslt.skip_rule_id;
308: ben_ext_person.g_runrslt_input_value_name := runrslt.value_name;
309: ben_ext_person.g_runrslt_input_value_id := runrslt.value_id;
310: ben_ext_person.g_runrslt_input_value_units := runrslt.value_unit;
311: ben_ext_person.g_runrslt_input_value_sequence := runrslt.value_seq;
312: ben_ext_person.g_runrslt_identifier := runrslt.result_id;
313: ben_ext_person.g_runrslt_jurisdiction_code := runrslt.juris_code;

Line 310: ben_ext_person.g_runrslt_input_value_units := runrslt.value_unit;

306: ben_ext_person.g_runrslt_skip_rule := runrslt.skip_rule_name;
307: ben_ext_person.g_runrslt_skip_rule_id := runrslt.skip_rule_id;
308: ben_ext_person.g_runrslt_input_value_name := runrslt.value_name;
309: ben_ext_person.g_runrslt_input_value_id := runrslt.value_id;
310: ben_ext_person.g_runrslt_input_value_units := runrslt.value_unit;
311: ben_ext_person.g_runrslt_input_value_sequence := runrslt.value_seq;
312: ben_ext_person.g_runrslt_identifier := runrslt.result_id;
313: ben_ext_person.g_runrslt_jurisdiction_code := runrslt.juris_code;
314: ben_ext_person.g_runrslt_status := runrslt.status;

Line 311: ben_ext_person.g_runrslt_input_value_sequence := runrslt.value_seq;

307: ben_ext_person.g_runrslt_skip_rule_id := runrslt.skip_rule_id;
308: ben_ext_person.g_runrslt_input_value_name := runrslt.value_name;
309: ben_ext_person.g_runrslt_input_value_id := runrslt.value_id;
310: ben_ext_person.g_runrslt_input_value_units := runrslt.value_unit;
311: ben_ext_person.g_runrslt_input_value_sequence := runrslt.value_seq;
312: ben_ext_person.g_runrslt_identifier := runrslt.result_id;
313: ben_ext_person.g_runrslt_jurisdiction_code := runrslt.juris_code;
314: ben_ext_person.g_runrslt_status := runrslt.status;
315: ben_ext_person.g_runrslt_source_type := runrslt.source_type;

Line 312: ben_ext_person.g_runrslt_identifier := runrslt.result_id;

308: ben_ext_person.g_runrslt_input_value_name := runrslt.value_name;
309: ben_ext_person.g_runrslt_input_value_id := runrslt.value_id;
310: ben_ext_person.g_runrslt_input_value_units := runrslt.value_unit;
311: ben_ext_person.g_runrslt_input_value_sequence := runrslt.value_seq;
312: ben_ext_person.g_runrslt_identifier := runrslt.result_id;
313: ben_ext_person.g_runrslt_jurisdiction_code := runrslt.juris_code;
314: ben_ext_person.g_runrslt_status := runrslt.status;
315: ben_ext_person.g_runrslt_source_type := runrslt.source_type;
316: ben_ext_person.g_runrslt_entry_type := runrslt.entry_type;

Line 313: ben_ext_person.g_runrslt_jurisdiction_code := runrslt.juris_code;

309: ben_ext_person.g_runrslt_input_value_id := runrslt.value_id;
310: ben_ext_person.g_runrslt_input_value_units := runrslt.value_unit;
311: ben_ext_person.g_runrslt_input_value_sequence := runrslt.value_seq;
312: ben_ext_person.g_runrslt_identifier := runrslt.result_id;
313: ben_ext_person.g_runrslt_jurisdiction_code := runrslt.juris_code;
314: ben_ext_person.g_runrslt_status := runrslt.status;
315: ben_ext_person.g_runrslt_source_type := runrslt.source_type;
316: ben_ext_person.g_runrslt_entry_type := runrslt.entry_type;
317: ben_ext_person.g_runrslt_value := runrslt.result_value;

Line 314: ben_ext_person.g_runrslt_status := runrslt.status;

310: ben_ext_person.g_runrslt_input_value_units := runrslt.value_unit;
311: ben_ext_person.g_runrslt_input_value_sequence := runrslt.value_seq;
312: ben_ext_person.g_runrslt_identifier := runrslt.result_id;
313: ben_ext_person.g_runrslt_jurisdiction_code := runrslt.juris_code;
314: ben_ext_person.g_runrslt_status := runrslt.status;
315: ben_ext_person.g_runrslt_source_type := runrslt.source_type;
316: ben_ext_person.g_runrslt_entry_type := runrslt.entry_type;
317: ben_ext_person.g_runrslt_value := runrslt.result_value;
318: ben_ext_person.g_runrslt_last_pay_date := runrslt.effective_date;

Line 315: ben_ext_person.g_runrslt_source_type := runrslt.source_type;

311: ben_ext_person.g_runrslt_input_value_sequence := runrslt.value_seq;
312: ben_ext_person.g_runrslt_identifier := runrslt.result_id;
313: ben_ext_person.g_runrslt_jurisdiction_code := runrslt.juris_code;
314: ben_ext_person.g_runrslt_status := runrslt.status;
315: ben_ext_person.g_runrslt_source_type := runrslt.source_type;
316: ben_ext_person.g_runrslt_entry_type := runrslt.entry_type;
317: ben_ext_person.g_runrslt_value := runrslt.result_value;
318: ben_ext_person.g_runrslt_last_pay_date := runrslt.effective_date;
319:

Line 316: ben_ext_person.g_runrslt_entry_type := runrslt.entry_type;

312: ben_ext_person.g_runrslt_identifier := runrslt.result_id;
313: ben_ext_person.g_runrslt_jurisdiction_code := runrslt.juris_code;
314: ben_ext_person.g_runrslt_status := runrslt.status;
315: ben_ext_person.g_runrslt_source_type := runrslt.source_type;
316: ben_ext_person.g_runrslt_entry_type := runrslt.entry_type;
317: ben_ext_person.g_runrslt_value := runrslt.result_value;
318: ben_ext_person.g_runrslt_last_pay_date := runrslt.effective_date;
319:
320: --

Line 317: ben_ext_person.g_runrslt_value := runrslt.result_value;

313: ben_ext_person.g_runrslt_jurisdiction_code := runrslt.juris_code;
314: ben_ext_person.g_runrslt_status := runrslt.status;
315: ben_ext_person.g_runrslt_source_type := runrslt.source_type;
316: ben_ext_person.g_runrslt_entry_type := runrslt.entry_type;
317: ben_ext_person.g_runrslt_value := runrslt.result_value;
318: ben_ext_person.g_runrslt_last_pay_date := runrslt.effective_date;
319:
320: --
321: -- format and write

Line 318: ben_ext_person.g_runrslt_last_pay_date := runrslt.effective_date;

314: ben_ext_person.g_runrslt_status := runrslt.status;
315: ben_ext_person.g_runrslt_source_type := runrslt.source_type;
316: ben_ext_person.g_runrslt_entry_type := runrslt.entry_type;
317: ben_ext_person.g_runrslt_value := runrslt.result_value;
318: ben_ext_person.g_runrslt_last_pay_date := runrslt.effective_date;
319:
320: --
321: -- format and write
322: --

Line 342: for r_asg in c_asg(ben_ext_person.g_pay_last_start_date

338: --
339: else
340: initialize_globals;
341: ---intialise after writing rec
342: for r_asg in c_asg(ben_ext_person.g_pay_last_start_date
343: ,ben_ext_person.g_pay_last_end_date )
344: loop
345:
346: --- the loop will be bracned in to two

Line 343: ,ben_ext_person.g_pay_last_end_date )

339: else
340: initialize_globals;
341: ---intialise after writing rec
342: for r_asg in c_asg(ben_ext_person.g_pay_last_start_date
343: ,ben_ext_person.g_pay_last_end_date )
344: loop
345:
346: --- the loop will be bracned in to two
347: --- 1 with the input_valu_id from criteria

Line 383: ben_ext_person.g_runrslt_last_pay_date := r_asg.effective_date;

379: end if ;
380:
381: IF l_include = 'Y' THEN
382:
383: ben_ext_person.g_runrslt_last_pay_date := r_asg.effective_date;
384: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;
385: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
386: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
387: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;

Line 384: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;

380:
381: IF l_include = 'Y' THEN
382:
383: ben_ext_person.g_runrslt_last_pay_date := r_asg.effective_date;
384: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;
385: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
386: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
387: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
388: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; --Bug 2669594

Line 385: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;

381: IF l_include = 'Y' THEN
382:
383: ben_ext_person.g_runrslt_last_pay_date := r_asg.effective_date;
384: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;
385: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
386: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
387: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
388: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; --Bug 2669594
389: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;

Line 386: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;

382:
383: ben_ext_person.g_runrslt_last_pay_date := r_asg.effective_date;
384: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;
385: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
386: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
387: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
388: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; --Bug 2669594
389: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
390: ben_ext_person.g_runrslt_status := r_rslt.status;

Line 387: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;

383: ben_ext_person.g_runrslt_last_pay_date := r_asg.effective_date;
384: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;
385: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
386: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
387: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
388: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; --Bug 2669594
389: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
390: ben_ext_person.g_runrslt_status := r_rslt.status;
391: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;

Line 388: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; --Bug 2669594

384: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;
385: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
386: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
387: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
388: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; --Bug 2669594
389: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
390: ben_ext_person.g_runrslt_status := r_rslt.status;
391: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
392: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;

Line 389: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;

385: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
386: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
387: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
388: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; --Bug 2669594
389: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
390: ben_ext_person.g_runrslt_status := r_rslt.status;
391: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
392: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
393: ben_ext_person.g_runrslt_value := r_rslt.result_value;

Line 390: ben_ext_person.g_runrslt_status := r_rslt.status;

386: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
387: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
388: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; --Bug 2669594
389: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
390: ben_ext_person.g_runrslt_status := r_rslt.status;
391: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
392: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
393: ben_ext_person.g_runrslt_value := r_rslt.result_value;
394: ben_ext_person.g_runrslt_element_name := r_ele.element_name;

Line 391: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;

387: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
388: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; --Bug 2669594
389: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
390: ben_ext_person.g_runrslt_status := r_rslt.status;
391: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
392: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
393: ben_ext_person.g_runrslt_value := r_rslt.result_value;
394: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
395: ben_ext_person.g_runrslt_element_id := r_ele.element_id;

Line 392: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;

388: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; --Bug 2669594
389: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
390: ben_ext_person.g_runrslt_status := r_rslt.status;
391: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
392: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
393: ben_ext_person.g_runrslt_value := r_rslt.result_value;
394: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
395: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
396: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;

Line 393: ben_ext_person.g_runrslt_value := r_rslt.result_value;

389: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
390: ben_ext_person.g_runrslt_status := r_rslt.status;
391: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
392: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
393: ben_ext_person.g_runrslt_value := r_rslt.result_value;
394: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
395: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
396: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
397: ben_ext_person.g_runrslt_element_description := r_ele.description;

Line 394: ben_ext_person.g_runrslt_element_name := r_ele.element_name;

390: ben_ext_person.g_runrslt_status := r_rslt.status;
391: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
392: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
393: ben_ext_person.g_runrslt_value := r_rslt.result_value;
394: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
395: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
396: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
397: ben_ext_person.g_runrslt_element_description := r_ele.description;
398: ben_ext_person.g_runrslt_classification := r_ele.class_name;

Line 395: ben_ext_person.g_runrslt_element_id := r_ele.element_id;

391: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
392: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
393: ben_ext_person.g_runrslt_value := r_rslt.result_value;
394: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
395: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
396: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
397: ben_ext_person.g_runrslt_element_description := r_ele.description;
398: ben_ext_person.g_runrslt_classification := r_ele.class_name;
399: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;

Line 396: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;

392: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
393: ben_ext_person.g_runrslt_value := r_rslt.result_value;
394: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
395: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
396: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
397: ben_ext_person.g_runrslt_element_description := r_ele.description;
398: ben_ext_person.g_runrslt_classification := r_ele.class_name;
399: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
400: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;

Line 397: ben_ext_person.g_runrslt_element_description := r_ele.description;

393: ben_ext_person.g_runrslt_value := r_rslt.result_value;
394: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
395: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
396: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
397: ben_ext_person.g_runrslt_element_description := r_ele.description;
398: ben_ext_person.g_runrslt_classification := r_ele.class_name;
399: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
400: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
401: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;

Line 398: ben_ext_person.g_runrslt_classification := r_ele.class_name;

394: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
395: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
396: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
397: ben_ext_person.g_runrslt_element_description := r_ele.description;
398: ben_ext_person.g_runrslt_classification := r_ele.class_name;
399: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
400: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
401: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;
402: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;

Line 399: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;

395: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
396: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
397: ben_ext_person.g_runrslt_element_description := r_ele.description;
398: ben_ext_person.g_runrslt_classification := r_ele.class_name;
399: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
400: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
401: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;
402: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;
403: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;

Line 400: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;

396: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
397: ben_ext_person.g_runrslt_element_description := r_ele.description;
398: ben_ext_person.g_runrslt_classification := r_ele.class_name;
399: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
400: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
401: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;
402: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;
403: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;
404: if r_ele.skip_rule_id is not null then

Line 401: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;

397: ben_ext_person.g_runrslt_element_description := r_ele.description;
398: ben_ext_person.g_runrslt_classification := r_ele.class_name;
399: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
400: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
401: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;
402: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;
403: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;
404: if r_ele.skip_rule_id is not null then
405: open c_ff (r_ele.skip_rule_id ) ;

Line 402: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;

398: ben_ext_person.g_runrslt_classification := r_ele.class_name;
399: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
400: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
401: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;
402: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;
403: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;
404: if r_ele.skip_rule_id is not null then
405: open c_ff (r_ele.skip_rule_id ) ;
406: fetch c_ff into ben_ext_person.g_runrslt_skip_rule ;

Line 403: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;

399: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
400: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
401: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;
402: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;
403: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;
404: if r_ele.skip_rule_id is not null then
405: open c_ff (r_ele.skip_rule_id ) ;
406: fetch c_ff into ben_ext_person.g_runrslt_skip_rule ;
407: if c_ff%notfound then

Line 406: fetch c_ff into ben_ext_person.g_runrslt_skip_rule ;

402: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;
403: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;
404: if r_ele.skip_rule_id is not null then
405: open c_ff (r_ele.skip_rule_id ) ;
406: fetch c_ff into ben_ext_person.g_runrslt_skip_rule ;
407: if c_ff%notfound then
408: ben_ext_person.g_runrslt_skip_rule := null ;
409: end if ;
410: close c_ff ;

Line 408: ben_ext_person.g_runrslt_skip_rule := null ;

404: if r_ele.skip_rule_id is not null then
405: open c_ff (r_ele.skip_rule_id ) ;
406: fetch c_ff into ben_ext_person.g_runrslt_skip_rule ;
407: if c_ff%notfound then
408: ben_ext_person.g_runrslt_skip_rule := null ;
409: end if ;
410: close c_ff ;
411: end if;
412: -- format and write

Line 460: ben_ext_person.g_runrslt_last_pay_date := r_asg.effective_date;

456:
457: IF l_include = 'Y' THEN
458:
459:
460: ben_ext_person.g_runrslt_last_pay_date := r_asg.effective_date;
461: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;
462: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
463: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
464: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;

Line 461: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;

457: IF l_include = 'Y' THEN
458:
459:
460: ben_ext_person.g_runrslt_last_pay_date := r_asg.effective_date;
461: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;
462: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
463: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
464: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
465: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; -- Bug 2669594

Line 462: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;

458:
459:
460: ben_ext_person.g_runrslt_last_pay_date := r_asg.effective_date;
461: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;
462: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
463: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
464: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
465: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; -- Bug 2669594
466: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;

Line 463: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;

459:
460: ben_ext_person.g_runrslt_last_pay_date := r_asg.effective_date;
461: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;
462: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
463: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
464: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
465: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; -- Bug 2669594
466: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
467: ben_ext_person.g_runrslt_status := r_rslt.status;

Line 464: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;

460: ben_ext_person.g_runrslt_last_pay_date := r_asg.effective_date;
461: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;
462: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
463: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
464: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
465: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; -- Bug 2669594
466: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
467: ben_ext_person.g_runrslt_status := r_rslt.status;
468: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;

Line 465: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; -- Bug 2669594

461: ben_ext_person.g_runrslt_input_value_units := r_rslt.value_unit;
462: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
463: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
464: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
465: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; -- Bug 2669594
466: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
467: ben_ext_person.g_runrslt_status := r_rslt.status;
468: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
469: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;

Line 466: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;

462: ben_ext_person.g_runrslt_input_value_sequence := r_rslt.value_seq;
463: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
464: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
465: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; -- Bug 2669594
466: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
467: ben_ext_person.g_runrslt_status := r_rslt.status;
468: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
469: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
470: ben_ext_person.g_runrslt_value := r_rslt.result_value;

Line 467: ben_ext_person.g_runrslt_status := r_rslt.status;

463: ben_ext_person.g_runrslt_identifier := r_rslt.result_id;
464: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
465: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; -- Bug 2669594
466: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
467: ben_ext_person.g_runrslt_status := r_rslt.status;
468: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
469: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
470: ben_ext_person.g_runrslt_value := r_rslt.result_value;
471: ben_ext_person.g_runrslt_element_name := r_ele.element_name;

Line 468: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;

464: ben_ext_person.g_runrslt_input_value_id := r_rslt.value_id;
465: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; -- Bug 2669594
466: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
467: ben_ext_person.g_runrslt_status := r_rslt.status;
468: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
469: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
470: ben_ext_person.g_runrslt_value := r_rslt.result_value;
471: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
472: ben_ext_person.g_runrslt_element_id := r_ele.element_id;

Line 469: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;

465: ben_ext_person.g_runrslt_input_value_name := r_rslt.value_name; -- Bug 2669594
466: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
467: ben_ext_person.g_runrslt_status := r_rslt.status;
468: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
469: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
470: ben_ext_person.g_runrslt_value := r_rslt.result_value;
471: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
472: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
473: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;

Line 470: ben_ext_person.g_runrslt_value := r_rslt.result_value;

466: ben_ext_person.g_runrslt_jurisdiction_code := r_rslt.juris_code;
467: ben_ext_person.g_runrslt_status := r_rslt.status;
468: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
469: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
470: ben_ext_person.g_runrslt_value := r_rslt.result_value;
471: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
472: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
473: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
474: ben_ext_person.g_runrslt_element_description := r_ele.description;

Line 471: ben_ext_person.g_runrslt_element_name := r_ele.element_name;

467: ben_ext_person.g_runrslt_status := r_rslt.status;
468: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
469: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
470: ben_ext_person.g_runrslt_value := r_rslt.result_value;
471: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
472: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
473: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
474: ben_ext_person.g_runrslt_element_description := r_ele.description;
475: ben_ext_person.g_runrslt_classification := r_ele.class_name;

Line 472: ben_ext_person.g_runrslt_element_id := r_ele.element_id;

468: ben_ext_person.g_runrslt_source_type := r_rslt.source_type;
469: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
470: ben_ext_person.g_runrslt_value := r_rslt.result_value;
471: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
472: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
473: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
474: ben_ext_person.g_runrslt_element_description := r_ele.description;
475: ben_ext_person.g_runrslt_classification := r_ele.class_name;
476: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;

Line 473: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;

469: ben_ext_person.g_runrslt_entry_type := r_rslt.entry_type;
470: ben_ext_person.g_runrslt_value := r_rslt.result_value;
471: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
472: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
473: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
474: ben_ext_person.g_runrslt_element_description := r_ele.description;
475: ben_ext_person.g_runrslt_classification := r_ele.class_name;
476: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
477: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;

Line 474: ben_ext_person.g_runrslt_element_description := r_ele.description;

470: ben_ext_person.g_runrslt_value := r_rslt.result_value;
471: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
472: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
473: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
474: ben_ext_person.g_runrslt_element_description := r_ele.description;
475: ben_ext_person.g_runrslt_classification := r_ele.class_name;
476: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
477: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
478: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;

Line 475: ben_ext_person.g_runrslt_classification := r_ele.class_name;

471: ben_ext_person.g_runrslt_element_name := r_ele.element_name;
472: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
473: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
474: ben_ext_person.g_runrslt_element_description := r_ele.description;
475: ben_ext_person.g_runrslt_classification := r_ele.class_name;
476: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
477: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
478: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;
479: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;

Line 476: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;

472: ben_ext_person.g_runrslt_element_id := r_ele.element_id;
473: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
474: ben_ext_person.g_runrslt_element_description := r_ele.description;
475: ben_ext_person.g_runrslt_classification := r_ele.class_name;
476: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
477: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
478: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;
479: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;
480: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;

Line 477: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;

473: ben_ext_person.g_runrslt_reporting_name := r_ele.reporting_name;
474: ben_ext_person.g_runrslt_element_description := r_ele.description;
475: ben_ext_person.g_runrslt_classification := r_ele.class_name;
476: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
477: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
478: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;
479: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;
480: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;
481: if r_ele.skip_rule_id is not null then

Line 478: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;

474: ben_ext_person.g_runrslt_element_description := r_ele.description;
475: ben_ext_person.g_runrslt_classification := r_ele.class_name;
476: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
477: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
478: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;
479: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;
480: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;
481: if r_ele.skip_rule_id is not null then
482: open c_ff (r_ele.skip_rule_id ) ;

Line 479: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;

475: ben_ext_person.g_runrslt_classification := r_ele.class_name;
476: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
477: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
478: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;
479: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;
480: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;
481: if r_ele.skip_rule_id is not null then
482: open c_ff (r_ele.skip_rule_id ) ;
483: fetch c_ff into ben_ext_person.g_runrslt_skip_rule ;

Line 480: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;

476: ben_ext_person.g_runrslt_classification_id := r_ele.class_id;
477: ben_ext_person.g_runrslt_processing_type := r_ele.process_type;
478: ben_ext_person.g_runrslt_input_currency := r_ele.input_currency;
479: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;
480: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;
481: if r_ele.skip_rule_id is not null then
482: open c_ff (r_ele.skip_rule_id ) ;
483: fetch c_ff into ben_ext_person.g_runrslt_skip_rule ;
484: if c_ff%notfound then

Line 483: fetch c_ff into ben_ext_person.g_runrslt_skip_rule ;

479: ben_ext_person.g_runrslt_output_currency := r_ele.output_currency;
480: ben_ext_person.g_runrslt_skip_rule_id := r_ele.skip_rule_id;
481: if r_ele.skip_rule_id is not null then
482: open c_ff (r_ele.skip_rule_id ) ;
483: fetch c_ff into ben_ext_person.g_runrslt_skip_rule ;
484: if c_ff%notfound then
485: ben_ext_person.g_runrslt_skip_rule := null ;
486: end if ;
487: close c_ff ;

Line 485: ben_ext_person.g_runrslt_skip_rule := null ;

481: if r_ele.skip_rule_id is not null then
482: open c_ff (r_ele.skip_rule_id ) ;
483: fetch c_ff into ben_ext_person.g_runrslt_skip_rule ;
484: if c_ff%notfound then
485: ben_ext_person.g_runrslt_skip_rule := null ;
486: end if ;
487: close c_ff ;
488: end if;
489: -- format and write