DBA Data[Home] [Help]

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on HZ_CUST_ACCOUNTS_ALL

Line 3861: hz_cust_accounts_all ca

3857: FROM okc_k_headers_all_b okc,
3858: oks_k_headers_b oks,
3859: hz_cust_site_uses_all su,
3860: hz_cust_acct_sites_all sa,
3861: hz_cust_accounts_all ca
3862: WHERE oks.chr_id = okc.ID
3863: AND okc.bill_to_site_use_id = su.site_use_id
3864: AND su.cust_acct_site_id = sa.cust_acct_site_id
3865: AND sa.cust_account_id = ca.cust_account_id

Line 3869: l_cust_account_id hz_cust_accounts_all.cust_account_id%TYPE;

3865: AND sa.cust_account_id = ca.cust_account_id
3866: AND oks.trxn_extension_id IS NOT NULL
3867: AND okc.ID = p_chr_id;
3868:
3869: l_cust_account_id hz_cust_accounts_all.cust_account_id%TYPE;
3870: l_party_id hz_cust_accounts_all.party_id%TYPE;
3871: l_trxn_extension_id oks_k_headers_b.trxn_extension_id%TYPE;
3872:
3873: SUBTYPE l_payer_type IS iby_fndcpt_common_pub.payercontext_rec_type;

Line 3870: l_party_id hz_cust_accounts_all.party_id%TYPE;

3866: AND oks.trxn_extension_id IS NOT NULL
3867: AND okc.ID = p_chr_id;
3868:
3869: l_cust_account_id hz_cust_accounts_all.cust_account_id%TYPE;
3870: l_party_id hz_cust_accounts_all.party_id%TYPE;
3871: l_trxn_extension_id oks_k_headers_b.trxn_extension_id%TYPE;
3872:
3873: SUBTYPE l_payer_type IS iby_fndcpt_common_pub.payercontext_rec_type;
3874: