26: --Bug 5069923
27: and ( (report_for_var='A')
28: or ( (hoi2.organization_id in (select posev.ORGANIZATION_ID_child
29: from PER_ORG_STRUCTURE_ELEMENTS posev
30: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
31: and exists (select null
32: from hr_organization_information
33: where organization_id = posev.ORGANIZATION_ID_child
34: and org_information_context = 'CLASS'
64: and paa.tax_unit_id = bp2.organization_id
65: and paa.action_status = 'C');
66: begin
67: if g_business_place_id is null then
68: g_business_place_id := to_number(pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID'));
69: g_target_year := to_number(pay_magtape_generic.get_parameter_value('TARGET_YEAR'));
70: --Bug 5069923
71: report_for_var := pay_magtape_generic.get_parameter_value('REPORT_FOR');
72: --
65: and paa.action_status = 'C');
66: begin
67: if g_business_place_id is null then
68: g_business_place_id := to_number(pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID'));
69: g_target_year := to_number(pay_magtape_generic.get_parameter_value('TARGET_YEAR'));
70: --Bug 5069923
71: report_for_var := pay_magtape_generic.get_parameter_value('REPORT_FOR');
72: --
73: open csr_a;
67: if g_business_place_id is null then
68: g_business_place_id := to_number(pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID'));
69: g_target_year := to_number(pay_magtape_generic.get_parameter_value('TARGET_YEAR'));
70: --Bug 5069923
71: report_for_var := pay_magtape_generic.get_parameter_value('REPORT_FOR');
72: --
73: open csr_a;
74: fetch csr_a into g_b_records;
75: close csr_a;
98: return l_user_entity_id;
99: end user_entity_id;
100: begin
101: -- Bug 3248513
102: g_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
103: g_assignment_set_id := to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'));
104:
105: if g_payroll_action_id is null then
106:
99: end user_entity_id;
100: begin
101: -- Bug 3248513
102: g_payroll_action_id := pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
103: g_assignment_set_id := to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'));
104:
105: if g_payroll_action_id is null then
106:
107: l_report_type := pay_magtape_generic.get_parameter_value('REPORT_TYPE');
103: g_assignment_set_id := to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'));
104:
105: if g_payroll_action_id is null then
106:
107: l_report_type := pay_magtape_generic.get_parameter_value('REPORT_TYPE');
108:
109: if l_report_type is null then
110: g_normal_yea := 'N';
111: g_interim_yea := 'I';