DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on RA_SALESREPS

Line 559: l_salesrep_name ra_salesreps.name%TYPE;

555: l_collector ar_collectors.name%TYPE;
556: l_payment_method_name ar_receipt_methods.name%TYPE;
557: l_days_late NUMBER;
558: l_billto_contact varchar2(150);
559: l_salesrep_name ra_salesreps.name%TYPE;
560: BEGIN
561: IF PG_DEBUG in ('Y', 'C') THEN
562: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.clear_invoice_pay_info()+' );
563: END IF;

Line 634: ra_salesreps RA_SALES

630: FROM ra_customer_trx CT,
631: hz_cust_account_roles RACO_BILL,
632: hz_parties RACO_BILL_PARTY,
633: hz_relationships RACO_BILL_REL,
634: ra_salesreps RA_SALES
635: WHERE ct.bill_to_contact_id = raco_bill.cust_account_role_id(+)
636: and raco_bill.party_id = raco_bill_rel.party_id(+)
637: and raco_bill_rel.subject_table_name(+) = 'HZ_PARTIES'
638: and raco_bill_rel.object_table_name(+) = 'HZ_PARTIES'