DBA Data[Home] [Help]

APPS.QP_JAVA_ENGINE_CACHE_PVT dependencies on FND_PROFILE_OPTION_VALUES

Line 39: FROM FND_PROFILE_OPTIONS o, FND_PROFILE_OPTION_VALUES ov

35: WHERE qpe.pricing_phase_id = qpp.pricing_phase_id;
36:
37: CURSOR profile_csr IS
38: SELECT count(*)
39: FROM FND_PROFILE_OPTIONS o, FND_PROFILE_OPTION_VALUES ov
40: WHERE o.APPLICATION_ID = 661 and o.PROFILE_OPTION_ID = ov.PROFILE_OPTION_ID (+) and o.APP_ENABLED_FLAG = 'N' and o.RESP_ENABLED_FLAG = 'N' and o.USER_ENABLED_FLAG = 'N';
41:
42: CURSOR cache_do_size_csr IS
43: SELECT count(*)