APPS.CSTPMRGL dependencies on HZ_CUST_ACCOUNTS

Line 1635: FROM hz_cust_accounts

1631:
1632: UPDATE CST_MARGIN_SUMMARY temp
1633: SET customer_class_code =
1634: (SELECT customer_class_code
1635: FROM hz_cust_accounts
1636: WHERE cust_account_id = temp.customer_id)
1637: WHERE
1638: customer_id is not null
1639: and gl_date between l_from_date and l_to_date

Line 1653: FROM hz_cust_accounts hca,

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

Line 1674: FROM hz_cust_accounts hca,

1670:
1671: UPDATE CST_MARGIN_SUMMARY temp
1672: SET bill_to_customer_name =
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

Line 1700: FROM hz_cust_accounts hca,

1696:
1697: UPDATE CST_MARGIN_SUMMARY temp
1698: SET ship_to_customer_name =
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