APPS.AR_CALC_LATE_CHARGE dependencies on HZ_CUSTOMER_PROFILES

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

759:
760: /*=======================================================================+
761: If a given site is defined as a Bill To and a Late Charges site, the
762: site_use_id associated with the Bill To Site use will be stored in
763: hz_customer_profiles. Otherwise, the site_use_id associated with the
764: Late Charges site use will be stored in hz_customer_profiles. This
765: function returns the appropriate site_use_id to be joined with the
766: hz_customer_profiles to get the profile set up
767: =======================================================================*/

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

760: /*=======================================================================+
761: If a given site is defined as a Bill To and a Late Charges site, the
762: site_use_id associated with the Bill To Site use will be stored in
763: hz_customer_profiles. Otherwise, the site_use_id associated with the
764: Late Charges site use will be stored in hz_customer_profiles. This
765: function returns the appropriate site_use_id to be joined with the
766: hz_customer_profiles to get the profile set up
767: =======================================================================*/
768:

Line 766: hz_customer_profiles to get the profile set up

762: site_use_id associated with the Bill To Site use will be stored in
763: hz_customer_profiles. Otherwise, the site_use_id associated with the
764: Late Charges site use will be stored in hz_customer_profiles. This
765: function returns the appropriate site_use_id to be joined with the
766: hz_customer_profiles to get the profile set up
767: =======================================================================*/
768:
769: Function get_profile_class_site_use_id(
770: p_site_use_id IN NUMBER,

Line 781: from hz_customer_profiles

777: if found, regardless of it's site_use_code, return that site_use_id */
778:
779: select site_use_id
780: into l_profile_class_site_use_id
781: from hz_customer_profiles
782: where site_use_id = p_site_use_id;
783:
784: return l_profile_class_site_use_id;
785:

Line 790: from hz_customer_profiles

786: EXCEPTION WHEN NO_DATA_FOUND THEN
787: BEGIN
788: select site_use_id
789: into l_profile_class_site_use_id
790: from hz_customer_profiles
791: where site_use_id in ( select site_use_id
792: from hz_cust_site_uses
793: where cust_acct_site_id =
794: ( SELECT cust_acct_site_id

Line 807: from hz_customer_profiles

803: WHEN TOO_MANY_ROWS THEN
804: BEGIN
805: select site_use_id
806: into l_profile_class_site_use_id
807: from hz_customer_profiles
808: where site_use_id in ( select site_use_id
809: from hz_cust_site_uses
810: where cust_acct_site_id =
811: ( SELECT cust_acct_site_id

Line 1626: hz_customer_profiles profiles,

1622: ar_transaction_history th,
1623: ra_customer_trx trx,
1624: hz_cust_accounts cust_acct,
1625: hz_parties party,
1626: hz_customer_profiles profiles,
1627: hz_cust_profile_amts prof_amts,
1628: hz_cust_site_uses site_use,
1629: ar_system_parameters sysparam
1630: WHERE cust_acct.party_id = party.party_id