109: FUNCTION fn_get_profile_class_name ( p_customer_trx_id IN number ) return varchar2 AS
110: cursor c_profileclass1 is
111: select hzc.name
112: from ra_customer_trx trx,
113: hz_customer_profiles hzp,
114: hz_cust_profile_classes hzc
115: where trx.customer_trx_id = p_customer_trx_id
116: and trx.bill_to_customer_id = hzp.cust_account_id
117: and trx.bill_to_site_use_id = hzp.site_use_id
119:
120: cursor c_profileclass2 is
121: select hzc.name
122: from ra_customer_trx trx,
123: hz_customer_profiles hzp,
124: hz_cust_profile_classes hzc
125: where trx.customer_trx_id = p_customer_trx_id
126: and trx.bill_to_customer_id = hzp.cust_account_id
127: and hzp.site_use_id is null
152:
153: FUNCTION fn_get_tax_printing_option ( p_bill_to_site_use_id IN number, p_bill_to_customer_id in number ) return varchar2 AS
154: cursor c_tax_printing_option1 is
155: select cp_site.tax_printing_option
156: from hz_customer_profiles cp_site
157: where cp_site.site_use_id = p_bill_to_site_use_id
158: and cp_site.cust_account_id = p_bill_to_customer_id;
159:
160: cursor c_tax_printing_option2 is
158: and cp_site.cust_account_id = p_bill_to_customer_id;
159:
160: cursor c_tax_printing_option2 is
161: select cp_cust.tax_printing_option
162: from hz_customer_profiles cp_cust
163: where cp_cust.cust_account_id = p_bill_to_customer_id
164: and cp_cust.site_use_id is null;
165:
166: cursor c_tax_printing_option3 is
165:
166: cursor c_tax_printing_option3 is
167: SELECT tax_invoice_print from AR_SYSTEM_PARAMETERS;
168:
169: l_tax_printing_option hz_customer_profiles.tax_printing_option%TYPE := null;
170: BEGIN
171: FOR crec in c_tax_printing_option1
172: LOOP
173: l_tax_printing_option := crec.tax_printing_option;