APPS.AR_AME_CM_ATTRIBUTES_API dependencies on AR_COLLECTORS

Line 130: FROM ar_collectors col,

126: -- cursor to return site level first in cases where both site and header, the code will use
127: -- the first value returned
128: CURSOR coll_id (p_customer_id NUMBER, p_bill_to_use_id NUMBER) IS
129: SELECT 'person_id:' || col.employee_id, cp.site_use_id
130: FROM ar_collectors col,
131: hz_customer_profiles cp
132: WHERE cp.collector_id = col.collector_id
133: AND cp.cust_account_id = p_customer_id
134: AND (cp.site_use_id = p_bill_to_use_id

Line 145: -- l_collector_id ar_collectors.employee_id%TYPE;

141:
142:
143: l_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
144: l_bill_to_use_id ra_customer_trx.bill_to_site_use_id%TYPE;
145: -- l_collector_id ar_collectors.employee_id%TYPE;
146: l_collector_id VARCHAR2(50);
147: l_site_use_id VARCHAR2(50);
148:
149: BEGIN