DBA Data[Home] [Help]

APPS.WSH_WF_STD dependencies on HZ_PARTIES

Line 133: hz_parties party,

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

Line 406: hz_parties party,

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