DBA Data[Home] [Help]

APPS.ARP_PROCESS_MISC_RECEIPTS dependencies on AR_LOOKUPS

Line 626: ar_lookups l_cr_status,

622: p_new_state_dsp
623: FROM
624: ar_cash_receipt_history crh_current,
625: ar_cash_receipts cr,
626: ar_lookups l_cr_status,
627: ar_lookups l_crh_status
628: WHERE
629: cr.cash_receipt_id = p_cash_receipt_id
630: AND l_cr_status.lookup_type = 'CHECK_STATUS'

Line 627: ar_lookups l_crh_status

623: FROM
624: ar_cash_receipt_history crh_current,
625: ar_cash_receipts cr,
626: ar_lookups l_cr_status,
627: ar_lookups l_crh_status
628: WHERE
629: cr.cash_receipt_id = p_cash_receipt_id
630: AND l_cr_status.lookup_type = 'CHECK_STATUS'
631: AND l_cr_status.lookup_code = cr.status