DBA Data[Home] [Help]

APPS.ARP_PROC_RECEIPTS1 dependencies on AR_LOOKUPS

Line 1821: ar_lookups l_cr_status,

1817: p_new_state_dsp
1818: FROM
1819: ar_cash_receipt_history crh_current,
1820: ar_cash_receipts cr,
1821: ar_lookups l_cr_status,
1822: ar_lookups l_crh_status
1823: WHERE
1824: cr.cash_receipt_id = p_cash_receipt_id
1825: AND l_cr_status.lookup_type = 'CHECK_STATUS'

Line 1822: ar_lookups l_crh_status

1818: FROM
1819: ar_cash_receipt_history crh_current,
1820: ar_cash_receipts cr,
1821: ar_lookups l_cr_status,
1822: ar_lookups l_crh_status
1823: WHERE
1824: cr.cash_receipt_id = p_cash_receipt_id
1825: AND l_cr_status.lookup_type = 'CHECK_STATUS'
1826: AND l_cr_status.lookup_code = cr.status