APPS.CSTPMRGL dependencies on HZ_PARTIES

Line 1468: hz_parties hp

1464: FETCH sold_to_cust into l_rowid , l_cust_id ;
1465: EXIT WHEN sold_to_cust%NOTFOUND;
1466: SELECT SUBSTRB(hp.party_name,1,50) into l_cust_name
1467: FROM hz_cust_accounts hca,
1468: hz_parties hp
1469: WHERE hca.cust_account_id = l_cust_id
1470: AND hp.party_id = hca.party_id ;
1471:
1472: UPDATE CST_MARGIN_SUMMARY

Line 1491: hz_parties hp

1487: (SELECT SUBSTRB(hp.party_name,1,50)
1488: FROM hz_cust_accounts hca,
1489: hz_cust_site_uses_all hcsua,
1490: hz_cust_acct_sites_all hcasa,
1491: hz_parties hp
1492: WHERE
1493: NVL(hca.org_id, -999) = NVL(l_ou_id,NVL(hca.org_id, -999))
1494: and hca.cust_account_id = hcasa.cust_account_id
1495: and hp.party_id = hca.party_id

Line 1517: hz_parties hp

1513: (SELECT SUBSTRB(hp.party_name,1,50)
1514: FROM hz_cust_accounts hca,
1515: hz_cust_site_uses_all hcsua,
1516: hz_cust_acct_sites_all hcasa,
1517: hz_parties hp
1518: WHERE
1519: NVL(hca.org_id, -999) = NVL(l_ou_id,NVL(hca.org_id, -999))
1520: and hca.cust_account_id = hcasa.cust_account_id
1521: and hp.party_id = hca.party_id