APPS.ZX_VTX_USER_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 1964: l_sales_repid RA_CUSTOMER_TRX_ALL.primary_salesrep_id%TYPE;

1960: PROCEDURE DERIVE_POA_ADDRESS_CODE
1961: IS
1962: l_poa_geocode VARCHAR2(10);
1963: l_poa_in_out_flag VARCHAR2(1);
1964: l_sales_repid RA_CUSTOMER_TRX_ALL.primary_salesrep_id%TYPE;
1965:
1966: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_POA_ADDRESS_CODE';
1967:
1968: BEGIN

Line 1982: FROM ra_customer_trx_all

1978: ELSE
1979: BEGIN
1980: SELECT primary_salesrep_id
1981: INTO l_sales_repid
1982: FROM ra_customer_trx_all
1983: WHERE customer_trx_id = adjusted_doc_trx_id_tab(i);
1984: EXCEPTION
1985: WHEN NO_DATA_FOUND THEN
1986: l_sales_repid := NULL;

Line 2003: FROM ra_customer_trx_all

1999: ELSE
2000: BEGIN
2001: SELECT primary_salesrep_id
2002: INTO l_sales_repid
2003: FROM ra_customer_trx_all
2004: WHERE customer_trx_id = trx_id_tab(i);
2005: EXCEPTION
2006: WHEN NO_DATA_FOUND THEN
2007: l_sales_repid := NULL;