APPS.CSFW_TASKS_PUB dependencies on HZ_PARTY_SITE_USES

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

1104: cursor c_bill_to_ship_to (v_instance_id number, v_type varchar2) is
1105: SELECT
1106: c.party_id party_id,
1107: nvl(a.party_site_id , 0) party_site_id
1108: from hz_party_sites a, hz_party_site_uses b ,csi_i_parties c
1109: where a.party_id(+) = c.party_id
1110: and c.RELATIONSHIP_TYPE_CODE = v_type
1111: and c.instance_id = v_instance_id
1112: and b.party_site_id(+) = a.party_site_id