APPS.PA_ASGMT_WFSTD dependencies on HZ_CUST_ACCOUNTS

Line 291: l_customer_id hz_cust_accounts.cust_account_id%TYPE;

287: l_customer_id ra_customers.customer_id%TYPE;
288: l_customer_name ra_customers.customer_name%TYPE;
289: */
290:
291: l_customer_id hz_cust_accounts.cust_account_id%TYPE;
292: l_customer_name hz_parties.party_name%TYPE;
293:
294: -- 4363092 end
295:

Line 4156: FROM hz_parties party, hz_cust_accounts cust_acct

4152: WHERE customer_id = l_customer_id;
4153: */
4154: CURSOR l_get_cust_csr IS
4155: SELECT substrb(party.party_name,1,50) customer_name
4156: FROM hz_parties party, hz_cust_accounts cust_acct
4157: WHERE cust_acct.cust_account_id = l_customer_id
4158: and cust_acct.party_id = party.party_id ;
4159: -- 4363092 end
4160: