DBA Data[Home] [Help]

APPS.AR_BPA_UTILS_PKG dependencies on HZ_CUST_PROFILE_CLASSES

Line 114: hz_cust_profile_classes hzc

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
118: and hzp.profile_class_id = hzc.profile_class_id;

Line 124: hz_cust_profile_classes hzc

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
128: and hzp.profile_class_id = hzc.profile_class_id;