APPS.PO_CORE_S dependencies on PO_LINES_DRAFT_ALL

Line 8253: line_last_update_date PO_LINES_DRAFT_ALL.last_update_date%type;

8249: FUNCTION get_last_update_date_for_mod(p_doc_id IN NUMBER) RETURN DATE
8250: IS
8251: draft_last_update_date PO_DRAFTS.last_update_date%type;
8252: header_last_update_date PO_HEADERS_DRAFT_ALL.last_update_date%type;
8253: line_last_update_date PO_LINES_DRAFT_ALL.last_update_date%type;
8254: line_loc_last_update_date PO_LINE_LOCATIONS_DRAFT_ALL.last_update_date%type;
8255: dist_last_update_date PO_DISTRIBUTIONS_DRAFT_ALL.last_update_date%type;
8256: mod_last_update_date PO_HEADERS_DRAFT_ALL.last_update_date%type;
8257: address_last_update_date po_headers_all_ext_b.last_update_date%type;

Line 8273: select nvl(max(last_update_date), min_date) into line_last_update_date from po_lines_draft_all where draft_id = p_doc_id;

8269: END IF;
8270: d_pos := 10;
8271: select nvl(max(last_update_date), min_date) into header_last_update_date from po_headers_draft_all where draft_id = p_doc_id;
8272: d_pos := 20;
8273: select nvl(max(last_update_date), min_date) into line_last_update_date from po_lines_draft_all where draft_id = p_doc_id;
8274: d_pos := 30;
8275: select nvl(max(last_update_date), min_date) into line_loc_last_update_date from po_line_locations_draft_all where draft_id = p_doc_id;
8276: d_pos := 40;
8277: select nvl(max(last_update_date), min_date) into dist_last_update_date from po_distributions_draft_all where draft_id = p_doc_id;