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