APPS.ARP_CORRECT_CC_ERRORS dependencies on HZ_CUSTOMER_PROFILES

Line 143: FROM hz_customer_profiles prof

139: IF PG_DEBUG in ('Y', 'C') THEN
140: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()+' );
141: END IF;
142: SELECT prof.collector_id INTO l_collector_id
143: FROM hz_customer_profiles prof
144: WHERE prof.cust_account_id = p_customer_id AND
145: prof.site_use_id = p_customer_site_use_id;
146:
147: SELECT name

Line 159: FROM hz_customer_profiles prof

155: RETURN l_collector_name;
156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN
158: SELECT prof.collector_id INTO l_collector_id
159: FROM hz_customer_profiles prof
160: WHERE prof.cust_account_id = p_customer_id AND
161: prof.site_use_id is NULL;
162:
163: SELECT name