APPS.ARP_PROCESS_CREDIT dependencies on RA_CUST_TRX_TYPES

Line 396: FROM ra_cust_trx_types ctt

392: 'PRI', 'Y',
393: null)
394: INTO p_new_cm_rec.printing_option,
395: p_new_cm_rec.printing_pending
396: FROM ra_cust_trx_types ctt
397: WHERE ctt.cust_trx_type_id = p_new_cm_rec.cust_trx_type_id;
398:
399: END IF;
400:

Line 1112: ra_cust_trx_types commit_ctt,

1108: l_line_balance_due - sum(nvl(amount, 0))
1109: INTO l_trx_balance_due,
1110: l_line_balance_due
1111: FROM ar_adjustments adj,
1112: ra_cust_trx_types commit_ctt,
1113: ra_customer_trx commit_trx,
1114: ra_customer_trx credited_trx
1115: WHERE commit_ctt.cust_trx_type_id = commit_trx.cust_trx_type_id
1116: AND commit_trx.customer_trx_id =

Line 1487: p_trx_class IN ra_cust_trx_types.type%type,

1483: PROCEDURE insert_header(
1484: p_form_name IN varchar2,
1485: p_form_version IN number,
1486: p_trx_rec IN ra_customer_trx%rowtype,
1487: p_trx_class IN ra_cust_trx_types.type%type,
1488: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1489: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
1490: p_currency_code IN fnd_currencies.currency_code%type,
1491: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

Line 1548: FROM ra_cust_trx_types

1544: THEN
1545:
1546: SELECT NVL( default_status, 'OP' )
1547: INTO l_trx_rec.status_trx
1548: FROM ra_cust_trx_types
1549: WHERE cust_trx_type_id = p_trx_rec.cust_trx_type_id;
1550: END IF;
1551:
1552: validate_insert_header;

Line 2060: p_trx_class IN ra_cust_trx_types.type%type,

2056: p_form_name IN varchar2,
2057: p_form_version IN number,
2058: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2059: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
2060: p_trx_class IN ra_cust_trx_types.type%type,
2061: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
2062: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
2063: p_currency_code IN fnd_currencies.currency_code%type,
2064: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,