APPS.AR_DEPOSIT_VAL_PVT dependencies on AR_LOOKUPS

Line 343: FROM AR_LOOKUPS

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

Line 351: from ar_lookups

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