DBA Data[Home] [Help]

APPS.WSH_BATCH_PROCESS dependencies on HZ_CUST_ACCOUNTS

Line 2866: FROM hz_parties Party, hz_cust_accounts cust_acct

2862: IS
2863: --TCA View Changes Start
2864: CURSOR get_customer_name(c_customer_id NUMBER) IS
2865: SELECT substrb ( party.party_name, 1, 50 ) customer_name
2866: FROM hz_parties Party, hz_cust_accounts cust_acct
2867: WHERE cust_acct.party_id = party.party_id AND
2868: cust_acct.cust_account_id = c_customer_id;
2869: --TCA View Changes end
2870:

Line 3552: FROM hz_parties Party, hz_cust_accounts cust_acct

3548:
3549: --TCA View Changes Start
3550: CURSOR get_customer_name(c_customer_id NUMBER) IS
3551: SELECT substrb ( party.party_name, 1, 50 ) customer_name
3552: FROM hz_parties Party, hz_cust_accounts cust_acct
3553: WHERE cust_acct.party_id = party.party_id AND
3554: cust_acct.cust_account_id = c_customer_id;
3555: --TCA View Changes end
3556: