DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 818: l_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;

814: Select site_use_id
815: from HZ_CUST_SITE_USES
816: where cust_acct_site_id=cp_customer_address_id
817: and site_use_code = 'BILL_TO';
818: l_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;
819: -- gboomina modified for bug 6832065 - End
820:
821: --sosharma bug 6608452
822: --instrument_payment_use_id to be passed to IBY Bug 7162253

Line 827: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,

823: CURSOR instrument_payment_use_id_csr(
824: p_payment_function iby_pmt_instr_uses_all.payment_function%TYPE,
825: p_party_id okc_k_party_roles_b.object1_id1%TYPE,
826: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
827: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
828: p_org_id okl_k_headers_full_v.authoring_org_id%TYPE,
829: p_payment_flow iby_pmt_instr_uses_all.payment_flow%TYPE) IS
830: SELECT instrument_payment_use_id
831: FROM iby_pmt_instr_uses_all ibyinstr, iby_external_payers_all pay

Line 845: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,

841: l_instrument_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type;
842:
843: CURSOR cust_instr_payment_use_id_csr (
844: p_cust_acct_id okl_k_headers_full_v.cust_acct_id%TYPE,
845: p_site_use_id hz_cust_site_uses_all.site_use_id%TYPE,
846: p_currency_code okl_k_headers_full_v.currency_code%type
847: ) IS
848: Select substrb(min(decode(acct_site_use_id, NULL, '2' || to_char(instr_assignment_id),
849: '1' || to_char(instr_assignment_id))), 2)

Line 1368: hz_cust_site_uses_all b,

1364:
1365: CURSOR Ship_to_csr2( p_customer_num NUMBER, p_install_location NUMBER, p_location NUMBER, p_org_id NUMBER ) IS
1366: SELECT a.CUST_ACCT_SITE_ID
1367: FROM hz_cust_acct_sites_all a,
1368: hz_cust_site_uses_all b,
1369: hz_party_sites c
1370: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID AND
1371: b.site_use_code = 'SHIP_TO' AND
1372: a.party_site_id = c.party_site_id AND