APPS.OKL_ASSET_SUBSIDY_PVT dependencies on HZ_PARTIES

Line 1337: from hz_parties hp,

1333: --cursor to check service industry code
1334: cursor l_sic_csr (p_subsidy_id in number,
1335: p_asset_cle_id in number) is
1336: select 'Y'
1337: from hz_parties hp,
1338: hz_cust_accounts_all hca,
1339: okc_k_lines_b cleb,
1340: okc_k_headers_b chrb,
1341: okl_subsidy_criteria suc

Line 1886: from hz_parties hp,

1882: --cursor to check service industry code
1883: cursor l_sic_csr (p_subsidy_id in number,
1884: p_chr_id in number) is
1885: select 'Y'
1886: from hz_parties hp,
1887: hz_cust_accounts_all hca,
1888: okc_k_headers_b chrb,
1889: okl_subsidy_criteria suc
1890: where hp.party_id = hca.party_id

Line 2441: from hz_parties hp,

2437: --cursor to check service industry code
2438: cursor l_sic_csr (p_subsidy_id in number,
2439: p_cust_account_id in number) is
2440: select 'Y'
2441: from hz_parties hp,
2442: hz_cust_accounts_all hca,
2443: okl_subsidy_criteria suc
2444: where hp.party_id = hca.party_id
2445: And hca.CUST_ACCOUNT_ID = p_cust_account_id