DBA Data[Home] [Help]

APPS.ARP_PROCESS_MISC_RECEIPTS dependencies on AR_LOOKUPS

Line 599: ar_lookups l_cr_status,

595: p_new_state_dsp
596: FROM
597: ar_cash_receipt_history crh_current,
598: ar_cash_receipts cr,
599: ar_lookups l_cr_status,
600: ar_lookups l_crh_status
601: WHERE
602: cr.cash_receipt_id = p_cash_receipt_id
603: AND l_cr_status.lookup_type = 'CHECK_STATUS'

Line 600: ar_lookups l_crh_status

596: FROM
597: ar_cash_receipt_history crh_current,
598: ar_cash_receipts cr,
599: ar_lookups l_cr_status,
600: ar_lookups l_crh_status
601: WHERE
602: cr.cash_receipt_id = p_cash_receipt_id
603: AND l_cr_status.lookup_type = 'CHECK_STATUS'
604: AND l_cr_status.lookup_code = cr.status