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 4171: FROM hz_parties party, hz_cust_accounts cust_acct

4167: WHERE customer_id = l_customer_id;
4168: */
4169: CURSOR l_get_cust_csr IS
4170: SELECT substrb(party.party_name,1,50) customer_name
4171: FROM hz_parties party, hz_cust_accounts cust_acct
4172: WHERE cust_acct.cust_account_id = l_customer_id
4173: and cust_acct.party_id = party.party_id ;
4174: -- 4363092 end
4175: