APPS.OZF_AR_PAYMENT_PVT dependencies on RA_CUSTOMER_TRX

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 1161: l_x_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;

1157: l_credit_rules VARCHAR2(30);
1158:
1159: l_x_status_meaning VARCHAR2(60);
1160: l_x_reason_meaning VARCHAR2(60);
1161: l_x_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
1162: --l_x_cm_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE:
1163: l_x_line_amount RA_CM_REQUESTS.line_amount%TYPE;
1164: l_x_tax_amount RA_CM_REQUESTS.tax_amount%TYPE;
1165: l_x_freight_amount RA_CM_REQUESTS.freight_amount%TYPE;

Line 1162: --l_x_cm_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE:

1158:
1159: l_x_status_meaning VARCHAR2(60);
1160: l_x_reason_meaning VARCHAR2(60);
1161: l_x_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE;
1162: --l_x_cm_customer_trx_id RA_CUSTOMER_TRX.customer_trx_id%TYPE:
1163: l_x_line_amount RA_CM_REQUESTS.line_amount%TYPE;
1164: l_x_tax_amount RA_CM_REQUESTS.tax_amount%TYPE;
1165: l_x_freight_amount RA_CM_REQUESTS.freight_amount%TYPE;
1166: l_x_line_credits_flag VARCHAR2(1);

Line 1218: FROM ra_customer_trx

1214: , attribute12
1215: , attribute13
1216: , attribute14
1217: , attribute15
1218: FROM ra_customer_trx
1219: WHERE customer_trx_id = cv_cust_trx_id;
1220:
1221: -- Fix for Bug#11741663
1222: CURSOR csr_get_interface_attr_dtls (cv_claim_id IN NUMBER) IS

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

Line 3780: FROM ra_customer_trx

3776:
3777: --4684931
3778: CURSOR csr_trx_currency(cv_customer_trx_id IN NUMBER) IS
3779: SELECT invoice_currency_code
3780: FROM ra_customer_trx
3781: WHERE customer_trx_id = cv_customer_trx_id;
3782:
3783: CURSOR csr_rec_currency(cv_cash_receipt_id IN NUMBER) IS
3784: SELECT currency_code

Line 4586: FROM ra_customer_trx

4582: AND secondary_application_ref_id = cv_root_claim_id;
4583:
4584: CURSOR csr_payment_trx_number(cv_customer_trx_id IN NUMBER) IS
4585: SELECT trx_number
4586: FROM ra_customer_trx
4587: WHERE customer_trx_id = cv_customer_trx_id;
4588:
4589: CURSOR csr_dm_exist_on_rec(cv_cash_receipt_id IN NUMBER, cv_customer_trx_id IN NUMBER) IS
4590: SELECT amount_applied,

Line 4613: FROM ra_customer_trx

4609:
4610: --bug 4684931
4611: CURSOR csr_trx_currency(cv_customer_trx_id IN NUMBER) IS
4612: SELECT invoice_currency_code
4613: FROM ra_customer_trx
4614: WHERE customer_trx_id = cv_customer_trx_id;
4615:
4616: CURSOR csr_rec_currency(cv_cash_receipt_id IN NUMBER) IS
4617: SELECT currency_code