DBA Data[Home] [Help]

APPS.MST_WB_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 568: hz_cust_accounts hzc

564: CURSOR chk_cust_site(p_location_id IN NUMBER, p_owner_party_id IN NUMBER) IS
565: SELECT 1
566: FROM hz_cust_acct_sites_all hzcasa,
567: hz_party_sites hzps,
568: hz_cust_accounts hzc
569: WHERE hzc.party_id = hzps.party_id
570: AND hzps.location_id = p_location_id
571: AND hzps.party_site_id = hzcasa.party_site_id
572: AND hzcasa.cust_account_id = hzc.cust_account_id

Line 670: FROM HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HCA

666: RETURN VARCHAR2 IS
667:
668: CURSOR CUR_PARTY_NAME( P_PARTY_ID IN NUMBER ) IS
669: SELECT HZP.PARTY_NAME
670: FROM HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HCA
671: WHERE HCA.CUST_ACCOUNT_ID = P_party_id
672: AND HCA.PARTY_ID = HZP.PARTY_ID;
673:
674: CURSOR CUR_VENDOR_NAME( P_PARTY_ID IN NUMBER ) IS