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 1434: ra_cust_trx_types tt

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

Line 1584: FROM ra_cust_trx_types

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