APPS.ARP_PROCESS_CREDIT dependencies on RA_CUST_TRX_TYPES

Line 415: FROM ra_cust_trx_types ctt

411: 'PRI', 'Y',
412: null)
413: INTO p_new_cm_rec.printing_option,
414: p_new_cm_rec.printing_pending
415: FROM ra_cust_trx_types ctt
416: WHERE ctt.cust_trx_type_id = p_new_cm_rec.cust_trx_type_id;
417:
418: END IF;
419:

Line 1142: ra_cust_trx_types commit_ctt,

1138: l_line_balance_due - sum(nvl(amount, 0))
1139: INTO l_trx_balance_due,
1140: l_line_balance_due
1141: FROM ar_adjustments adj,
1142: ra_cust_trx_types commit_ctt,
1143: ra_customer_trx commit_trx,
1144: ra_customer_trx credited_trx
1145: WHERE commit_ctt.cust_trx_type_id = commit_trx.cust_trx_type_id
1146: AND commit_trx.customer_trx_id =

Line 1517: p_trx_class IN ra_cust_trx_types.type%type,

1513: PROCEDURE insert_header(
1514: p_form_name IN varchar2,
1515: p_form_version IN number,
1516: p_trx_rec IN ra_customer_trx%rowtype,
1517: p_trx_class IN ra_cust_trx_types.type%type,
1518: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
1519: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
1520: p_currency_code IN fnd_currencies.currency_code%type,
1521: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

Line 1578: FROM ra_cust_trx_types

1574: THEN
1575:
1576: SELECT NVL( default_status, 'OP' )
1577: INTO l_trx_rec.status_trx
1578: FROM ra_cust_trx_types
1579: WHERE cust_trx_type_id = p_trx_rec.cust_trx_type_id;
1580: END IF;
1581:
1582: validate_insert_header;

Line 2090: p_trx_class IN ra_cust_trx_types.type%type,

2086: p_form_name IN varchar2,
2087: p_form_version IN number,
2088: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
2089: p_trx_rec IN OUT NOCOPY ra_customer_trx%rowtype,
2090: p_trx_class IN ra_cust_trx_types.type%type,
2091: p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
2092: p_primary_salesrep_id IN ra_salesreps.salesrep_id%type,
2093: p_currency_code IN fnd_currencies.currency_code%type,
2094: p_prev_customer_trx_id IN ra_customer_trx.customer_trx_id%type,