DBA Data[Home] [Help]

APPS.XNB_CMN_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 1657: HZ_CUSTOMER_PROFILES pfl,

1653: pfl.site_use_id
1654: INTO l_account_number,
1655: l_site_use_id
1656: FROM HZ_CUST_PROFILE_AMTS pfl_amnts,
1657: HZ_CUSTOMER_PROFILES pfl,
1658: hz_cust_accounts acc
1659: WHERE pfl_amnts.cust_account_id = acc.cust_account_id
1660: AND pfl.cust_account_profile_id = pfl_amnts.cust_account_profile_id
1661: AND pfl_amnts.CUST_ACCT_PROFILE_AMT_ID = l_param_value;

Line 1737: FROM hz_customer_profiles a,

1733: SELECT b.account_number,
1734: a.site_use_id
1735: INTO l_account_number,
1736: l_site_use_id
1737: FROM hz_customer_profiles a,
1738: hz_cust_accounts b
1739: WHERE a.cust_account_profile_id = l_param_value
1740: AND a.cust_account_id = b.cust_account_id;
1741: