DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on RA_TERMS_B

Line 368: ,ra_terms_b term

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

Line 1491: FROM ra_terms_b b, ra_terms_tl t

1487: -- Changed CURSOR std_terms_csr SQL definition
1488: -- Default term Id
1489: CURSOR std_terms_csr IS
1490: SELECT B.term_id
1491: FROM ra_terms_b b, ra_terms_tl t
1492: WHERE t.name = 'IMMEDIATE'
1493: and B.TERM_ID = T.TERM_ID
1494: and T.LANGUAGE = userenv('LANG');
1495: