DBA Data[Home] [Help]

APPS.WSH_WF_STD dependencies on HZ_CUST_ACCOUNTS

Line 134: hz_cust_accounts cust_acct,

130: CURSOR get_customer_name(p_delivery_id IN NUMBER) IS
131: SELECT substrb(party.party_name,1,50)
132: FROM
133: hz_parties party,
134: hz_cust_accounts cust_acct,
135: wsh_new_deliveries wnd
136: WHERE
137: cust_acct.cust_account_id = wnd.customer_id and
138: cust_acct.party_id = party.party_id and

Line 407: hz_cust_accounts cust_acct,

403: CURSOR get_customer_name(p_delivery_id IN NUMBER) IS
404: SELECT substrb(party.party_name,1,50)
405: FROM
406: hz_parties party,
407: hz_cust_accounts cust_acct,
408: wsh_new_deliveries wnd
409: WHERE
410: cust_acct.cust_account_id = wnd.customer_id and
411: cust_acct.party_id = party.party_id and