APPS.HR_US_REPORTS dependencies on HR_ORGANIZATION_INFORMATION

Line 950: FROM hr_organization_information

946: begin
947: hr_utility.set_location('hr_us_reports.get_legislation_code',5);
948: SELECT org_information9
949: INTO l_legislation_code
950: FROM hr_organization_information
951: WHERE organization_id = p_business_group_id
952: AND UPPER(org_information_context) = 'BUSINESS GROUP INFORMATION';
953: --
954: exception when NO_DATA_FOUND then RETURN NULL;

Line 1255: FROM hr_organization_information hoi

1251: /* sackumar */
1252: begin
1253: SELECT 'Y'
1254: INTO tax_unit_flag
1255: FROM hr_organization_information hoi
1256: WHERE hoi.organization_id = parent_tax_unit_id
1257: AND hoi.ORG_INFORMATION1 = 'HR_LEGAL'
1258: AND hoi.ORG_INFORMATION2 = 'Y' ;
1259: exception

Line 1310: FROM hr_organization_information hoi

1306: --
1307: /* sackumar */
1308: CURSOR check_if_top_org IS
1309: SELECT hoi.organization_id
1310: FROM hr_organization_information hoi
1311: WHERE hoi.organization_id = p_starting_org_id
1312: AND hoi.ORG_INFORMATION1 = 'HR_LEGAL'
1313: AND hoi.ORG_INFORMATION2 = 'Y' ;
1314:

Line 1327: FROM hr_organization_information hoi

1323: --
1324: /* sackumar */
1325: cursor csr_tax_unit_flag(p_tax_unit_id number) is -- Bug 3624095
1326: SELECT hoi.organization_id
1327: FROM hr_organization_information hoi
1328: WHERE hoi.organization_id = p_tax_unit_id
1329: AND hoi.ORG_INFORMATION1 = 'HR_LEGAL'
1330: AND hoi.ORG_INFORMATION2 = 'Y' ;
1331:

Line 1707: FROM HR_ORGANIZATION_INFORMATION HOI1,

1703: and paf2.effective_start_date
1704: <= P_DATE_END)
1705: AND EXISTS (
1706: SELECT 'X'
1707: FROM HR_ORGANIZATION_INFORMATION HOI1,
1708: HR_ORGANIZATION_INFORMATION HOI2
1709: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1710: AND hoi1.org_information_context = 'Reporting Statuses'
1711: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 1708: HR_ORGANIZATION_INFORMATION HOI2

1704: <= P_DATE_END)
1705: AND EXISTS (
1706: SELECT 'X'
1707: FROM HR_ORGANIZATION_INFORMATION HOI1,
1708: HR_ORGANIZATION_INFORMATION HOI2
1709: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1710: AND hoi1.org_information_context = 'Reporting Statuses'
1711: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
1712: AND ass.employment_category = hoi2.org_information1