APPS.OKL_STREAM_BILLING_PVT dependencies on RA_TERMS_B

Line 366: ,ra_terms_b term

362: CURSOR c_default_lead_days(p_khr_id IN NUMBER) IS
363: SELECT term.printing_lead_days
364: FROM okc_k_headers_b khr
365: ,hz_customer_profiles cp
366: ,ra_terms_b term
367: WHERE khr.id = p_khr_id
368: AND khr.bill_to_site_use_id = cp.site_use_id
369: AND cp.standard_terms = term.term_id;
370:

Line 1429: FROM ra_terms_b b, ra_terms_tl t

1425: -- Changed CURSOR std_terms_csr SQL definition
1426: -- Default term Id
1427: CURSOR std_terms_csr IS
1428: SELECT B.term_id
1429: FROM ra_terms_b b, ra_terms_tl t
1430: WHERE t.name = 'IMMEDIATE'
1431: and B.TERM_ID = T.TERM_ID
1432: and T.LANGUAGE = userenv('LANG');
1433: