APPS.CSFW_TASKS_PUB dependencies on HZ_PARTY_SITE_USES

Line 1125: from hz_party_sites a, hz_party_site_uses b ,csi_i_parties c

1121: cursor c_bill_to_ship_to (v_instance_id number, v_type varchar2) is
1122: SELECT
1123: c.party_id party_id,
1124: nvl(a.party_site_id , 0) party_site_id
1125: from hz_party_sites a, hz_party_site_uses b ,csi_i_parties c
1126: where a.party_id(+) = c.party_id
1127: and c.RELATIONSHIP_TYPE_CODE = v_type
1128: and c.instance_id = v_instance_id
1129: and b.party_site_id(+) = a.party_site_id