APPS.ARPT_SQL_FUNC_UTIL dependencies on RA_BATCH_SOURCES

Line 1101: ra_batch_sources bs

1097: '15', ct.interface_header_attribute15,
1098: NULL )
1099: INTO l_temp
1100: FROM ra_customer_trx ct,
1101: ra_batch_sources bs
1102: WHERE ct.rowid = p_trx_rowid and
1103: bs.batch_source_id = ct.batch_source_id;
1104: END IF;
1105:

Line 1167: ra_batch_sources bs

1163: NULL )
1164: INTO l_line_temp
1165: FROM ra_customer_trx_lines ctl,
1166: ra_customer_trx ct,
1167: ra_batch_sources bs
1168: WHERE bs.batch_source_id = ct.batch_source_id and
1169: ctl.customer_trx_id = ct.customer_trx_id and
1170: ctl.rowid = p_line_trx_rowid ;
1171: END IF;

Line 1921: l_bs_name ra_batch_sources.name%type;

1917: p_customer_trx_id IN number
1918: )
1919: RETURN VARCHAR2 is
1920:
1921: l_bs_name ra_batch_sources.name%type;
1922: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
1923:
1924: BEGIN
1925:

Line 1938: ra_batch_sources bs

1934:
1935: select bs.name
1936: into l_bs_name
1937: from ra_customer_trx ct,
1938: ra_batch_sources bs
1939: where ct.batch_source_id = bs.batch_source_id
1940: and ct.org_id = bs.org_id --anuj
1941: and ct.customer_trx_id = (select max(ctt.customer_trx_id)
1942: from ra_customer_trx ctt,