APPS.PA_AR_ADV_RECEIPT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 17: from ar_receivable_applications app

13: x_msg_data IN OUT NOCOPY VARCHAR2 ) is
14: CURSOR APPLY_cur IS
15: select app.amount_applied,
16: app.receivable_application_id
17: from ar_receivable_applications app
18: where app.cash_receipt_id = p_receipt_id
19: and app.STATUS ='ACC'
20: and app.display='Y';
21: l_api_version NUMBER := 1.0;

Line 56: select ar_receivable_applications_s1.nextval into l_payment_set_id from dual;

52: END IF;
53:
54: l_position := '2';
55: IF x_payment_set_id is null then
56: select ar_receivable_applications_s1.nextval into l_payment_set_id from dual;
57: ELSE
58: l_payment_set_id := x_payment_set_id;
59: END IF;
60:

Line 130: from ar_receivable_applications app

126: CURSOR UNAPPLY_recpt_cur IS
127: select app.amount_applied,
128: app.receivable_application_id,
129: app.cash_receipt_id
130: from ar_receivable_applications app
131: where app.cash_receipt_id = p_receipt_id
132: and app.STATUS ='OTHER ACC'
133: and app.display='Y';
134:

Line 140: from ar_receivable_applications app

136: CURSOR UNAPPLY_pay_cur IS
137: select app.amount_applied,
138: app.receivable_application_id,
139: app.cash_receipt_id
140: from ar_receivable_applications app
141: where app.STATUS ='OTHER ACC'
142: and app.display='Y'
143: and app.payment_set_id = p_payment_set_id;
144: