DBA Data[Home] [Help]

APPS.IEX_CASE_OWNER_PUB dependencies on AR_COLLECTORS

Line 81: FROM hz_customer_profiles hp, jtf_rs_resource_extns rs,ar_collectors ac

77: --Begin bug#5246309 schekuri 29-Jun-2006
78: --Changed the query to get the resource from hz_customer_profiles
79: CURSOR c_party_resource(p_party_id NUMBER) IS
80: SELECT ac.resource_id,0
81: FROM hz_customer_profiles hp, jtf_rs_resource_extns rs,ar_collectors ac
82: WHERE hp.party_id = p_party_id
83: and rs.resource_id = ac.resource_id
84: and hp.collector_id = ac.collector_id
85: and hp.cust_account_id=-1