[Home] [Help]
226: ELSE
227: CLOSE get_org_column_name;
228:
229: v_BlockStr := ' select ' || col_name ||
230: ' from hr_organization_information hoi ' ||
231: ' where hoi.organization_id = :1 '||
232: ' and hoi.org_information_context = ' ||'''SSHR Information''';
233:
234: -- Fix 3666171.
1032:
1033: /* --------------------------------------------------------------------------
1034: -- The following cursors are commented out because they use the
1035: -- per_business_groups complex views. For better performance, they are
1036: -- replaced by base table which is hr_organization_information.
1037: --
1038: -- Avoid using join for better performance
1039: CURSOR csr_per_leg_code is
1040: SELECT pbg.legislation_code
1070: -- are similar to SSHR V4 common module code.
1071: CURSOR csr_per_leg_code is
1072: SELECT org.org_information9 legislation_code
1073: FROM per_all_people_f ppf
1074: ,hr_organization_information org
1075: WHERE org.organization_id = ppf.business_group_id
1076: AND org.org_information_context = 'Business Group Information'
1077: AND ppf.person_id = p_person_id
1078: AND TRUNC(p_effective_date)
1082:
1083: CURSOR csr_asg_leg_code is
1084: SELECT org.org_information9 legislation_code
1085: FROM per_all_assignments_f paf
1086: ,hr_organization_information org
1087: WHERE org.organization_id = paf.business_group_id
1088: AND org.org_information_context = 'Business Group Information'
1089: AND paf.assignment_id = p_assignment_id
1090: AND TRUNC(p_effective_date)
1092: AND paf.effective_end_date;
1093:
1094: CURSOR csr_bus_leg_code is
1095: SELECT org_information9 legislation_code
1096: FROM hr_organization_information
1097: WHERE org_information_context = 'Business Group Information'
1098: and organization_id = p_business_group_id;
1099:
1100: BEGIN