APPS.CSC_ROUTING_UTL dependencies on HZ_CUST_ACCOUNTS

Line 78: FROM hz_cust_accounts

74: -- get party ID given customer account number
75: --
76: CURSOR c_party_id (anum VARCHAR2) IS
77: SELECT party_id
78: FROM hz_cust_accounts
79: WHERE account_number = anum;
80: BEGIN
81:
82: OPEN c_party_id (p_cust_acct_number);

Line 1097: -- hz_cust_accounts

1093: --
1094: ------------------------------------------------------------------------------
1095: -- Procedure : Get_Cust_Acct_From_Account_Num
1096: -- Usage : Used to get Party_id,Cust_account_id,last_update_date from
1097: -- hz_cust_accounts
1098: -- Parameters :
1099: -- p_customer_account_number IN VARCHAR2(30) Required
1100: -- x_party_id OUT NOCOPY NUMBER(15)
1101: -- x_cust_account_id OUT NOCOPY NUMBER(15)

Line 1114: FROM hz_cust_accounts

1110: x_last_update_date OUT NOCOPY DATE) IS
1111:
1112: CURSOR c_party_id (anum VARCHAR2) IS
1113: SELECT party_id,cust_account_id,last_update_date
1114: FROM hz_cust_accounts
1115: WHERE account_number = anum;
1116: BEGIN
1117:
1118: OPEN c_party_id (p_cust_acct_number);