APPS.ARPT_SQL_FUNC_UTIL dependencies on RA_BATCH_SOURCES

Line 1033: ra_batch_sources bs

1029: '15', ct.interface_header_attribute15,
1030: NULL )
1031: INTO l_temp
1032: FROM ra_customer_trx ct,
1033: ra_batch_sources bs
1034: WHERE ct.rowid = p_trx_rowid and
1035: bs.batch_source_id = ct.batch_source_id;
1036: END IF;
1037:

Line 1099: ra_batch_sources bs

1095: NULL )
1096: INTO l_line_temp
1097: FROM ra_customer_trx_lines ctl,
1098: ra_customer_trx ct,
1099: ra_batch_sources bs
1100: WHERE bs.batch_source_id = ct.batch_source_id and
1101: ctl.customer_trx_id = ct.customer_trx_id and
1102: ctl.rowid = p_line_trx_rowid ;
1103: END IF;

Line 1831: l_bs_name ra_batch_sources.name%type;

1827: p_customer_trx_id IN number
1828: )
1829: RETURN VARCHAR2 is
1830:
1831: l_bs_name ra_batch_sources.name%type;
1832: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
1833:
1834: BEGIN
1835:

Line 1848: ra_batch_sources bs

1844:
1845: select bs.name
1846: into l_bs_name
1847: from ra_customer_trx ct,
1848: ra_batch_sources bs
1849: where ct.batch_source_id = bs.batch_source_id
1850: and ct.org_id = bs.org_id --anuj
1851: and ct.customer_trx_id = (select max(ctt.customer_trx_id)
1852: from ra_customer_trx ctt,