APPS.OKS_IMPORT_VALIDATE dependencies on HR_ORGANIZATION_INFORMATION

Line 812: ,HR_ORGANIZATION_INFORMATION HOI

808: ,OHI.SOURCE SOURCE
809: ,rtrim(OHI.DOCUMENT) DOCUMENT
810: FROM OKS_HEADERS_INTERFACE OHI
811: ,HR_ALL_ORGANIZATION_UNITS HOU
812: ,HR_ORGANIZATION_INFORMATION HOI
813: ,HZ_CUST_SITE_USES_ALL BTSUI
814: ,HZ_CUST_SITE_USES_ALL STSUI
815: ,FND_CURRENCIES FCUR
816: ,GL_DAILY_CONVERSION_TYPES GLCT

Line 937: ,HR_ORGANIZATION_INFORMATION HOIPL

933: ,OKC_K_GROUPS_TL CGTLN
934: ,OKC_K_GROUPS_B CGBN
935: ,OKX_PARTY_CONTACTS_V CCAI
936: ,OKX_PARTY_CONTACTS_V CCAN
937: ,HR_ORGANIZATION_INFORMATION HOIPL
938: ,GL_LEDGERS GL
939: WHERE HDI.CUSTOMER_PARTY_ID = HPCUSTI.PARTY_ID (+)
940: AND HDI.CUSTOMER_PARTY_NAME = HPCUSTN.PARTY_NAME (+)
941: AND HDI.CUSTOMER_PARTY_NUMBER = HPCUSTNUM.PARTY_NUMBER (+)

Line 2226: ,HR_ORGANIZATION_INFORMATION HOI

2222: AND ERC.LOOKUP_TYPE(+) = 'TAX_REASON') TEN
2223: ,FND_LOOKUPS BS
2224: ,RA_CUST_TRX_TYPES_ALL BTXNTYPE
2225: ,FND_LOOKUPS SRC
2226: ,HR_ORGANIZATION_INFORMATION HOI
2227: WHERE HST.TAX_EXEMPTION_CONTROL = TEC.LOOKUP_CODE (+)
2228: AND TEC.LOOKUP_TYPE (+) = 'ZX_EXEMPTION_CONTROL'
2229: AND HST.TAX_EXEMPTION_NUMBER = TEN.EXEMPT_CERTIFICATE_NUMBER (+)
2230: AND HST.EXEMPT_REASON_CODE = TEN.EXEMPT_REASON_CODE (+)

Line 3311: ,HR_ORGANIZATION_INFORMATION HOI

3307: AND COUNT(DISTINCT TANGIBLE.ROWID) OVER (PARTITION BY LST.ROWID) = 1
3308: THEN 'Y' ELSE 'N' END) TANGIBLE_SUB
3309: FROM OKS_INT_LINE_STG_TEMP LST
3310: ,OKS_INT_HEADER_STG_TEMP HDR
3311: ,HR_ORGANIZATION_INFORMATION HOI
3312: ,OKS_COVERAGE_TEMPLTS_V COVTEM
3313: ,OKC_STATUSES_B STS
3314: ,OKC_STATUSES_B HDRSTS
3315: ,FND_LOOKUPS CR1