APPS.AST_UWQ_WRAPPER_PKG dependencies on HZ_PARTIES

Line 210: FROM Hz_parties

206: AND status = 'A';
207:
208: CURSOR C_Object_name(x_party_id NUMBER) IS
209: SELECT party_name
210: FROM Hz_parties
211: WHERE party_id = x_party_id;
212:
213: CURSOR c_get_address_id (x_party_id NUMBER, x_location_id NUMBER) IS
214: SELECT party_site_id

Line 223: and owner_table_name = 'HZ_PARTIES'

219: CURSOR c_phone_id(x_owner_table_id number) IS
220: SELECT contact_point_id
221: FROM hz_contact_points
222: WHERE owner_table_id = x_owner_table_id
223: and owner_table_name = 'HZ_PARTIES'
224: and contact_point_type = 'PHONE'
225: and status = 'A'
226: and primary_flag = 'Y';
227:

Line 728: FROM hz_parties

724: l_sales_methodology_id NUMBER := fnd_profile.value('AS_SALES_METHODOLOGY'); -- Updated by Sumita for bug # 4100911
725:
726: CURSOR c_close_comp(p_close_party_id in number) IS
727: SELECT party_name
728: FROM hz_parties
729: WHERE party_id = p_close_party_id;
730: BEGIN
731:
732: --To be removed once we are able to pass p_close_competitor

Line 1102: and owner_table_name = 'HZ_PARTIES'

1098: CURSOR c_phone_id(x_owner_table_id number) IS
1099: SELECT contact_point_id
1100: FROM hz_contact_points
1101: WHERE owner_table_id = x_owner_table_id
1102: and owner_table_name = 'HZ_PARTIES'
1103: and contact_point_type = 'PHONE'
1104: and primary_flag = 'Y';
1105:
1106: CURSOR C_GET_LEAD_NUMBER(p_sales_lead_id number) IS