APPS.OZF_CLAIM_PVT dependencies on HZ_CUST_ACCOUNTS

Line 384: , hz_cust_accounts c

380: p_party_relationship_id in number) is
381: SELECT p.party_id -- ,p.party_name
382: FROM hz_relationships r -- Bug 4654753
383: , hz_parties p
384: , hz_cust_accounts c
385: WHERE r.subject_id = p.party_id
386: AND r.relationship_id = p_party_relationship_id -- Bug 4654753
387: AND r.object_id = c.party_id
388: AND c.cust_account_id = p_cust_account_id;

Line 699: FROM hz_cust_accounts

695: WHERE cust_acct_site_id = p_site_id;
696:
697: CURSOR cust_account_info_csr(p_cust_account_id in number) is
698: SELECT party_id, sales_channel_code
699: FROM hz_cust_accounts
700: WHERE CUST_ACCOUNT_ID = p_cust_account_id;
701:
702: -- waiting for customer_class_code query
703: --CURSOR cust_account_info_csr(p_cust_account_id in number) is

Line 705: --FROM hz_cust_accounts

701:
702: -- waiting for customer_class_code query
703: --CURSOR cust_account_info_csr(p_cust_account_id in number) is
704: --SELECT party_id, customer_class_code, sales_channel_code
705: --FROM hz_cust_accounts
706: --WHERE CUST_ACCOUNT_ID = p_cust_account_id;
707:
708: CURSOR party_info_csr(p_party_id in number)is
709: SELECT category_code

Line 1498: FROM HZ_CUST_ACCOUNTS

1494:
1495: --Cursor to get the party_id of the customer.
1496: CURSOR get_party_id_csr( p_cust_account_id IN NUMBER )IS
1497: SELECT party_id
1498: FROM HZ_CUST_ACCOUNTS
1499: WHERE cust_account_id = p_cust_account_id;
1500:
1501:
1502: --Cursor to get the Threshold amounts from the customers

Line 1861: FROM HZ_CUST_ACCOUNTS H

1857: l_msg_count NUMBER;
1858:
1859: CURSOR c_party_id(p_cust_id in number) IS
1860: SELECT h.party_id
1861: FROM HZ_CUST_ACCOUNTS H
1862: WHERE h.cust_account_id = p_cust_id;
1863:
1864: BEGIN
1865:

Line 3362: FROM hz_cust_accounts

3358:
3359: -- This cursor get the account_name of a cust_acc. We might not need it.
3360: CURSOR cust_account_name_csr(p_customer_account_id in number) IS
3361: SELECT account_name
3362: FROM hz_cust_accounts
3363: WHERE cust_account_id = p_customer_account_id;
3364:
3365: /* CURSOR org_id_csr IS -- R12 Enhancements
3366: SELECT (TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 1, 10)))

Line 5294: FROM HZ_CUST_ACCOUNTS

5290: l_days_due number;
5291:
5292: CURSOR primary_sales_rep_id_csr(p_customer_account_id in number) IS
5293: SELECT primary_salesrep_id
5294: FROM HZ_CUST_ACCOUNTS
5295: WHERE cust_account_id = p_customer_account_id;
5296: l_sales_rep_id NUMBER;
5297:
5298: CURSOR user_status_id_csr (p_id in number) IS

Line 6733: hz_cust_accounts c

6729: p_party_id in number) IS
6730: SELECT count(p.party_id)
6731: FROM hz_parties p,
6732: hz_relationships r,
6733: hz_cust_accounts c
6734: WHERE p.party_id = r.subject_id
6735: AND r.relationship_code = p_relation_type
6736: AND r.object_id = c.party_id
6737: AND c.cust_account_id = p_cust_id

Line 6746: FROM hz_cust_accounts hca,

6742: CURSOR cust_site_csr(p_cust_id in number,
6743: p_site_use_code in varchar2,
6744: p_site_use_id in number) IS
6745: SELECT count(hcsu.site_use_id)
6746: FROM hz_cust_accounts hca,
6747: hz_cust_acct_sites hcas,
6748: hz_cust_site_uses hcsu
6749: WHERE hcas.cust_acct_site_id = hcsu.cust_acct_site_id
6750: AND hcas.cust_account_id = hca.cust_account_id

Line 7280: FROM hz_cust_accounts hca

7276: --l_number_of_reason_code_id number;
7277:
7278: CURSOR num_of_cust_acctid_csr(l_id in number) IS
7279: SELECT count(hca.cust_account_id)
7280: FROM hz_cust_accounts hca
7281: WHERE hca.cust_account_id = l_id;
7282: -- remove this condition for now AND hca.status = 'A'
7283:
7284: l_number_of_cust number;