DBA Data[Home] [Help]

APPS.ECE_AR_TRANSACTION dependencies on RA_REMIT_TOS

Line 555: ra_remit_tos rt

551: FROM ra_customer_trx rct,
552: hz_cust_acct_sites a,
553: hz_party_sites hps,
554: hz_locations loc,
555: ra_remit_tos rt
556: WHERE rct.customer_trx_id = Get_Remit_Address.Customer_Trx_ID
557: AND rct.bill_to_address_id = a.cust_acct_site_id AND
558: a.party_site_id = hps.party_site_id AND
559: hps.location_id = loc.location_id

Line 614: FROM ra_remit_tos

610: xProgress := '2020-30';
611: BEGIN
612: SELECT MIN(address_id)
613: INTO l_Remit_To_Address_ID
614: FROM ra_remit_tos
615: WHERE status = 'A'
616: AND state = 'DEFAULT'
617: AND country = 'DEFAULT';
618: EXCEPTION

Line 628: 'RA_REMIT_TOS' );

624: xProgress,
625: 'INFO',
626: 'MINIMUM ADDRESS ID',
627: 'TABLE_NAME',
628: 'RA_REMIT_TOS' );
629: END;
630:
631: ec_debug.pl ( 3, 'l_Remit_To_Address_ID: ', l_Remit_To_Address_ID );
632: