APPS.POR_CHANGE_REQUEST_PKG dependencies on PO_HEADERS_ALL

Line 44: l_rate_type po_headers_all.rate_type%TYPE;

40: p_rate_date IN DATE) RETURN NUMBER
41: IS
42: l_req_ou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
43: l_rate NUMBER := 1;
44: l_rate_type po_headers_all.rate_type%TYPE;
45: l_inverse_rate_display_flag VARCHAR2(1) := 'N';
46: l_display_rate NUMBER;
47: l_api_name VARCHAR2(30) := 'get_conversion_rate';
48: l_progress VARCHAR2(3) := '000';

Line 406: po_headers_all poh,

402: FROM
403: po_requisition_lines prl,
404: po_req_distributions prd,
405: po_line_locations_all pll,
406: po_headers_all poh,
407: po_lines_all pol,
408: po_distributions_all pod
409: WHERE
410: prl.requisition_line_id = reqlineid AND