DBA Data[Home] [Help]

APPS.ARP_PROC_RECEIPTS1 dependencies on AR_LOOKUPS

Line 1664: ar_lookups l_cr_status,

1660: p_new_state_dsp
1661: FROM
1662: ar_cash_receipt_history crh_current,
1663: ar_cash_receipts cr,
1664: ar_lookups l_cr_status,
1665: ar_lookups l_crh_status
1666: WHERE
1667: cr.cash_receipt_id = p_cash_receipt_id
1668: AND l_cr_status.lookup_type = 'CHECK_STATUS'

Line 1665: ar_lookups l_crh_status

1661: FROM
1662: ar_cash_receipt_history crh_current,
1663: ar_cash_receipts cr,
1664: ar_lookups l_cr_status,
1665: ar_lookups l_crh_status
1666: WHERE
1667: cr.cash_receipt_id = p_cash_receipt_id
1668: AND l_cr_status.lookup_type = 'CHECK_STATUS'
1669: AND l_cr_status.lookup_code = cr.status