APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on HZ_PARTY_SITES

Line 1825: hz_party_sites st

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

Line 1841: l_billing_address_id hz_party_sites.party_site_id%TYPE;

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