DBA Data[Home] [Help]

APPS.PO_LINES_PKG_SUD dependencies on PO_LINES_ALL

Line 129: l_tax_attribute_update_code PO_LINES_ALL.tax_attribute_update_code%type;

125: p_ip_category_id NUMBER -- Bug 7577670
126: ) IS
127:
128: --
129: l_tax_attribute_update_code PO_LINES_ALL.tax_attribute_update_code%type;
130: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%type;
131: --
132:
133: BEGIN

Line 138: FROM po_headers_all poh, po_lines_all pol

134:
135: --
136: SELECT poh.type_lookup_code
137: INTO l_type_lookup_code
138: FROM po_headers_all poh, po_lines_all pol
139: WHERE pol.po_line_id = X_Po_Line_Id
140: AND pol.po_header_id = poh.po_header_id;
141:
142: IF l_type_lookup_code IN ('STANDARD', 'PLANNED') AND