APPS.PO_CORE_S dependencies on PO_DRAFTS

Line 8251: draft_last_update_date PO_DRAFTS.last_update_date%type;

8247: --End of Comments
8248: -------------------------------------------------------------------------------
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;

Line 8279: select nvl(max(last_update_date), min_date) into draft_last_update_date from po_drafts where draft_id = p_doc_id;

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;
8278: d_pos := 50;
8279: select nvl(max(last_update_date), min_date) into draft_last_update_date from po_drafts where draft_id = p_doc_id;
8280: d_pos := 60;
8281: -- Bugfix 9878931
8282: -- Fetch the last update date of the addresses of the modification document
8283: select nvl(max(last_update_date), min_date) into address_last_update_date from po_headers_all_ext_b where draft_id = p_doc_id;