APPS.PO_EMAIL_GENERATE dependencies on AP_TERMS_VAL_V

Line 2660: l_payment_terms ap_terms_val_v.name%TYPE;

2656: l_fob_lookup_desc PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2657: l_freight_terms_lc PO_HEADERS_ALL.FREIGHT_TERMS_LOOKUP_CODE%TYPE;
2658: l_freight_terms_dsp PO_LOOKUP_CODES.DISPLAYED_FIELD%TYPE;
2659: l_payment_terms_id NUMBER;
2660: l_payment_terms ap_terms_val_v.name%TYPE;
2661: l_customer_acct_num PO_VENDOR_SITES.CUSTOMER_NUM%TYPE;
2662:
2663: l_org_id NUMBER; --
2664:

Line 3854: from ap_terms_val_v apv

3850: end;
3851:
3852: begin
3853: select name into l_payment_terms
3854: from ap_terms_val_v apv
3855: where apv.TERM_ID = l_payment_terms_id;
3856: exception
3857: when others then
3858: l_payment_terms := '';