DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on HZ_CUST_ACCOUNTS_ALL

Line 3714: FROM hz_cust_accounts_all

3710: ;
3711:
3712: CURSOR c_cust IS
3713: SELECT 1
3714: FROM hz_cust_accounts_all
3715: WHERE cust_account_id = p_sample.cust_id
3716: ;
3717:
3718: -- Bug 4165704: took this check out since gl_plcy_mst no longer exists

Line 3729: hz_cust_accounts_all c

3725: CURSOR c_ship_to IS
3726: SELECT 1
3727: FROM hz_cust_acct_sites_all a,
3728: hz_cust_site_uses_all s,
3729: hz_cust_accounts_all c
3730: WHERE a.cust_acct_site_id = s.cust_acct_site_id
3731: AND a.org_id = s.org_id
3732: AND a.cust_account_id = c.cust_account_id
3733: AND c.cust_account_id = p_sample.cust_id

Line 5921: FROM hz_cust_accounts_all a,

5917: WHERE line_id = p_order_line_id ;
5918:
5919: CURSOR Cur_get_cust IS
5920: SELECT p.party_name /* cust_name */
5921: FROM hz_cust_accounts_all a,
5922: hz_parties p
5923: WHERE a.cust_account_id = p_cust_id
5924: AND a.party_id = p.party_id;
5925: