APPS.AR_DEPOSIT_VAL_PVT dependencies on AR_LOOKUPS

Line 344: FROM AR_LOOKUPS

340: l_status_trx_return_status VARCHAR2(1);
341: l_fc_return_status VARCHAR2(1);
342:
343: cursor c_status_cur is SELECT lookup_code CODE
344: FROM AR_LOOKUPS
345: WHERE LOOKUP_TYPE = 'INVOICE_TRX_STATUS';
346:
347: c_status_rec c_status_cur%rowtype;
348: c_status_result VARCHAR2(1) := 'N';

Line 352: from ar_lookups

348: c_status_result VARCHAR2(1) := 'N';
349:
350: cursor c_tax_flag_cur is
351: select lookup_code CODE
352: from ar_lookups
353: where lookup_type = 'TAX_CONTROL_FLAG' and
354: lookup_code <>
355: decode(nvl(ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag,'Y'),
356: 'Y', '!@#$', 'N', 'E');