DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on HZ_CUST_ACCOUNTS_ALL

Line 3119: FROM hz_cust_accounts_all

3115: ;
3116:
3117: CURSOR c_cust IS
3118: SELECT 1
3119: FROM hz_cust_accounts_all
3120: WHERE cust_account_id = p_sample.cust_id
3121: ;
3122:
3123: -- Bug 4165704: took this check out since gl_plcy_mst no longer exists

Line 3134: hz_cust_accounts_all c

3130: CURSOR c_ship_to IS
3131: SELECT 1
3132: FROM hz_cust_acct_sites_all a,
3133: hz_cust_site_uses_all s,
3134: hz_cust_accounts_all c
3135: WHERE a.cust_acct_site_id = s.cust_acct_site_id
3136: AND a.org_id = s.org_id
3137: AND a.cust_account_id = c.cust_account_id
3138: AND c.cust_account_id = p_sample.cust_id

Line 5253: FROM hz_cust_accounts_all a,

5249: WHERE line_id = p_order_line_id ;
5250:
5251: CURSOR Cur_get_cust IS
5252: SELECT p.party_name /* cust_name */
5253: FROM hz_cust_accounts_all a,
5254: hz_parties p
5255: WHERE a.cust_account_id = p_cust_id
5256: AND a.party_id = p.party_id;
5257: