APPS.PO_CORE_S dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

Line 8255: dist_last_update_date PO_DISTRIBUTIONS_DRAFT_ALL.last_update_date%type;

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;
8258: org_assign_last_update_date po_ga_org_assign_draft.last_update_date%type;
8259: --Lowest date supported by database as we need to handle null dates

Line 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;

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;
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