APPS.ARP_PA_UTILS dependencies on AR_RECEIVABLE_APPLICATIONS

Line 54: ar_receivable_applications.applied_customer_trx_id%TYPE,

50: |
51: *=======================================================================*/
52: PROCEDURE get_line_applied(
53: p_application_id IN
54: ar_receivable_applications.applied_customer_trx_id%TYPE,
55: p_customer_trx_id IN
56: ar_receivable_applications.applied_customer_trx_id%TYPE,
57: p_as_of_date IN ar_receivable_applications.apply_date%TYPE,
58: p_process_rsob IN VARCHAR2,

Line 56: ar_receivable_applications.applied_customer_trx_id%TYPE,

52: PROCEDURE get_line_applied(
53: p_application_id IN
54: ar_receivable_applications.applied_customer_trx_id%TYPE,
55: p_customer_trx_id IN
56: ar_receivable_applications.applied_customer_trx_id%TYPE,
57: p_as_of_date IN ar_receivable_applications.apply_date%TYPE,
58: p_process_rsob IN VARCHAR2,
59: x_applied_amt_list OUT NOCOPY ARP_PA_UTILS.r_appl_amt_list,
60: x_return_status OUT NOCOPY VARCHAR2,

Line 57: p_as_of_date IN ar_receivable_applications.apply_date%TYPE,

53: p_application_id IN
54: ar_receivable_applications.applied_customer_trx_id%TYPE,
55: p_customer_trx_id IN
56: ar_receivable_applications.applied_customer_trx_id%TYPE,
57: p_as_of_date IN ar_receivable_applications.apply_date%TYPE,
58: p_process_rsob IN VARCHAR2,
59: x_applied_amt_list OUT NOCOPY ARP_PA_UTILS.r_appl_amt_list,
60: x_return_status OUT NOCOPY VARCHAR2,
61: x_msg_count OUT NOCOPY NUMBER,

Line 111: FROM ar_receivable_applications app,

107: INTO l_amount_applied
108: ,l_acctd_amount_applied
109: ,l_xchange_gain
110: ,l_xchange_loss
111: FROM ar_receivable_applications app,
112: ar_cash_receipts cr,
113: ra_customer_trx cm,
114: ra_customer_trx inv
115: WHERE

Line 206: FROM ar_receivable_applications app,

202: ,r_amount_applied
203: ,r_acctd_amount_applied
204: ,r_xchange_gain
205: ,r_xchange_loss
206: FROM ar_receivable_applications app,
207: ar_mc_receivable_apps amr,
208: ar_cash_receipts cr,
209: gl_ledger_relationships glr,
210: ra_customer_trx cm,