DBA Data[Home] [Help]

APPS.OKE_UTILS dependencies on AP_TERMS

Line 501: FROM AP_TERMS

497: if p_term_code = 'AP_PAYMENT_TERMS' AND LTrim(RTrim(p_term_value_pk1,'0123456789'),'0123456789') IS NULL then
498:
499: SELECT NAME , DESCRIPTION , START_DATE_ACTIVE , END_DATE_ACTIVE
500: INTO v_chr1 , v_chr2 , v_date1 , v_date2
501: FROM AP_TERMS
502: WHERE TERM_ID = to_number(p_term_value_pk1);
503:
504: elsif p_term_code='IB_SHIPPING_METHOD' AND LTrim(RTrim(p_term_value_pk1,'0123456789'),'0123456789') IS NULL then
505: