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 606: from hz_cust_accounts hca,

602: IS
603:
604: Cursor default_payment_term_customer(l_cust_account_id NUMBER) Is
605: select hcp.standard_terms
606: from hz_cust_accounts hca,
607: hz_customer_profiles hcp
608: where hcp.cust_account_id = hca.cust_account_id
609: and hca.cust_account_id = l_cust_account_id
610: and nvl(hcp.status,'A') = 'A';

Line 1944: l_ret_value HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;

1940: P_Attribute_Code IN VARCHAR2) RETURN VARCHAR2
1941:
1942: IS
1943:
1944: l_ret_value HZ_CUST_ACCOUNTS.DATE_TYPE_PREFERENCE%TYPE;
1945: l_acct_id NUMBER;
1946:
1947: CURSOR C_Get_RDT (l_acct NUMBER) IS
1948: SELECT date_type_preference

Line 1949: FROM HZ_CUST_ACCOUNTS

1945: l_acct_id NUMBER;
1946:
1947: CURSOR C_Get_RDT (l_acct NUMBER) IS
1948: SELECT date_type_preference
1949: FROM HZ_CUST_ACCOUNTS
1950: WHERE Cust_Account_Id = l_acct
1951: AND Status = 'A';
1952:
1953: BEGIN