APPS.JMF_GTA_SPLIT_TRX_PROC dependencies on RA_CUSTOMER_TRX_ALL

Line 1187: ra_customer_trx_all h

1183: ctt.TYPE
1184: INTO
1185: l_trx_type
1186: FROM
1187: ra_customer_trx_all h
1188: , ra_cust_trx_types_all ctt
1189: WHERE ctt.cust_trx_type_id = h.cust_trx_type_id
1190: AND ctt.Org_Id = h.Org_Id
1191: AND h.customer_trx_id = p_gta_trx_rec.trx_header.ra_trx_id;

Line 1562: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;

1558: )
1559: IS
1560:
1561: l_procedure_name VARCHAR2(30) := 'get_trx_type';
1562: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
1563: l_trx_type ra_cust_trx_types_all.type%TYPE;
1564: BEGIN
1565: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1566: THEN

Line 1581: ra_customer_trx_all h

1577: ctt.TYPE
1578: INTO
1579: l_trx_type
1580: FROM
1581: ra_customer_trx_all h
1582: ,ra_cust_trx_types_all ctt
1583: WHERE h.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID(+)
1584: AND ctt.TYPE IN ('INV', 'CM', 'DM')
1585: AND ctt.org_id = p_org_id