APPS.OZF_AR_PAYMENT_PVT dependencies on RA_CUSTOMER_TRX_LINES

Line 773: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,

769: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
770: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
771: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
772: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
773: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
774: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
775: p_called_from IN VARCHAR2 DEFAULT NULL,
776: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
777: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

Line 2272: FROM ra_customer_trx_lines

2268: AND rec.secondary_application_ref_id = cv_root_claim_id;
2269:
2270: CURSOR csr_customer_trx_lines(cv_invoice_line_id IN NUMBER) IS
2271: SELECT customer_trx_id
2272: FROM ra_customer_trx_lines
2273: WHERE customer_trx_line_id = cv_invoice_line_id;
2274:
2275: BEGIN
2276: -------------------- initialize -----------------------

Line 2908: FROM ra_customer_trx_lines

2904: AND rec.secondary_application_ref_id = cv_root_claim_id;
2905:
2906: CURSOR csr_customer_trx_lines(cv_invoice_line_id IN NUMBER) IS
2907: SELECT customer_trx_id
2908: FROM ra_customer_trx_lines
2909: WHERE customer_trx_line_id = cv_invoice_line_id;
2910:
2911: CURSOR csr_claim_lines(cv_claim_id IN NUMBER) IS
2912: SELECT source_object_id, sum(claim_currency_amount) amt