APPS.CSTPMRGL dependencies on HZ_PARTIES

Line 1654: hz_parties hp

1650: FETCH sold_to_cust into l_rowid , l_cust_id ;
1651: EXIT WHEN sold_to_cust%NOTFOUND;
1652: SELECT SUBSTRB(hp.party_name,1,50) into l_cust_name
1653: FROM hz_cust_accounts hca,
1654: hz_parties hp
1655: WHERE hca.cust_account_id = l_cust_id
1656: AND hp.party_id = hca.party_id ;
1657:
1658: UPDATE CST_MARGIN_SUMMARY

Line 1677: hz_parties hp

1673: (SELECT SUBSTRB(hp.party_name,1,50)
1674: FROM hz_cust_accounts hca,
1675: hz_cust_site_uses_all hcsua,
1676: hz_cust_acct_sites_all hcasa,
1677: hz_parties hp
1678: WHERE
1679: NVL(hca.org_id, -999) = NVL(l_ou_id,NVL(hca.org_id, -999))
1680: and hca.cust_account_id = hcasa.cust_account_id
1681: and hp.party_id = hca.party_id

Line 1703: hz_parties hp

1699: (SELECT SUBSTRB(hp.party_name,1,50)
1700: FROM hz_cust_accounts hca,
1701: hz_cust_site_uses_all hcsua,
1702: hz_cust_acct_sites_all hcasa,
1703: hz_parties hp
1704: WHERE
1705: NVL(hca.org_id, -999) = NVL(l_ou_id,NVL(hca.org_id, -999))
1706: and hca.cust_account_id = hcasa.cust_account_id
1707: and hp.party_id = hca.party_id