DBA Data[Home] [Help]

APPS.ARP_INSERT_DIST_COVER dependencies on RA_CUST_TRX_TYPES

Line 380: ra_cust_trx_types ctt,

376: IS
377: CURSOR c_rule_based_inv IS
378: SELECT ctl.accounting_rule_id, ctt.type
379: FROM ra_customer_trx_lines ctl,
380: ra_cust_trx_types ctt,
381: ra_customer_trx ct
382: WHERE ctl.customer_trx_id = ct.customer_trx_id
383: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
384: AND ctl.customer_trx_line_id = p_customer_trx_line_id;

Line 398: l_trx_type ra_cust_trx_types.type%TYPE;

394: AND ra.account_class = 'REV'
395: and ROWNUM = 1;
396:
397: l_accounting_rule_id ra_rules.rule_id%TYPE;
398: l_trx_type ra_cust_trx_types.type%TYPE;
399: l_valid_orig_gl_date DATE;
400:
401: BEGIN
402: IF PG_DEBUG in ('Y', 'C') THEN