APPS.ECE_CDMO_UTIL dependencies on RA_REMIT_TOS

Line 208: FROM RA_CUSTOMER_TRX RCT,HZ_CUST_ACCT_SITES A,RA_REMIT_TOS RT,

204: DECLARE
205: -- bug 4718847
206: CURSOR remit_cur IS
207: SELECT RT.ADDRESS_ID
208: FROM RA_CUSTOMER_TRX RCT,HZ_CUST_ACCT_SITES A,RA_REMIT_TOS RT,
209: HZ_PARTY_SITES HPS,HZ_LOCATIONS LOC
210: WHERE RCT.CUSTOMER_TRX_ID = get_remit_address.customer_trx_id
211: AND RCT.BILL_TO_ADDRESS_ID = A.CUST_ACCT_SITE_ID
212: AND A.PARTY_SITE_ID = HPS.PARTY_SITE_ID

Line 258: FROM RA_REMIT_TOS

254: IF l_remit_to_address_id IS NULL THEN
255: xProgress := '2020-30';
256:
257: SELECT MIN(ADDRESS_ID) INTO l_remit_to_address_id
258: FROM RA_REMIT_TOS
259: WHERE STATUS='A'
260: AND STATE = 'DEFAULT'
261: AND COUNTRY = 'DEFAULT';
262: