APPS.FA_MASSADD_PREPARE_PKG dependencies on FA_LOOKUPS

Line 594: from fa_lookups

590: and nvl(merged_code, '1') not in ('MC');
591:
592: CURSOR lookup_cur(c_lookup_type varchar2) IS
593: select lookup_code
594: from fa_lookups
595: where lookup_type = c_lookup_type
596: and enabled_flag = 'Y'
597: and nvl(end_date_active, sysdate) >= sysdate
598: and rownum = 1;