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 3813: hz_cust_accounts_all ca

3809: FROM okc_k_headers_all_b okc,
3810: oks_k_headers_b oks,
3811: hz_cust_site_uses_all su,
3812: hz_cust_acct_sites_all sa,
3813: hz_cust_accounts_all ca
3814: WHERE oks.chr_id = okc.ID
3815: AND okc.bill_to_site_use_id = su.site_use_id
3816: AND su.cust_acct_site_id = sa.cust_acct_site_id
3817: AND sa.cust_account_id = ca.cust_account_id

Line 3821: l_cust_account_id hz_cust_accounts_all.cust_account_id%TYPE;

3817: AND sa.cust_account_id = ca.cust_account_id
3818: AND oks.trxn_extension_id IS NOT NULL
3819: AND okc.ID = p_chr_id;
3820:
3821: l_cust_account_id hz_cust_accounts_all.cust_account_id%TYPE;
3822: l_party_id hz_cust_accounts_all.party_id%TYPE;
3823: l_trxn_extension_id oks_k_headers_b.trxn_extension_id%TYPE;
3824:
3825: SUBTYPE l_payer_type IS iby_fndcpt_common_pub.payercontext_rec_type;

Line 3822: l_party_id hz_cust_accounts_all.party_id%TYPE;

3818: AND oks.trxn_extension_id IS NOT NULL
3819: AND okc.ID = p_chr_id;
3820:
3821: l_cust_account_id hz_cust_accounts_all.cust_account_id%TYPE;
3822: l_party_id hz_cust_accounts_all.party_id%TYPE;
3823: l_trxn_extension_id oks_k_headers_b.trxn_extension_id%TYPE;
3824:
3825: SUBTYPE l_payer_type IS iby_fndcpt_common_pub.payercontext_rec_type;
3826: