APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 1022: hz_cust_accounts ca

1018: r.object1_id1 AS party_id,
1019: ca.cust_account_id AS customer_account_id
1020: FROM okc_k_party_roles_b r,
1021: hz_parties p,
1022: hz_cust_accounts ca
1023: WHERE p.party_id = r.object1_id1
1024: AND ca.party_id = p.party_id
1025: AND r.jtot_object1_code = 'OKX_PARTY'
1026: AND r.rle_code IN ('CUSTOMER', 'SUBSCRIBER')

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: