APPS.CSTPMRGL dependencies on HZ_CUST_ACCOUNTS

Line 1449: FROM hz_cust_accounts

1445:
1446: UPDATE CST_MARGIN_SUMMARY temp
1447: SET customer_class_code =
1448: (SELECT customer_class_code
1449: FROM hz_cust_accounts
1450: WHERE cust_account_id = temp.customer_id)
1451: WHERE
1452: customer_id is not null
1453: and gl_date between l_from_date and l_to_date

Line 1467: FROM hz_cust_accounts hca,

1463: LOOP
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:

Line 1488: FROM hz_cust_accounts hca,

1484:
1485: UPDATE CST_MARGIN_SUMMARY temp
1486: SET bill_to_customer_name =
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

Line 1514: FROM hz_cust_accounts hca,

1510:
1511: UPDATE CST_MARGIN_SUMMARY temp
1512: SET ship_to_customer_name =
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