APPS.RCV_PROJECT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 59

            SELECT
                PO_LINE_LOCATION_ID,
                PO_DISTRIBUTION_ID
            INTO
                l_line_location_id,
                l_distribution_id
            FROM
                RCV_TRANSACTIONS
            WHERE
                TRANSACTION_ID = p_transaction_id;

Line: 94

                  SELECT
                      pde.SEGMENT1
                  INTO
                      g_project_number
                  FROM
                      PO_DISTRIBUTIONS_ALL pd,
                      PA_PROJECTS_ALL pde
                  WHERE
                      pd.PO_DISTRIBUTION_ID = l_distribution_id
                  AND	pde.PROJECT_ID = pd.PROJECT_ID;

Line: 110

                  SELECT
                      pte.TASK_NUMBER
                  INTO
                      g_task_number
                  FROM
                      PO_DISTRIBUTIONS_ALL pd,
                      PA_TASKS pte
                  WHERE
                      pd.PO_DISTRIBUTION_ID = l_distribution_id
                  AND	pte.TASK_ID = pd.TASK_ID;

Line: 136

                       SELECT
				DISTINCT(pde.SEGMENT1)
                       INTO
				g_project_number
                       FROM
				PO_DISTRIBUTIONS_ALL pd,
				PA_PROJECTS_ALL pde
                       WHERE
				pd.LINE_LOCATION_ID = l_line_location_id
                       AND	pde.PROJECT_ID = pd.PROJECT_ID;

Line: 155

                       SELECT
				DISTINCT(pte.TASK_NUMBER)
                       INTO
				g_task_number
                       FROM
				PO_DISTRIBUTIONS_ALL pd,
				PA_TASKS pte
                       WHERE
				pd.LINE_LOCATION_ID = l_line_location_id
                       AND	pte.TASK_ID = pd.TASK_ID;