APPS.POS_REVISION_DIFFERENCES dependencies on PO_GA_ORG_ASSIGNMENTS_ARCHIVE

Line 769: FROM po_ga_org_assignments_archive pga1

765: CURSOR current_ga_assign_cursor(
766: current_header_id NUMBER,
767: current_revision_num NUMBER ) IS
768: SELECT *
769: FROM po_ga_org_assignments_archive pga1
770: WHERE
771: po_header_id = current_header_id AND
772: revision_num = (SELECT MAX( revision_num )
773: FROM po_ga_org_assignments_archive pga2

Line 773: FROM po_ga_org_assignments_archive pga2

769: FROM po_ga_org_assignments_archive pga1
770: WHERE
771: po_header_id = current_header_id AND
772: revision_num = (SELECT MAX( revision_num )
773: FROM po_ga_org_assignments_archive pga2
774: WHERE
775: revision_num <= current_revision_num
776: AND pga2.organization_id = pga1.organization_id
777: AND pga2.po_header_id = pga1.po_header_id

Line 781: v_ga_ass_to po_ga_org_assignments_archive%ROWTYPE;

777: AND pga2.po_header_id = pga1.po_header_id
778: );
779:
780:
781: v_ga_ass_to po_ga_org_assignments_archive%ROWTYPE;
782: v_ga_ass_from po_ga_org_assignments_archive%ROWTYPE;
783:
784: v_previous_revision_num NUMBER;
785: v_progress VARCHAR2(3);

Line 782: v_ga_ass_from po_ga_org_assignments_archive%ROWTYPE;

778: );
779:
780:
781: v_ga_ass_to po_ga_org_assignments_archive%ROWTYPE;
782: v_ga_ass_from po_ga_org_assignments_archive%ROWTYPE;
783:
784: v_previous_revision_num NUMBER;
785: v_progress VARCHAR2(3);
786:

Line 815: FROM po_ga_org_assignments_archive

811:
812:
813: SELECT *
814: INTO v_ga_ass_from
815: FROM po_ga_org_assignments_archive
816: WHERE
817: revision_num = (
818: SELECT MAX( revision_num )
819: FROM po_ga_org_assignments_archive

Line 819: FROM po_ga_org_assignments_archive

815: FROM po_ga_org_assignments_archive
816: WHERE
817: revision_num = (
818: SELECT MAX( revision_num )
819: FROM po_ga_org_assignments_archive
820: WHERE
821: revision_num <= v_previous_revision_num
822: AND organization_id = v_ga_ass_to.organization_id
823: AND po_header_id = v_ga_ass_to.po_header_id