APPS.PSA_MFAR_RECEIPTS dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 106: ar_receivable_applications_all ra

102: CURSOR c_crh
103: IS
104: SELECT distinct crh.status , crh.cash_receipt_id
105: FROM ar_cash_receipt_history_all crh,
106: ar_receivable_applications_all ra
107: WHERE crh.cash_receipt_id = ra.cash_receipt_id
108: AND ra.receivable_application_id = p_receivable_app_id
109: ORDER BY crh.status desc;
110:

Line 123: FROM ar_receivable_applications_all app

119: app.unearned_discount_taken unearned_discount,
120: app.earned_discount_ccid earned_discount_ccid,
121: app.unearned_discount_ccid unearned_discount_ccid,
122: app.customer_trx_id cm_trx_id
123: FROM ar_receivable_applications_all app
124: WHERE app.receivable_application_id = p_receivable_app_id
125: AND app.status = 'APP'
126: FOR UPDATE;
127:

Line 1557: FROM ar_receivable_applications_all app

1553: -- for each receivable application ids
1554:
1555: SELECT -1*LINE_Applied , -1*TAX_Applied
1556: INTO l_line_amount, l_tax_amount
1557: FROM ar_receivable_applications_all app
1558: WHERE app.receivable_application_id = p_rcv_app_id
1559: AND app.status = 'APP';
1560:
1561: