APPS.ARP_CMREQ_WF dependencies on AR_COLLECTORS

Line 1046: from ar_collectors col, hz_customer_profiles cp

1042: select col.employee_id, cp.collector_id,
1043: col.name
1044: into p_collector_employee_id, p_collector_id,
1045: p_collector_name
1046: from ar_collectors col, hz_customer_profiles cp
1047: where cp.cust_account_id = p_customer_id
1048: and cp.site_use_id = p_bill_to_site_use_id
1049: and cp.collector_id = col.collector_id ;
1050:

Line 1066: from ar_collectors col,

1062: col.name
1063: into p_collector_employee_id,
1064: p_collector_id,
1065: p_collector_name
1066: from ar_collectors col,
1067: hz_customer_profiles cp_cust
1068: where cp_cust.cust_account_id = p_customer_id
1069: and cp_cust.site_use_id IS NULL
1070: and cp_cust.collector_id = col.collector_id ;