APPS.IGR_INQUIRY_PKG dependencies on HZ_PARTY_SITES
Line 99: FROM hz_party_sites
95: ddp_sales_lead_contact_tbl as_sales_leads_pub.sales_lead_contact_tbl_type;
96:
97: CURSOR c_primary_address IS
98: SELECT party_site_id 99: FROM hz_party_sites 100: WHERE identifying_address_flag = 'Y'
101: AND status = 'A'
102: AND party_id = x_person_id;
103: