APPS.HR_US_REPORTS dependencies on HR_ORGANIZATION_INFORMATION

Line 968: FROM hr_organization_information

964: begin
965: hr_utility.set_location('hr_us_reports.get_legislation_code',5);
966: SELECT org_information9
967: INTO l_legislation_code
968: FROM hr_organization_information
969: WHERE organization_id = p_business_group_id
970: AND UPPER(org_information_context) = 'BUSINESS GROUP INFORMATION';
971: --
972: exception when NO_DATA_FOUND then RETURN NULL;

Line 1273: FROM hr_organization_information hoi

1269: /* sackumar */
1270: begin
1271: SELECT 'Y'
1272: INTO tax_unit_flag
1273: FROM hr_organization_information hoi
1274: WHERE hoi.organization_id = parent_tax_unit_id
1275: AND hoi.ORG_INFORMATION1 = 'HR_LEGAL'
1276: AND hoi.ORG_INFORMATION2 = 'Y' ;
1277: exception

Line 1328: FROM hr_organization_information hoi

1324: --
1325: /* sackumar */
1326: CURSOR check_if_top_org IS
1327: SELECT hoi.organization_id
1328: FROM hr_organization_information hoi
1329: WHERE hoi.organization_id = p_starting_org_id
1330: AND hoi.ORG_INFORMATION1 = 'HR_LEGAL'
1331: AND hoi.ORG_INFORMATION2 = 'Y' ;
1332:

Line 1345: FROM hr_organization_information hoi

1341: --
1342: /* sackumar */
1343: cursor csr_tax_unit_flag(p_tax_unit_id number) is -- Bug 3624095
1344: SELECT hoi.organization_id
1345: FROM hr_organization_information hoi
1346: WHERE hoi.organization_id = p_tax_unit_id
1347: AND hoi.ORG_INFORMATION1 = 'HR_LEGAL'
1348: AND hoi.ORG_INFORMATION2 = 'Y' ;
1349:

Line 1725: FROM HR_ORGANIZATION_INFORMATION HOI1,

1721: and paf2.effective_start_date
1722: <= P_DATE_END)
1723: AND EXISTS (
1724: SELECT 'X'
1725: FROM HR_ORGANIZATION_INFORMATION HOI1,
1726: HR_ORGANIZATION_INFORMATION HOI2
1727: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1728: AND hoi1.org_information_context = 'Reporting Statuses'
1729: AND hoi1.organization_id = P_BUSINESS_GROUP_ID

Line 1726: HR_ORGANIZATION_INFORMATION HOI2

1722: <= P_DATE_END)
1723: AND EXISTS (
1724: SELECT 'X'
1725: FROM HR_ORGANIZATION_INFORMATION HOI1,
1726: HR_ORGANIZATION_INFORMATION HOI2
1727: WHERE TO_CHAR(ASS.ASSIGNMENT_STATUS_TYPE_ID) = HOI1.ORG_INFORMATION1
1728: AND hoi1.org_information_context = 'Reporting Statuses'
1729: AND hoi1.organization_id = P_BUSINESS_GROUP_ID
1730: AND ass.employment_category = hoi2.org_information1