DBA Data[Home] [Help]

APPS.PO_MOD_CONTROL_PVT dependencies on PO_ACTION_HISTORY

Line 1339: FROM po_action_history

1335: approval_path_id
1336: INTO l_sequence_num,
1337: l_object_rev_num,
1338: l_approval_path_id
1339: FROM po_action_history
1340: WHERE object_id = p_draft_id
1341: AND object_type_code = 'PO'
1342: AND sequence_num = (SELECT max(sequence_num)
1343: FROM po_action_history

Line 1343: FROM po_action_history

1339: FROM po_action_history
1340: WHERE object_id = p_draft_id
1341: AND object_type_code = 'PO'
1342: AND sequence_num = (SELECT max(sequence_num)
1343: FROM po_action_history
1344: WHERE object_id = p_draft_id
1345: AND Object_Type_Code = 'PO'
1346: AND object_sub_type_code = 'POST_AWARD_REQUEST')
1347: AND object_sub_type_code = 'POST_AWARD_REQUEST';

Line 1350: INSERT INTO PO_ACTION_HISTORY

1346: AND object_sub_type_code = 'POST_AWARD_REQUEST')
1347: AND object_sub_type_code = 'POST_AWARD_REQUEST';
1348:
1349: d_position := 160;
1350: INSERT INTO PO_ACTION_HISTORY
1351: (object_id,
1352: object_type_code,
1353: object_sub_type_code,
1354: sequence_num,