APPS.ARP_RATE_ADJ dependencies on AR_CASH_RECEIPT_HISTORY

Line 24: crh_id_out OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE)

20: new_lub IN NUMBER,
21: new_lud IN DATE,
22: new_lul IN NUMBER,
23: touch_hist_and_dist IN BOOLEAN DEFAULT TRUE,
24: crh_id_out OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE)
25: IS
26: CURSOR cr_info (cr_id AR_CASH_RECEIPTS.CASH_RECEIPT_ID%TYPE) IS
27: SELECT cr.cash_receipt_id cash_receipt_id,
28: cr.set_of_books_id set_of_books_id,

Line 54: FROM AR_CASH_RECEIPT_HISTORY

50: cr.exchange_rate_type;
51:
52: CURSOR crh_info (cr_id NUMBER) IS
53: SELECT *
54: FROM AR_CASH_RECEIPT_HISTORY
55: WHERE CASH_RECEIPT_ID = cr_id
56: AND CURRENT_RECORD_FLAG = 'Y';
57:
58: CURSOR crh_prv_stat_info (cr_id NUMBER) IS

Line 60: FROM AR_CASH_RECEIPT_HISTORY

56: AND CURRENT_RECORD_FLAG = 'Y';
57:
58: CURSOR crh_prv_stat_info (cr_id NUMBER) IS
59: SELECT *
60: FROM AR_CASH_RECEIPT_HISTORY
61: WHERE CASH_RECEIPT_HISTORY_ID =
62: (SELECT PRV_STAT_CASH_RECEIPT_HIST_ID
63: FROM AR_CASH_RECEIPT_HISTORY
64: WHERE CASH_RECEIPT_ID = cr_id

Line 63: FROM AR_CASH_RECEIPT_HISTORY

59: SELECT *
60: FROM AR_CASH_RECEIPT_HISTORY
61: WHERE CASH_RECEIPT_HISTORY_ID =
62: (SELECT PRV_STAT_CASH_RECEIPT_HIST_ID
63: FROM AR_CASH_RECEIPT_HISTORY
64: WHERE CASH_RECEIPT_ID = cr_id
65: AND CURRENT_RECORD_FLAG = 'Y');
66:
67: CURSOR dis_info (cr_id NUMBER) IS

Line 76: FROM AR_CASH_RECEIPT_HISTORY crh,

72: crh2.acctd_factor_discount_amount,
73: crh2.cash_receipt_history_id,
74: d.source_type,
75: d.source_table
76: FROM AR_CASH_RECEIPT_HISTORY crh,
77: AR_CASH_RECEIPT_HISTORY crh2,
78: AR_DISTRIBUTIONS d
79: WHERE crh.cash_receipt_id = cr_id
80: AND crh2.cash_receipt_id = cr_id

Line 77: AR_CASH_RECEIPT_HISTORY crh2,

73: crh2.cash_receipt_history_id,
74: d.source_type,
75: d.source_table
76: FROM AR_CASH_RECEIPT_HISTORY crh,
77: AR_CASH_RECEIPT_HISTORY crh2,
78: AR_DISTRIBUTIONS d
79: WHERE crh.cash_receipt_id = cr_id
80: AND crh2.cash_receipt_id = cr_id
81: AND d.source_id = crh.cash_receipt_history_id

Line 127: AR_CASH_RECEIPT_HISTORY ARCH

123: SELECT ARCH.ACCTD_AMOUNT,
124: ARCH.ACCTD_FACTOR_DISCOUNT_AMOUNT,
125: ARPS.ACCTD_AMOUNT_DUE_REMAINING
126: FROM AR_PAYMENT_SCHEDULES ARPS,
127: AR_CASH_RECEIPT_HISTORY ARCH
128: WHERE ARPS.CASH_RECEIPT_ID = cr_id
129: AND ARCH.CASH_RECEIPT_ID = cr_id
130: AND ARCH.CURRENT_RECORD_FLAG = 'Y';
131:

Line 188: new_crh_id AR_CASH_RECEIPT_HISTORY.CASH_RECEIPT_HISTORY_ID%TYPE;

184: old_rec_app rec_app_info%ROWTYPE;
185: ps_remaining ps_remaining_info%ROWTYPE;
186: acctd get_acctd_amounts%ROWTYPE;
187:
188: new_crh_id AR_CASH_RECEIPT_HISTORY.CASH_RECEIPT_HISTORY_ID%TYPE;
189: old_crh_id AR_CASH_RECEIPT_HISTORY.CASH_RECEIPT_HISTORY_ID%TYPE;
190: unapp_id AR_RECEIVABLE_APPLICATIONS.RECEIVABLE_APPLICATION_ID%TYPE;
191:
192: dis DIS_INFO%ROWTYPE;

Line 189: old_crh_id AR_CASH_RECEIPT_HISTORY.CASH_RECEIPT_HISTORY_ID%TYPE;

185: ps_remaining ps_remaining_info%ROWTYPE;
186: acctd get_acctd_amounts%ROWTYPE;
187:
188: new_crh_id AR_CASH_RECEIPT_HISTORY.CASH_RECEIPT_HISTORY_ID%TYPE;
189: old_crh_id AR_CASH_RECEIPT_HISTORY.CASH_RECEIPT_HISTORY_ID%TYPE;
190: unapp_id AR_RECEIVABLE_APPLICATIONS.RECEIVABLE_APPLICATION_ID%TYPE;
191:
192: dis DIS_INFO%ROWTYPE;
193: acctd_curr_amount AR_CASH_RECEIPT_HISTORY.ACCTD_AMOUNT%TYPE;

Line 193: acctd_curr_amount AR_CASH_RECEIPT_HISTORY.ACCTD_AMOUNT%TYPE;

189: old_crh_id AR_CASH_RECEIPT_HISTORY.CASH_RECEIPT_HISTORY_ID%TYPE;
190: unapp_id AR_RECEIVABLE_APPLICATIONS.RECEIVABLE_APPLICATION_ID%TYPE;
191:
192: dis DIS_INFO%ROWTYPE;
193: acctd_curr_amount AR_CASH_RECEIPT_HISTORY.ACCTD_AMOUNT%TYPE;
194: acctd_dis_amount AR_DISTRIBUTIONS.ACCTD_AMOUNT_DR%TYPE;
195: amount_cr NUMBER;
196: amount_dr NUMBER;
197: acctd_amount_cr NUMBER;

Line 208: acctd_diff AR_CASH_RECEIPT_HISTORY.ACCTD_AMOUNT%TYPE;

204:
205: app_acctd_amount AR_PAYMENT_SCHEDULES.ACCTD_AMOUNT_DUE_REMAINING%TYPE;
206: new_ps_acctd_amount AR_PAYMENT_SCHEDULES.ACCTD_AMOUNT_DUE_REMAINING%TYPE;
207:
208: acctd_diff AR_CASH_RECEIPT_HISTORY.ACCTD_AMOUNT%TYPE;
209:
210: temp_num NUMBER;
211:
212: total_unid NUMBER := 0; -- running total of 'UNID' records

Line 273: old_crh_reverse_rec ar_cash_receipt_history_all%ROWTYPE;

269: l_upgrade_methode VARCHAR2(30);
270:
271:
272: --BUG#5201086
273: old_crh_reverse_rec ar_cash_receipt_history_all%ROWTYPE;
274: old_reverse_crh_id NUMBER;
275: CURSOR c_distrib(p_source_id IN NUMBER,
276: p_source_table IN VARCHAR2,
277: p_status IN VARCHAR2)