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 3678: IF l_qte_rec.qtp_code = 'REP_STANDARD' THEN

3674: l_no_allc := l_no_allc + 1;
3675: END IF;
3676:
3677: -- Bill Vendor from Vendor Program for Repurchase Quote
3678: IF l_qte_rec.qtp_code = 'REP_STANDARD' THEN
3679:
3680: -- Get Customer and Bill_To linked to a Vendor
3681: Get_Vendor_Billing_Info (
3682: px_taiv_rec => l_r_taiv_tbl(l_cnt),