DBA Data[Home] [Help]

APPS.MRP_CL_FUNCTION dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1720: HR_ALL_ORGANIZATION_UNITS_TL OTL

1716: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
1717: HZ_CUST_SITE_USES_ALL SITE_USES_ALL,
1718: HZ_CUST_ACCOUNTS CUST_ACCT,
1719: HR_ORGANIZATION_INFORMATION O,
1720: HR_ALL_ORGANIZATION_UNITS_TL OTL
1721: WHERE OTL.ORGANIZATION_ID = SITE_USES_ALL.ORG_ID
1722: AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
1723: AND O.ORG_INFORMATION_CONTEXT = 'Operating Unit Information'
1724: AND OTL.LANGUAGE = userenv('LANG')

Line 1768: HR_ALL_ORGANIZATION_UNITS_TL OTL

1764: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
1765: HZ_CUST_SITE_USES_ALL SITE_USES_ALL,
1766: HZ_CUST_ACCOUNTS CUST_ACCT,
1767: HR_ORGANIZATION_INFORMATION O,
1768: HR_ALL_ORGANIZATION_UNITS_TL OTL
1769: WHERE OTL.ORGANIZATION_ID = SITE_USES_ALL.ORG_ID
1770: AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
1771: AND O.ORG_INFORMATION_CONTEXT = 'Operating Unit Information'
1772: AND OTL.LANGUAGE = userenv('LANG')