DBA Data[Home] [Help]

APPS.OKL_ASSET_SUBSIDY_PVT dependencies on HZ_CUST_ACCOUNTS_ALL

Line 1355: hz_cust_accounts_all hca,

1351: cursor l_sic_csr (p_subsidy_id in number,
1352: p_asset_cle_id in number) is
1353: select 'Y'
1354: from hz_parties hp,
1355: hz_cust_accounts_all hca,
1356: okc_k_lines_b cleb,
1357: okc_k_headers_b chrb,
1358: okl_subsidy_criteria suc
1359: where hp.party_id = hca.party_id

Line 1908: hz_cust_accounts_all hca,

1904: cursor l_sic_csr (p_subsidy_id in number,
1905: p_chr_id in number) is
1906: select 'Y'
1907: from hz_parties hp,
1908: hz_cust_accounts_all hca,
1909: okc_k_headers_b chrb,
1910: okl_subsidy_criteria suc
1911: where hp.party_id = hca.party_id
1912: And hca.CUST_ACCOUNT_ID = chrb.cust_acct_id

Line 2463: hz_cust_accounts_all hca,

2459: cursor l_sic_csr (p_subsidy_id in number,
2460: p_cust_account_id in number) is
2461: select 'Y'
2462: from hz_parties hp,
2463: hz_cust_accounts_all hca,
2464: okl_subsidy_criteria suc
2465: where hp.party_id = hca.party_id
2466: And hca.CUST_ACCOUNT_ID = p_cust_account_id
2467: And SUC.subsidy_id = p_subsidy_id