APPS.PO_SECURITY_CHECK_SV dependencies on PO_ACTION_HISTORY

Line 127: from po_action_history pah

123:
124: x_progress := '010';
125:
126: select count(*) into x_count
127: from po_action_history pah
128: where
129: pah.object_id = x_object_id and
130: pah.object_type_code = x_document_type_code and
131: pah.object_sub_type_code = x_document_subtype and

Line 134: if x_count = 0 then -- no records in po_action_history

130: pah.object_type_code = x_document_type_code and
131: pah.object_sub_type_code = x_document_subtype and
132: pah.action_code is null;
133:
134: if x_count = 0 then -- no records in po_action_history
135: -- dbms_output.put_line('Count is zero');
136: x_modify_action := TRUE;
137: return;
138:

Line 160: from po_action_history pah

156:
157: x_progress := '030';
158: select EMPLOYEE_ID
159: into x_last_action_emp_id
160: from po_action_history pah
161: where
162: pah.object_id = x_object_id and
163: pah.object_type_code = x_document_type_code and
164: pah.object_sub_type_code = x_document_subtype and

Line 200: -- dbms_output.put_line('No records were found in po_action_history');

196: x_modify_action := FALSE;
197: return;
198:
199: END IF; -- x_can_approver_modify_flag = Y
200: -- dbms_output.put_line('No records were found in po_action_history');
201: -- dbms_output.put_line('We have a problem here');
202:
203: END IF; -- count(*)
204: