APPS.ARP_CR_UTIL dependencies on AR_CASH_RECEIPT_HISTORY

Line 18: ar_cash_receipt_history crh

14: --
15: CURSOR ar_get_crh_ccid_C IS
16: SELECT dist.code_combination_id ccid
17: FROM ar_distributions dist,
18: ar_cash_receipt_history crh
19: WHERE dist.source_table = 'CRH'
20: AND dist.source_id = crh.cash_receipt_history_id
21: AND dist.source_type = P_source_type
22: AND crh.cash_receipt_id = P_cr_id

Line 87: P_history_status OUT NOCOPY ar_cash_receipt_history.status%TYPE,

83: --
84: --
85: PROCEDURE get_creation_info( P_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE,
86: P_remit_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%type,
87: P_history_status OUT NOCOPY ar_cash_receipt_history.status%TYPE,
88: P_source_type OUT NOCOPY ar_distributions.source_type%TYPE,
89: P_ccid OUT NOCOPY ar_distributions.code_combination_id%TYPE,
90: P_override_remit_account_flag OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE) IS
91: l_history_status ar_cash_receipt_history.status%TYPE;

Line 91: l_history_status ar_cash_receipt_history.status%TYPE;

87: P_history_status OUT NOCOPY ar_cash_receipt_history.status%TYPE,
88: P_source_type OUT NOCOPY ar_distributions.source_type%TYPE,
89: P_ccid OUT NOCOPY ar_distributions.code_combination_id%TYPE,
90: P_override_remit_account_flag OUT NOCOPY ar_cash_receipts.override_remit_account_flag%TYPE) IS
91: l_history_status ar_cash_receipt_history.status%TYPE;
92: l_source_type ar_distributions.source_type%TYPE;
93: l_ccid ar_distributions.code_combination_id%TYPE;
94: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
95: --

Line 162: FROM ar_cash_receipt_history crh,

158: -- first_postable_flag ='Y'
159: --
160: SELECT max(crh.batch_id)
161: INTO p_batch_id
162: FROM ar_cash_receipt_history crh,
163: ar_batches bat
164: WHERE crh.cash_receipt_id = p_cr_id
165: AND crh.first_posted_record_flag = 'Y'
166: AND bat.batch_id = crh.batch_id