[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT podt.can_change_forward_from_flag,
podt.can_change_forward_to_flag,
podt.can_change_approval_path_flag,
podt.can_preparer_approve_flag,
podt.default_approval_path_id,
podt.can_approver_modify_doc_flag
INTO x_can_change_forward_from_flag,
x_can_change_forward_to_flag,
x_can_change_approval_path,
x_can_preparer_approve_flag,
x_default_approval_path_id,
x_can_approver_modify_flag
FROM po_document_types podt
WHERE podt.document_type_code = x_document_type_code
AND podt.document_subtype = x_document_subtype;
SELECT pps.name,
pah.approval_path_id
INTO x_approval_path,
x_approval_path_id
FROM per_position_structures pps,
po_action_history pah
WHERE pah.approval_path_id = pps.position_structure_id
AND pah.object_id = x_object_id
AND pah.object_type_code = x_document_type_code
AND pah.object_sub_type_code = x_document_subtype
AND pah.sequence_num =
(SELECT max(sequence_num)
FROM po_action_history PAH2
WHERE PAH2.object_id = x_object_id
AND PAH2.object_type_code = x_document_type_code
AND PAH2.object_sub_type_code = x_document_subtype
AND PAH2.action_code is not null);
SELECT DISTINCT pps.name,
pps.position_structure_id
INTO x_approval_path,
x_approval_path_id
FROM po_employee_hierarchies peh,
per_position_structures pps
WHERE peh.position_structure_id = pps.position_structure_id
AND pps.position_structure_id = x_default_approval_path_id
AND peh.employee_id = x_forward_from_id;
SELECT podt.can_change_forward_from_flag,
podt.can_change_forward_to_flag,
podt.can_change_approval_path_flag,
podt.can_preparer_approve_flag,
podt.default_approval_path_id,
podt.can_approver_modify_doc_flag,
podt.forwarding_mode_code,
podt.wf_approval_itemtype,
podt.wf_approval_process,
podt.type_name
INTO x_can_change_forward_from_flag,
x_can_change_forward_to_flag,
x_can_change_approval_path,
x_can_preparer_approve_flag,
x_default_approval_path_id,
x_can_approver_modify_flag,
x_forwarding_mode_code,
x_wf_approval_itemtype,
x_wf_approval_process,
x_type_name
FROM po_document_types podt
WHERE podt.document_type_code = p_document_type_code
AND podt.document_subtype = p_document_subtype;
select response_reason
from po_change_requests
where document_header_id = p_po_header_id
-- Bug 3711787
and change_active_flag = 'Y'
-- Bug 3326904
and po_release_id IS NULL;
select response_reason
from po_change_requests
where po_release_id = p_po_release_id
-- Bug 3711787
and change_active_flag = 'Y';