APPS.CS_STD dependencies on HZ_PARTIES

Line 334: -- 12/08/05 smisra replaced ra_customers with hz_parties

330: --Get the customer name.
331: --If p_error_flag is 'FALSE', then a NULL is returned if the PK is
332: --invalid. If p_error_flag is 'TRUE', the NO_DATA_FOUND exception is raised
333: --if the PK is invalid, and it is upto the calling code to handle it.
334: -- 12/08/05 smisra replaced ra_customers with hz_parties
335: function get_cust_name
336: (
337: p_customer_id number,
338: p_error_flag varchar2 default 'TRUE'

Line 340: l_cust_name hz_parties.party_name%type;

336: (
337: p_customer_id number,
338: p_error_flag varchar2 default 'TRUE'
339: ) return varchar2 is
340: l_cust_name hz_parties.party_name%type;
341: begin
342: if p_customer_id is null then
343: raise NO_DATA_FOUND;
344: end if;

Line 348: from hz_parties

344: end if;
345: --
346: select party_name
347: into l_cust_name
348: from hz_parties
349: where party_id = p_customer_id;
350: --
351: return(l_cust_name);
352: --