APPS.AR_GTA_SPLIT_TRX_PROC dependencies on RA_CUSTOMER_TRX_ALL

Line 1573: ra_customer_trx_all h

1569: ctt.TYPE
1570: INTO
1571: l_trx_type
1572: FROM
1573: ra_customer_trx_all h
1574: , ra_cust_trx_types_all ctt
1575: WHERE ctt.cust_trx_type_id = h.cust_trx_type_id
1576: AND ctt.Org_Id = h.Org_Id
1577: AND h.customer_trx_id = p_gta_trx_rec.trx_header.ra_trx_id;

Line 1949: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;

1945: )
1946: IS
1947:
1948: l_procedure_name VARCHAR2(30) := 'get_trx_type';
1949: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
1950: l_trx_type ra_cust_trx_types_all.type%TYPE;
1951: BEGIN
1952: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1953: THEN

Line 1978: ra_customer_trx_all h

1974: ctt.TYPE
1975: INTO
1976: l_trx_type
1977: FROM
1978: ra_customer_trx_all h
1979: ,ra_cust_trx_types_all ctt
1980: WHERE h.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID(+)
1981: AND ctt.TYPE IN ('INV', 'CM', 'DM')
1982: AND ctt.org_id = p_org_id