1436: we will use the customer level profile. If the AR: Use Late Charges Profile is set to
1437: No, we will use the individual profiles defined for the corresponding bill to sites.
1438: If no profiles exist, we will use the customer level profile. */
1439:
1440: l_use_late_charge_site := nvl(FND_PROFILE.value('AR_USE_STATEMENTS_AND_DUNNING_SITE_PROFILE'),'N');
1441:
1442: /* Bug fix 5384500 */
1443: IF l_customer_name_from IS NOT NULL AND l_customer_name_to IS NULL THEN
1444: l_customer_name_where := 'AND party.party_name >= :l_customer_name_from ';