APPS.IBY_FNDCPT_COMMON_PUB dependencies on HZ_CUST_ACCOUNTS

Line 16: ci_cust_acct_id IN hz_cust_accounts.cust_account_id%TYPE

12: l_count NUMBER;
13:
14: CURSOR c_cust_acct
15: (ci_party_id IN hz_parties.party_id%TYPE,
16: ci_cust_acct_id IN hz_cust_accounts.cust_account_id%TYPE
17: )
18: IS
19: SELECT COUNT(cust_account_id)
20: FROM hz_cust_accounts

Line 20: FROM hz_cust_accounts

16: ci_cust_acct_id IN hz_cust_accounts.cust_account_id%TYPE
17: )
18: IS
19: SELECT COUNT(cust_account_id)
20: FROM hz_cust_accounts
21: WHERE (cust_account_id = ci_cust_acct_id)
22: AND ( (party_id = ci_party_id)
23: OR ci_party_id IN
24: ( SELECT DISTINCT a.party_id

Line 26: hz_cust_accounts b, hz_party_preferences c

22: AND ( (party_id = ci_party_id)
23: OR ci_party_id IN
24: ( SELECT DISTINCT a.party_id
25: FROM hz_cust_account_roles a,
26: hz_cust_accounts b, hz_party_preferences c
27: WHERE (b.cust_account_id = ci_cust_acct_id)
28: AND (NVL(a.status,'A')= 'A')
29: AND (NVL(b.status, 'A') = 'A')
30: AND (a.cust_account_id = b.cust_account_id)

Line 39: ci_cust_acct_id IN hz_cust_accounts.cust_account_id%TYPE,

35: );
36:
37: CURSOR c_site_use
38: (ci_party_id IN hz_parties.party_id%TYPE,
39: ci_cust_acct_id IN hz_cust_accounts.cust_account_id%TYPE,
40: ci_cust_site_id IN hz_cust_site_uses_all.site_use_id%TYPE
41: )
42: IS
43: SELECT COUNT(site_use_id)

Line 45: hz_cust_accounts a

41: )
42: IS
43: SELECT COUNT(site_use_id)
44: FROM hz_cust_site_uses_all u, hz_cust_acct_sites_all s,
45: hz_cust_accounts a
46: WHERE (u.site_use_id = ci_cust_site_id)
47: AND (a.cust_account_id = ci_cust_acct_id)
48: AND (u.cust_acct_site_id = s.cust_acct_site_id)
49: AND (s.cust_account_id = a.cust_account_id);