APPS.PO_PRICE_DIFFERENTIALS_PVT dependencies on PO_HEADERS_ALL

Line 1598: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

1594: ,p_doc_level_id IN NUMBER)
1595: RETURN VARCHAR2
1596: IS
1597: l_entity_type PO_PRICE_DIFFERENTIALS.entity_type%type := NULL;
1598: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1599: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
1600: l_value_basis PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
1601: l_purchase_basis PO_LINE_TYPES_B.purchase_basis%TYPE;
1602:

Line 1599: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

1595: RETURN VARCHAR2
1596: IS
1597: l_entity_type PO_PRICE_DIFFERENTIALS.entity_type%type := NULL;
1598: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1599: l_doc_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
1600: l_value_basis PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
1601: l_purchase_basis PO_LINE_TYPES_B.purchase_basis%TYPE;
1602:
1603: d_module_name CONSTANT VARCHAR2(30) := 'GET_ENTITY_TYPE';

Line 1623: PO_HEADERS_ALL poh

1619: l_doc_subtype,
1620: l_value_basis,
1621: l_purchase_basis
1622: FROM PO_LINES_ALL pol,
1623: PO_HEADERS_ALL poh
1624: WHERE poh.po_header_id = pol.po_header_id
1625: AND po_line_id = p_doc_level_id;
1626:
1627: ELSIF p_doc_level = PO_CORE_S.g_doc_level_SHIPMENT THEN

Line 1638: FROM PO_HEADERS_ALL poh,

1634: INTO l_ga_flag,
1635: l_doc_subtype,
1636: l_value_basis,
1637: l_purchase_basis
1638: FROM PO_HEADERS_ALL poh,
1639: PO_LINES_ALL pol,
1640: PO_LINE_LOCATIONS_ALL poll
1641: WHERE poh.po_header_id = pol.po_header_id
1642: AND pol.po_line_id = poll.po_line_id