DBA Data[Home] [Help]

APPS.IBY_FNDCPT_COMMON_PUB dependencies on HZ_PARTIES

Line 15: (ci_party_id IN hz_parties.party_id%TYPE,

11: IS
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)

Line 38: (ci_party_id IN hz_parties.party_id%TYPE,

34: )
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