APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on HZ_PARTY_SITES

Line 1826: hz_party_sites st

1822: SELECT st.party_site_id
1823: FROM okc_k_headers_all_b okc,
1824: hz_cust_site_uses_all su,
1825: hz_cust_acct_sites_all sa,
1826: hz_party_sites st
1827: WHERE okc.bill_to_site_use_id = su.site_use_id
1828: AND su.cust_acct_site_id = sa.cust_acct_site_id
1829: AND sa.party_site_id = st.party_site_id
1830: AND okc.ID = p_chr_id;

Line 1842: l_billing_address_id hz_party_sites.party_site_id%TYPE;

1838: p_year, 'MM/YYYY'))
1839: FROM DUAL;
1840:
1841: l_trxn_extension_id oks_k_headers_b.trxn_extension_id%TYPE;
1842: l_billing_address_id hz_party_sites.party_site_id%TYPE;
1843: l_expiration_date DATE := '';
1844:
1845: SUBTYPE l_payer_type IS iby_fndcpt_common_pub.payercontext_rec_type;
1846: