APPS.PO_CORE_S dependencies on PO_HEADERS_ALL_EXT_B

Line 8257: address_last_update_date po_headers_all_ext_b.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
8260: min_date PO_HEADERS_DRAFT_ALL.last_update_date%type := to_date('01/01/-4712','DD/MM/SYYYY');
8261:

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

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;
8284: d_pos := 65;
8285: -- Bugfix 11774144
8286: select nvl(max(last_update_date), min_date) into org_assign_last_update_date from po_ga_org_assign_draft where draft_id = p_doc_id;
8287: d_pos := 70;