DBA Data[Home] [Help]

APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on AR_LOOKUPS

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

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