DBA Data[Home] [Help]

APPS.ARP_TRX_VALIDATE dependencies on RA_CUST_TRX_TYPES

Line 433: FROM ra_cust_trx_types ctt,

429: AND NVL(ri.new_customer_trx_id, -98)
430: <> NVL(p_customer_trx_id, -99)
431: UNION
432: SELECT 'Y'
433: FROM ra_cust_trx_types ctt,
434: ra_interface_lines ril
435: WHERE ril.cust_trx_type_name = ctt.name(+)
436: AND NVL(ril.cust_trx_type_id,
437: ctt.cust_trx_type_id) = p_cust_trx_type_id

Line 1437: ra_cust_trx_types tt

1433: 'N')
1434: INTO l_temp,
1435: l_commit_bal
1436: FROM ra_customer_trx t,
1437: ra_cust_trx_types tt
1438: WHERE t.customer_trx_id = p_initial_customer_trx_id
1439: AND t.cust_trx_type_id = tt.cust_trx_type_id
1440: AND p_trx_date
1441: BETWEEN NVL( t.start_date_commitment, p_trx_date )

Line 1587: FROM ra_cust_trx_types

1583: THEN
1584: BEGIN
1585: SELECT tax_calculation_flag
1586: INTO l_temp
1587: FROM ra_cust_trx_types
1588: WHERE CUST_TRX_TYPE_ID = p_cust_trx_type_id
1589: AND p_trx_date BETWEEN START_DATE
1590: AND NVL(END_DATE, p_trx_date);
1591: