APPS.ARP_DISCOUNTS_API dependencies on HZ_CUSTOMER_PROFILES

Line 108: FROM hz_customer_profiles

104: if l_site_use_id is NOT NULL then
105: BEGIN
106: SELECT NVL(discount_grace_days, 0)
107: INTO l_grace_days
108: FROM hz_customer_profiles
109: WHERE cust_account_id = l_customer_id
110: AND site_use_id = l_site_use_id;
111: EXCEPTION
112: WHEN NO_DATA_FOUND THEN

Line 127: FROM hz_customer_profiles

123:
124: IF ( l_site_use_id IS NULL OR NOT l_site_level_profile ) THEN
125: SELECT NVL(discount_grace_days, 0)
126: INTO l_grace_days
127: FROM hz_customer_profiles
128: WHERE cust_account_id = l_customer_id
129: AND site_use_id IS NULL;
130: end if;
131:

Line 329: FROM hz_customer_profiles

325: if (p_grace_days_flag = 'Y') then
326: if l_site_use_id is NOT NULL then
327: SELECT NVL(discount_grace_days, 0)
328: INTO l_grace_days
329: FROM hz_customer_profiles
330: WHERE cust_account_id = l_customer_id
331: AND site_use_id = l_site_use_id;
332: else
333: SELECT NVL(discount_grace_days, 0)

Line 335: FROM hz_customer_profiles

331: AND site_use_id = l_site_use_id;
332: else
333: SELECT NVL(discount_grace_days, 0)
334: INTO l_grace_days
335: FROM hz_customer_profiles
336: WHERE cust_account_id = l_customer_id;
337: end if;
338:
339: else