APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_AME_APPROVALS_S

Line 894: select po_ame_approvals_s.nextval into l_ame_approval_id from dual;

890: WHERE po_header_id = DocumentID;
891:
892: if l_ame_transaction_type is not null AND ( l_ame_approval_id IS NULL or l_ame_approval_id = 0) THEN
893: --if l_ame_approval_id = 0 then
894: select po_ame_approvals_s.nextval into l_ame_approval_id from dual;
895: update po_headers_all
896: set ame_approval_id = l_ame_approval_id,
897: ame_transaction_type = l_ame_transaction_type
898: where po_header_id = DocumentID;

Line 916: select po_ame_approvals_s.nextval into l_ame_approval_id from dual;

912: AND phda.draft_id = DraftID
913: AND phda.draft_id = pd.draft_id;
914:
915: if l_ame_approval_id = 0 then
916: select po_ame_approvals_s.nextval into l_ame_approval_id from dual;
917: update po_headers_draft_all
918: set ame_approval_id = l_ame_approval_id
919: where po_header_id = DocumentID
920: and draft_id = DraftID;