APPS.ZX_TAXWARE_USER_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 28: g_org_id RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE;

24: l_view_name VARCHAR2(200);
25: i PLS_INTEGER;
26: g_in_out_flag VARCHAR2(1); -- Bug 5506031
27: g_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
28: g_org_id RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE;
29: g_sales_repid RA_CUSTOMER_TRX_ALL.primary_salesrep_id%TYPE;
30:
31: TYPE party_id_tbl_type is table of NUMBER index by VARCHAR2(100);
32: p_party_id_tbl party_id_tbl_type;

Line 29: g_sales_repid RA_CUSTOMER_TRX_ALL.primary_salesrep_id%TYPE;

25: i PLS_INTEGER;
26: g_in_out_flag VARCHAR2(1); -- Bug 5506031
27: g_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
28: g_org_id RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE;
29: g_sales_repid RA_CUSTOMER_TRX_ALL.primary_salesrep_id%TYPE;
30:
31: TYPE party_id_tbl_type is table of NUMBER index by VARCHAR2(100);
32: p_party_id_tbl party_id_tbl_type;
33:

Line 1558: FROM ra_customer_trx_all

1554: SELECT org_id
1555: , primary_salesrep_id
1556: INTO g_org_id
1557: , g_sales_repid
1558: FROM ra_customer_trx_all
1559: WHERE customer_trx_id = adjusted_doc_trx_id_tab(i);
1560: EXCEPTION
1561: WHEN OTHERS THEN
1562: g_org_id := internal_org_id_tab(i);

Line 1573: FROM ra_customer_trx_all

1569: SELECT org_id
1570: , primary_salesrep_id
1571: INTO g_org_id
1572: , g_sales_repid
1573: FROM ra_customer_trx_all
1574: WHERE customer_trx_id = trx_id_tab(i);
1575: EXCEPTION
1576: WHEN OTHERS THEN
1577: g_org_id := internal_org_id_tab(i);