APPS.PO_COMMUNICATION_PVT dependencies on PO_ACTION_HISTORY

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

7473: begin
7474:
7475: -- bug#3297926 Start --
7476: --l_signed := PO_SIGNATURE_PVT.Was_Signature_Required(p_document_id => p_header_id);
7477: -- SQL What:Checks if there is any record in the PO_ACTION_HISTORY with the
7478: -- action code as 'SIGNED' and revision less than current revision.
7479: -- SQL Why :To find out if the document was ever signed
7480: begin
7481: /*Bug9535677 Donot check for the signed status if the acceptance type is not

Line 7496: FROM PO_ACTION_HISTORY

7492: SELECT 'Y'
7493: INTO l_signatures
7494: FROM dual
7495: WHERE EXISTS (SELECT 1
7496: FROM PO_ACTION_HISTORY
7497: WHERE object_id = p_header_id
7498: AND object_type_code IN ('PO', 'PA')
7499: AND action_code = 'SIGNED'
7500: AND OBJECT_REVISION_NUM < PO_COMMUNICATION_PVT.g_revision_num);

Line 7977: FROM po_action_history pah

7973: l_cancel_date date := null;
7974: begin
7975: SELECT action_date
7976: INTO l_cancel_date
7977: FROM po_action_history pah
7978: WHERE pah.object_id = p_po_header_id
7979: AND ((pah.object_type_code = 'PO'
7980: AND pah.object_sub_type_code in ('PLANNED', 'STANDARD'))
7981: OR (pah.object_type_code = 'PA'