DBA Data[Home] [Help]

APPS.EGO_IMPORT_BATCHES_PKG dependencies on FND_PROFILE

Line 503: and NOT (nvl(FND_PROFILE.value('ENG:ENG_ITEM_ECN_ACCESS'), 1) = 2 and

499: from eng_change_order_types_v
500: where (disable_date is null or disable_date >= sysdate)
501: and nvl(START_DATE, sysdate) <= sysdate
502: and type_classification = 'HEADER'
503: and NOT (nvl(FND_PROFILE.value('ENG:ENG_ITEM_ECN_ACCESS'), 1) = 2 and
504: assembly_type = 2 and base_change_mgmt_type_code =
505: v_change_mgmt_type_code)
506: order by change_order_type) QRSLT
507: WHERE CHANGE_MGMT_TYPE_CODE = v_change_mgmt_type_code