APPS.PO_COMMUNICATION_PVT dependencies on PO_ACTION_HISTORY

Line 6366: -- SQL What:Checks if there is any record in the PO_ACTION_HISTORY with the

6362: begin
6363:
6364: -- bug#3297926 Start --
6365: --l_signed := PO_SIGNATURE_PVT.Was_Signature_Required(p_document_id => p_header_id);
6366: -- SQL What:Checks if there is any record in the PO_ACTION_HISTORY with the
6367: -- action code as 'SIGNED' and revision less than current revision.
6368: -- SQL Why :To find out if the document was ever signed
6369: begin
6370: SELECT 'Y'

Line 6374: FROM PO_ACTION_HISTORY

6370: SELECT 'Y'
6371: INTO l_signatures
6372: FROM dual
6373: WHERE EXISTS (SELECT 1
6374: FROM PO_ACTION_HISTORY
6375: WHERE object_id = p_header_id
6376: AND object_type_code IN ('PO','PA')
6377: AND action_code = 'SIGNED'
6378: AND OBJECT_REVISION_NUM < PO_COMMUNICATION_PVT.g_revision_num);

Line 6785: FROM po_action_history pah

6781: l_cancel_date date := null;
6782: begin
6783: SELECT action_date
6784: INTO l_cancel_date
6785: FROM po_action_history pah
6786: WHERE pah.object_id = p_po_header_id
6787: AND ((pah.object_type_code = 'PO'
6788: AND pah.object_sub_type_code in ('PLANNED','STANDARD'))
6789: OR (pah.object_type_code = 'PA'