DBA Data[Home] [Help]

APPS.OKL_AM_INVOICES_PVT dependencies on STANDARD

Line 184: SELECT c.standard_terms standard_terms

180:
181: CURSOR l_std_terms_csr (
182: cp_cust_id IN NUMBER,
183: cp_site_use_id IN NUMBER) IS
184: SELECT c.standard_terms standard_terms
185: FROM hz_customer_profiles c
186: WHERE c.cust_account_id = cp_cust_id
187: AND c.site_use_id = cp_site_use_id
188: UNION

Line 189: SELECT c1.standard_terms standard_terms

185: FROM hz_customer_profiles c
186: WHERE c.cust_account_id = cp_cust_id
187: AND c.site_use_id = cp_site_use_id
188: UNION
189: SELECT c1.standard_terms standard_terms
190: FROM hz_customer_profiles c1
191: WHERE c1.cust_account_id = cp_cust_id
192: AND c1.site_use_id IS NULL
193: AND NOT EXISTS (

Line 3784: IF l_qte_rec.qtp_code = 'REP_STANDARD' THEN

3780: l_no_allc := l_no_allc + 1;
3781: END IF;
3782:
3783: -- Bill Vendor from Vendor Program for Repurchase Quote
3784: IF l_qte_rec.qtp_code = 'REP_STANDARD' THEN
3785:
3786: -- Get Customer and Bill_To linked to a Vendor
3787: Get_Vendor_Billing_Info (
3788: px_taiv_rec => l_r_taiv_tbl(l_cnt),