APPS.OKL_REPORT_PVT dependencies on HZ_CUST_ACCOUNTS

Line 4407: p_account_number IN hz_cust_accounts.account_number%TYPE ,

4403: END update_report;
4404:
4405: PROCEDURE insert_gt(p_contract_number IN okc_k_headers_all_b.contract_number%TYPE,
4406: p_party_name in hz_parties.party_name%TYPE,
4407: p_account_number IN hz_cust_accounts.account_number%TYPE ,
4408: p_cust_site_name IN okx_cust_sites_v.description%TYPE,
4409: p_inv_msg IN fnd_new_messages.message_text%TYPE,
4410: p_value IN VARCHAR2
4411:

Line 4543: hz_cust_accounts hca

4539: CURSOR c_cust_name(cp_cust_acct_id IN NUMBER) IS
4540: SELECT name,
4541: hca.account_number
4542: FROM okx_parties_v hp,
4543: hz_cust_accounts hca
4544: WHERE hp.id1 = hca.party_id
4545: AND hca.cust_account_id = cp_cust_acct_id;
4546:
4547: -- Customer Site Name

Line 4805: l_account_number hz_cust_accounts.account_number%TYPE;

4801: l_ext_line_addr_id okl_ext_sell_invs_v.customer_address_id%TYPE;
4802: l_pmth_line_id1 okc_rules_b.object1_id1%TYPE;
4803: l_ext_line_receipt_method_id Okl_Ext_Sell_Invs_V.receipt_method_id%TYPE;
4804: l_rct_line_method_code ar_receipt_classes.creation_method_code%TYPE;
4805: l_account_number hz_cust_accounts.account_number%TYPE;
4806: l_bank_line_id1 okc_rules_b.object1_id1%TYPE;
4807:
4808: l_exists VARCHAR2(1);
4809: l_fetch_size NUMBER := 5000;