12:
13: -- Segment and buying group has no acct info. use party_id for validation
14: CURSOR c_party_id IS
15: SELECT party_id
16: FROM hz_cust_accounts
17: WHERE cust_account_id = p_sold_to_org_id;
18:
19: CURSOR c_customer_qualified(p_party_id NUMBER) IS
20: SELECT 'Y'
75: RETURN VARCHAR2
76: IS
77: CURSOR c_party_id IS -- segment and buying group has no acct info. use party_id for validation
78: SELECT party_id
79: FROM hz_cust_accounts
80: WHERE cust_account_id = p_sold_to_org_id;
81:
82: CURSOR c_customer_qualified(p_party_id NUMBER) IS
83: SELECT 'Y'