APPS.ARP_CORRECT_CC_ERRORS dependencies on AR_COLLECTORS

Line 136: l_collector_name ar_collectors.name%TYPE;

132: FUNCTION get_collector_name (
133: p_customer_id IN NUMBER,
134: p_customer_site_use_id IN NUMBER)
135: RETURN VARCHAR2 IS
136: l_collector_name ar_collectors.name%TYPE;
137: l_collector_id NUMBER;
138: BEGIN
139: IF PG_DEBUG in ('Y', 'C') THEN
140: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()+' );

Line 149: FROM ar_collectors

145: prof.site_use_id = p_customer_site_use_id;
146:
147: SELECT name
148: INTO l_collector_name
149: FROM ar_collectors
150: WHERE collector_id = l_collector_id;
151:
152: IF PG_DEBUG in ('Y', 'C') THEN
153: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );

Line 165: FROM ar_collectors

161: prof.site_use_id is NULL;
162:
163: SELECT name
164: INTO l_collector_name
165: FROM ar_collectors
166: WHERE collector_id = l_collector_id;
167: IF PG_DEBUG in ('Y', 'C') THEN
168: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );
169: END IF;

Line 564: l_collector ar_collectors.name%TYPE;

560: l_customer_location hz_cust_site_uses.location%TYPE;
561: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
562: l_payment_trxn_extension_id ra_customer_trx.payment_trxn_extension_id%TYPE;
563: l_approval_code ra_customer_trx.approval_code%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;

Line 2276: l_collector ar_collectors.name%TYPE;

2272: l_customer_location hz_cust_site_uses.location%TYPE;
2273: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
2274: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
2275: l_approval_code ra_customer_trx.approval_code%TYPE;
2276: l_collector ar_collectors.name%TYPE;
2277: l_payment_method_name ar_receipt_methods.name%TYPE;
2278: PAY_exception EXCEPTION;
2279:
2280: BEGIN