APPS.CS_STD dependencies on HZ_PARTIES

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

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

Line 339: l_cust_name hz_parties.party_name%type;

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

Line 347: from hz_parties

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