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 1695: FROM ra_customer_trx_all

1691: SELECT org_id
1692: , primary_salesrep_id
1693: INTO g_org_id
1694: , g_sales_repid
1695: FROM ra_customer_trx_all
1696: WHERE customer_trx_id = adjusted_doc_trx_id_tab(i);
1697: EXCEPTION
1698: WHEN OTHERS THEN
1699: g_org_id := internal_org_id_tab(i);

Line 1724: FROM ra_customer_trx_all

1720: SELECT org_id
1721: , primary_salesrep_id
1722: INTO g_org_id
1723: , g_sales_repid
1724: FROM ra_customer_trx_all
1725: WHERE customer_trx_id = trx_id_tab(i);
1726: EXCEPTION
1727: WHEN OTHERS THEN
1728: g_org_id := internal_org_id_tab(i);