DBA Data[Home] [Help]

APPS.OZF_AR_PAYMENT_PVT dependencies on RA_CUSTOMER_TRX_LINES

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

961: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
962: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
963: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
964: p_customer_trx_line_id IN ar_receivable_applications.applied_customer_trx_line_id%TYPE DEFAULT NULL,
965: p_line_number IN ra_customer_trx_lines.line_number%TYPE DEFAULT NULL,
966: p_show_closed_invoices IN VARCHAR2 DEFAULT 'FALSE',
967: p_called_from IN VARCHAR2 DEFAULT NULL,
968: p_move_deferred_tax IN VARCHAR2 DEFAULT 'Y',
969: p_link_to_trx_hist_id IN ar_receivable_applications.link_to_trx_hist_id%TYPE DEFAULT NULL,

Line 2697: FROM ra_customer_trx_lines

2693: AND rec.secondary_application_ref_id = cv_root_claim_id;
2694:
2695: CURSOR csr_customer_trx_lines(cv_invoice_line_id IN NUMBER) IS
2696: SELECT customer_trx_id
2697: FROM ra_customer_trx_lines
2698: WHERE customer_trx_line_id = cv_invoice_line_id;
2699:
2700: BEGIN
2701: -------------------- initialize -----------------------

Line 3373: FROM ra_customer_trx_lines

3369: AND rec.secondary_application_ref_id = cv_root_claim_id;
3370:
3371: CURSOR csr_customer_trx_lines(cv_invoice_line_id IN NUMBER) IS
3372: SELECT customer_trx_id
3373: FROM ra_customer_trx_lines
3374: WHERE customer_trx_line_id = cv_invoice_line_id;
3375:
3376: --//Bug 12340283
3377: CURSOR csr_claim_lines(cv_claim_id IN NUMBER) IS