DBA Data[Home] [Help]

APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on AR_LOOKUPS

Line 1052: FROM OKL_LEASE_APPLICATIONS_B LAP,AR_LOOKUPS INDC, AR_LOOKUPS IND

1048: */
1049:
1050: SELECT INDC.MEANING ||' - '||IND.MEANING USAGE_INDUSTRY
1051: INTO l_usage_industry
1052: FROM OKL_LEASE_APPLICATIONS_B LAP,AR_LOOKUPS INDC, AR_LOOKUPS IND
1053: WHERE INDC.LOOKUP_TYPE(+)='SIC_CODE_TYPE'
1054: AND INDC.LOOKUP_CODE(+)=LAP.INDUSTRY_CLASS
1055: AND IND.LOOKUP_TYPE(+)=LAP.INDUSTRY_CLASS
1056: AND IND.LOOKUP_CODE(+)=LAP.INDUSTRY_CODE