APPS.QOT_DEFAULT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 181: FROM HZ_CUST_ACCOUNTS

177: IS
178:
179: CURSOR C_Get_Acct_Count(l_party NUMBER) IS
180: SELECT count(rowid)
181: FROM HZ_CUST_ACCOUNTS
182: WHERE party_id = l_party
183: AND status = 'A'
184: AND trunc(sysdate) BETWEEN trunc(NVL(account_activation_date, sysdate))
185: AND trunc(NVL(account_termination_date, sysdate));

Line 189: FROM HZ_CUST_ACCOUNTS

185: AND trunc(NVL(account_termination_date, sysdate));
186:
187: CURSOR C_Get_Acct (l_party NUMBER) IS
188: SELECT Cust_Account_Id
189: FROM HZ_CUST_ACCOUNTS
190: WHERE Party_Id = l_party
191: AND status = 'A'
192: AND trunc(sysdate) BETWEEN trunc(NVL(account_activation_date, sysdate))
193: AND trunc(NVL(account_termination_date, sysdate));

Line 197: FROM HZ_CUST_ACCOUNTS

193: AND trunc(NVL(account_termination_date, sysdate));
194:
195: CURSOR C_oldest_Account(l_party NUMBER) IS
196: SELECT CUST_ACCOUNT_ID
197: FROM HZ_CUST_ACCOUNTS
198: WHERE Party_id = l_party
199: AND status = 'A'
200: AND trunc(sysdate) BETWEEN trunc(NVL(account_activation_date, sysdate)) AND
201: trunc(NVL(account_termination_date, sysdate))

Line 377: FROM HZ_CUST_ACCOUNTS

373: IS
374:
375: CURSOR C_Get_PL (l_acct NUMBER) IS
376: SELECT Price_List_Id
377: FROM HZ_CUST_ACCOUNTS
378: WHERE Cust_Account_Id = l_acct
379: AND Status = 'A';
380:
381: CURSOR C_Get_CustAcct(l_header_id NUMBER) IS

Line 611: from hz_cust_accounts hca,

607: */
608:
609: Cursor default_payment_term_customer(l_cust_account_id NUMBER) Is
610: select hcp.standard_terms
611: from hz_cust_accounts hca,
612: hz_customer_profiles hcp
613: where hcp.cust_account_id = hca.cust_account_id
614: and hca.cust_account_id = l_cust_account_id
615: and nvl(hcp.status,'A') = 'A'

Line 1958: l_ret_value HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;

1954: P_Attribute_Code IN VARCHAR2) RETURN VARCHAR2
1955:
1956: IS
1957:
1958: l_ret_value HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
1959: l_acct_id NUMBER;
1960:
1961: CURSOR C_Get_RDT (l_acct NUMBER) IS
1962: SELECT date_type_preference

Line 1963: FROM HZ_CUST_ACCOUNTS

1959: l_acct_id NUMBER;
1960:
1961: CURSOR C_Get_RDT (l_acct NUMBER) IS
1962: SELECT date_type_preference
1963: FROM HZ_CUST_ACCOUNTS
1964: WHERE Cust_Account_Id = l_acct
1965: AND Status = 'A';
1966:
1967: BEGIN