APPS.AR_CALC_LATE_CHARGE dependencies on HZ_CUSTOMER_PROFILES

Line 369: hz_customer_profiles. Otherwise, the site_use_id associated with the

365:
366: /*=======================================================================+
367: If a given site is defined as a Bill To and a Late Charges site, the
368: site_use_id associated with the Bill To Site use will be stored in
369: hz_customer_profiles. Otherwise, the site_use_id associated with the
370: Late Charges site use will be stored in hz_customer_profiles. This
371: function returns the appropriate site_use_id to be joined with the
372: hz_customer_profiles to get the profile set up
373: =======================================================================*/

Line 370: Late Charges site use will be stored in hz_customer_profiles. This

366: /*=======================================================================+
367: If a given site is defined as a Bill To and a Late Charges site, the
368: site_use_id associated with the Bill To Site use will be stored in
369: hz_customer_profiles. Otherwise, the site_use_id associated with the
370: Late Charges site use will be stored in hz_customer_profiles. This
371: function returns the appropriate site_use_id to be joined with the
372: hz_customer_profiles to get the profile set up
373: =======================================================================*/
374:

Line 372: hz_customer_profiles to get the profile set up

368: site_use_id associated with the Bill To Site use will be stored in
369: hz_customer_profiles. Otherwise, the site_use_id associated with the
370: Late Charges site use will be stored in hz_customer_profiles. This
371: function returns the appropriate site_use_id to be joined with the
372: hz_customer_profiles to get the profile set up
373: =======================================================================*/
374:
375: Function get_profile_class_site_use_id(
376: p_site_use_id IN NUMBER,

Line 387: from hz_customer_profiles

383: if found, regardless of it's site_use_code, return that site_use_id */
384:
385: select site_use_id
386: into l_profile_class_site_use_id
387: from hz_customer_profiles
388: where site_use_id = p_site_use_id;
389:
390: return l_profile_class_site_use_id;
391:

Line 396: from hz_customer_profiles

392: EXCEPTION WHEN NO_DATA_FOUND THEN
393: BEGIN
394: select site_use_id
395: into l_profile_class_site_use_id
396: from hz_customer_profiles
397: where site_use_id in ( select site_use_id
398: from hz_cust_site_uses
399: where cust_acct_site_id =
400: ( SELECT cust_acct_site_id

Line 413: from hz_customer_profiles

409: WHEN TOO_MANY_ROWS THEN
410: BEGIN
411: select site_use_id
412: into l_profile_class_site_use_id
413: from hz_customer_profiles
414: where site_use_id in ( select site_use_id
415: from hz_cust_site_uses
416: where cust_acct_site_id =
417: ( SELECT cust_acct_site_id

Line 1235: hz_customer_profiles profiles,

1231: ar_transaction_history th,
1232: ra_customer_trx trx,
1233: hz_cust_accounts cust_acct,
1234: hz_parties party,
1235: hz_customer_profiles profiles,
1236: hz_cust_profile_amts prof_amts,
1237: hz_cust_site_uses site_use,
1238: ar_system_parameters sysparam
1239: WHERE cust_acct.party_id = party.party_id