APPS.ICX_CAT_POPULATE_STATUS_PVT dependencies on PO_HEADERS_ALL

Line 100: 6. Just check for the end date in po_headers_all. Start_date will be checked by the search code

96: -- Standard Quotation => CATALOG
97: 3. Just check for the end date in po_line_locations_all. Start_date will be checked by the search code
98: 4. pqa.approval_type IN ('ALL ORDERS','REQUISITIONS') changed to pqa.approval_type IS NOT NULL to accomodate the SIC rules
99: 5. Just check for the end date in po_quotation_approvals_all. Start_date will be checked by the search code
100: 6. Just check for the end date in po_headers_all. Start_date will be checked by the search code
101: */
102:
103: SELECT VALID_FOR_POPULATE
104: INTO l_ret_status

Line 105: FROM po_headers_all ph,

101: */
102:
103: SELECT VALID_FOR_POPULATE
104: INTO l_ret_status
105: FROM po_headers_all ph,
106: po_lines_all pl
107: WHERE pl.po_line_id = p_po_line_id
108: AND ph.po_header_id = pl.po_header_id
109: AND ph.type_lookup_code = 'QUOTATION'