APPS.AR_PUBLIC_UTILS dependencies on AR_RECEIVABLE_APPLICATIONS

Line 54: p_application_type IN ar_receivable_applications.status%TYPE DEFAULT 'APP',

50: *=======================================================================*/
51: PROCEDURE get_payment_info(
52: p_payment_server_order_num IN
53: ar_cash_receipts.payment_server_order_num%TYPE,
54: p_application_type IN ar_receivable_applications.status%TYPE DEFAULT 'APP',
55: p_receipt_header OUT NOCOPY ar_cash_receipts%ROWTYPE,
56: p_app_rec OUT NOCOPY application_tbl_type,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,

Line 64: FROM ar_receivable_applications

60: ) IS
61:
62: CURSOR app_rec_cur(c_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE) IS
63: SELECT *
64: FROM ar_receivable_applications
65: WHERE cash_receipt_id=c_cash_receipt_id
66: AND status = p_application_type
67: AND display='Y';
68: