DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on RA_SALESREPS

Line 568: l_salesrep_name ra_salesreps.name%TYPE;

564: l_collector ar_collectors.name%TYPE;
565: l_payment_method_name ar_receipt_methods.name%TYPE;
566: l_days_late NUMBER;
567: l_billto_contact varchar2(150);
568: l_salesrep_name ra_salesreps.name%TYPE;
569: BEGIN
570: IF PG_DEBUG in ('Y', 'C') THEN
571: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()+' );
572: END IF;

Line 643: ra_salesreps RA_SALES

639: FROM ra_customer_trx CT,
640: hz_cust_account_roles RACO_BILL,
641: hz_parties RACO_BILL_PARTY,
642: hz_relationships RACO_BILL_REL,
643: ra_salesreps RA_SALES
644: WHERE ct.bill_to_contact_id = raco_bill.cust_account_role_id(+)
645: and raco_bill.party_id = raco_bill_rel.party_id(+)
646: and raco_bill_rel.subject_table_name(+) = 'HZ_PARTIES'
647: and raco_bill_rel.object_table_name(+) = 'HZ_PARTIES'