DBA Data[Home] [Help]

APPS.FA_MASSADD_PREPARE_PKG dependencies on FA_LOOKUPS

Line 454: FROM fa_lookups

450: AND NVL (merged_code, '1') NOT IN ('MC');
451:
452: CURSOR lookup_cur (c_lookup_type VARCHAR2) IS
453: SELECT lookup_code
454: FROM fa_lookups
455: WHERE lookup_type = c_lookup_type
456: AND enabled_flag = 'Y'
457: AND NVL (end_date_active, SYSDATE) >= SYSDATE
458: AND ROWNUM = 1;