APPS.ARP_CMREQ_WF dependencies on AR_COLLECTORS

Line 1005: from ar_collectors col, hz_customer_profiles cp

1001: select col.employee_id, cp.collector_id,
1002: col.name
1003: into p_collector_employee_id, p_collector_id,
1004: p_collector_name
1005: from ar_collectors col, hz_customer_profiles cp
1006: where cp.cust_account_id = p_customer_id
1007: and cp.site_use_id = p_bill_to_site_use_id
1008: and cp.collector_id = col.collector_id ;
1009:

Line 1025: from ar_collectors col,

1021: col.name
1022: into p_collector_employee_id,
1023: p_collector_id,
1024: p_collector_name
1025: from ar_collectors col,
1026: hz_customer_profiles cp_cust
1027: where cp_cust.cust_account_id = p_customer_id
1028: and cp_cust.site_use_id IS NULL
1029: and cp_cust.collector_id = col.collector_id ;