APPS.PO_UPDATE_WO_MOD_PKG dependencies on PO_HEADERS_ALL_EXT_B

Line 23: SET CLM_COTR_OFFICE = (SELECT N_EXT_ATTR1 FROM po_headers_all_ext_b WHERE po_header_id = p_po_header_id AND ATTR_GROUP_ID= p_attr_grp_id and C_EXT_ATTR1 ='COTR_OFFICE' and DRAFT_ID = -1),

19:
20:
21: BEGIN
22: UPDATE PO_HEADERS_ALL
23: SET CLM_COTR_OFFICE = (SELECT N_EXT_ATTR1 FROM po_headers_all_ext_b WHERE po_header_id = p_po_header_id AND ATTR_GROUP_ID= p_attr_grp_id and C_EXT_ATTR1 ='COTR_OFFICE' and DRAFT_ID = -1),
24: CLM_COTR_CONTACT =(SELECT N_EXT_ATTR3 FROM po_headers_all_ext_b WHERE po_header_id = p_po_header_id AND ATTR_GROUP_ID= p_attr_grp_id and C_EXT_ATTR1 ='COTR_OFFICE' and DRAFT_ID = -1),
25: UMBRELLA_PROGRAM_ID = (SELECT UMBRELLA_PROGRAM_ID FROM PON_UMBRELLA_PROGRAMS WHERE UMBRELLA_PROGRAM_NAME = p_umb_prog_name)
26: WHERE PO_HEADER_ID = p_po_header_id ;
27:

Line 24: CLM_COTR_CONTACT =(SELECT N_EXT_ATTR3 FROM po_headers_all_ext_b WHERE po_header_id = p_po_header_id AND ATTR_GROUP_ID= p_attr_grp_id and C_EXT_ATTR1 ='COTR_OFFICE' and DRAFT_ID = -1),

20:
21: BEGIN
22: UPDATE PO_HEADERS_ALL
23: SET CLM_COTR_OFFICE = (SELECT N_EXT_ATTR1 FROM po_headers_all_ext_b WHERE po_header_id = p_po_header_id AND ATTR_GROUP_ID= p_attr_grp_id and C_EXT_ATTR1 ='COTR_OFFICE' and DRAFT_ID = -1),
24: CLM_COTR_CONTACT =(SELECT N_EXT_ATTR3 FROM po_headers_all_ext_b WHERE po_header_id = p_po_header_id AND ATTR_GROUP_ID= p_attr_grp_id and C_EXT_ATTR1 ='COTR_OFFICE' and DRAFT_ID = -1),
25: UMBRELLA_PROGRAM_ID = (SELECT UMBRELLA_PROGRAM_ID FROM PON_UMBRELLA_PROGRAMS WHERE UMBRELLA_PROGRAM_NAME = p_umb_prog_name)
26: WHERE PO_HEADER_ID = p_po_header_id ;
27:
28: UPDATE po_drafts SET revision_num = -1 WHERE document_id = p_po_header_id AND STATUS IN ('DRAFT','IN PROCESS','REJECTED','PRE-APPROVED','SUPPLIER SIGN') AND draft_type = 'MOD';