APPS.PA_EXPENDITURES_UTILS SQL Statements

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

Line: 26

		select tl.name
		into  G_Organization_Name
                from  hr_org_units_no_join o,
                      hr_all_organization_units_tl tl
		where
                      o.organization_id(+) = P_Organization_Id
                and   o.organization_id = tl.organization_id(+)
                and ( ( tl.organization_id is null and
                        1 = 1)
                   or ( tl.organization_id is not null and
                        tl.language = userenv('LANG'))) ;

Line: 51

                select tl.name
                into  G_Organization_Name
                from  hr_org_units_no_join o,
                      hr_all_organization_units_tl tl
                where
                      o.organization_id(+) = P_Organization_Id
                and   o.organization_id = tl.organization_id(+)
                and ( ( tl.organization_id is null and
                        1 = 1)
                   or ( tl.organization_id is not null and
                        tl.language = userenv('LANG'))) ;

Line: 68

                select tl.name
                into  G_Organization_Name_1
                from  hr_org_units_no_join o,
                      hr_all_organization_units_tl tl
                where
                      o.organization_id(+) = P_Organization_Id
                and   o.organization_id = tl.organization_id(+)
                and ( ( tl.organization_id is null and
                        1 = 1)
                   or ( tl.organization_id is not null and
                        tl.language = userenv('LANG'))) ;

Line: 115

		select name
		into   G_Organization_Name_US
                from   hr_org_units_no_join
		where  organization_id = P_Organization_Id;

Line: 147

	SELECT
	    TL.NAME
	  INTO
	    X_ORG_NAME
	 FROM
	  HR_ORG_UNITS_NO_JOIN O,
	  HR_ALL_ORGANIZATION_UNITS_TL TL
	 WHERE
	   O.ORGANIZATION_ID(+) = P_ORG_ID
	  AND
	    O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)
	  AND
	  ( ( TL.ORGANIZATION_ID IS NULL AND 1 = 1)
	 OR
	  ( TL.ORGANIZATION_ID IS NOT NULL AND TL.LANGUAGE = USERENV('LANG'))) ;

Line: 170

	SELECT
	    TL.NAME
	  INTO
	    X_ORG_NAME
	 FROM
	  HR_ORG_UNITS_NO_JOIN O,
	  HR_ALL_ORGANIZATION_UNITS_TL TL
	 WHERE
	   O.ORGANIZATION_ID(+) = P_ORG_ID
	  AND
	    O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)
	  AND
	  ( ( TL.ORGANIZATION_ID IS NULL AND 1 = 1)
	 OR
	  ( TL.ORGANIZATION_ID IS NOT NULL AND TL.LANGUAGE = USERENV('LANG'))) ;

Line: 193

	SELECT
	    TL.NAME
	  INTO
	    X_ORG_NAME
	 FROM
	  HR_ORG_UNITS_NO_JOIN O,
	  HR_ALL_ORGANIZATION_UNITS_TL TL
	 WHERE
	   O.ORGANIZATION_ID(+) = P_ORG_ID
	  AND
	    O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)
	  AND
	  ( ( TL.ORGANIZATION_ID IS NULL AND 1 = 1)
	 OR
	  ( TL.ORGANIZATION_ID IS NOT NULL AND TL.LANGUAGE = USERENV('LANG'))) ;

Line: 216

	SELECT
	    TL.NAME
	  INTO
	    X_ORG_NAME
	 FROM
	  HR_ORG_UNITS_NO_JOIN O,
	  HR_ALL_ORGANIZATION_UNITS_TL TL
	 WHERE
	   O.ORGANIZATION_ID(+) = P_ORG_ID
	  AND
	    O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)
	  AND
	  ( ( TL.ORGANIZATION_ID IS NULL AND 1 = 1)
	 OR
	  ( TL.ORGANIZATION_ID IS NOT NULL AND TL.LANGUAGE = USERENV('LANG'))) ;

Line: 239

	SELECT
	    TL.NAME
	  INTO
	    X_ORG_NAME
	 FROM
	  HR_ORG_UNITS_NO_JOIN O,
	  HR_ALL_ORGANIZATION_UNITS_TL TL
	 WHERE
	   O.ORGANIZATION_ID(+) = P_ORG_ID
	  AND
	    O.ORGANIZATION_ID = TL.ORGANIZATION_ID(+)
	  AND
	  ( ( TL.ORGANIZATION_ID IS NULL AND 1 = 1)
	 OR
	  ( TL.ORGANIZATION_ID IS NOT NULL AND TL.LANGUAGE = USERENV('LANG'))) ;

Line: 284

		select name
		into G_job_name
		from per_jobs
		where job_id = p_job_id;

Line: 369

			SELECT function
		    INTO   x_sys_link_func
		    FROM   pa_system_linkages
		    WHERE  function = p_sys_link_func;

Line: 382

		SELECT function
		INTO   x_sys_link_func
		FROM   pa_system_linkages
		WHERE  meaning = p_exp_meaning;

Line: 434

	  select count(*)
      into l_dummy
      from pa_expenditure_types_expend_v
      where p_ei_date between expnd_typ_start_date_active
      and nvl(expnd_typ_end_date_active,p_ei_date)
      and p_ei_date between SYS_LINK_START_DATE_ACTIVE
      and nvl(sys_link_end_date_active,p_ei_date)
      and system_linkage_function = p_sys_link_func
      and expenditure_type = p_exp_type;

Line: 495

                SELECT 	PA_DATE,
			GL_DATE,
			RECVR_PA_DATE,
			RECVR_GL_DATE,
			PA_PERIOD_NAME,
			GL_PERIOD_NAME,
			RECVR_PA_PERIOD_NAME,
			RECVR_GL_PERIOD_NAME
                INTO
			G_PA_DATE,
			G_GL_DATE,
			G_RECVR_PA_DATE,
			G_RECVR_GL_DATE,
			G_PA_PERIOD_NAME,
			G_GL_PERIOD_NAME,
			G_RECVR_PA_PERIOD_NAME,
			G_RECVR_GL_PERIOD_NAME
                FROM PA_COST_DISTRIBUTION_LINES_ALL
                WHERE EXPENDITURE_ITEM_ID = P_EXP_ITEM_ID
                AND LINE_TYPE = 'R'
		AND LINE_NUM_REVERSED IS NULL
		AND REVERSED_FLAG IS NULL ;

Line: 566

                Select 	pa_date,
			gl_date,
			recvr_pa_date,
			recvr_gl_date,
			pa_period_name,
			gl_period_name,
			recvr_pa_period_name,
			recvr_gl_period_name
                Into
			g_pa_date,
			g_gl_date,
			g_recvr_pa_date,
			g_recvr_gl_date,
			g_pa_period_name,
			g_gl_period_name,
			g_recvr_pa_period_name,
			g_recvr_Gl_period_name
                From pa_cost_distribution_lines_all
                Where expenditure_item_id = P_Exp_Item_Id
                And line_type = 'R'
                And line_num = (
                        Select max(line_num)
                        From pa_cost_distribution_lines_all
                        Where expenditure_item_id = P_Exp_Item_Id
                        And line_type = 'R');

Line: 623

                Select  pa_date,
                        gl_date,
                        recvr_pa_date,
                        recvr_gl_date,
                        pa_period_name,
                        gl_period_name,
                        recvr_pa_period_name,
                        recvr_gl_period_name
                Into
                        g_pa_date,
                        g_gl_date,
                        g_recvr_pa_date,
                        g_recvr_gl_date,
                        g_pa_period_name,
                        g_gl_period_name,
                        g_recvr_pa_period_name,
                        g_recvr_Gl_period_name
		From pa_cost_distribution_lines_all
		Where expenditure_item_id = P_Exp_Item_Id
		And line_type = 'R'
		And line_num = (
			Select max(line_num)
			From pa_cost_distribution_lines_all
			Where expenditure_item_id = P_Exp_Item_Id
			And line_type = 'R');

Line: 680

                Select  pa_date,
                        gl_date,
                        recvr_pa_date,
                        recvr_gl_date,
                        pa_period_name,
                        gl_period_name,
                        recvr_pa_period_name,
                        recvr_gl_period_name
                Into
                        g_pa_date,
                        g_gl_date,
                        g_recvr_pa_date,
                        g_recvr_gl_date,
                        g_pa_period_name,
                        g_gl_period_name,
                        g_recvr_pa_period_name,
                        g_recvr_Gl_period_name
                From pa_cost_distribution_lines_all
                Where expenditure_item_id = P_Exp_Item_Id
                And line_type = 'R'
                And line_num = (
                        Select max(line_num)
                        From pa_cost_distribution_lines_all
                        Where expenditure_item_id = P_Exp_Item_Id
                        And line_type = 'R');

Line: 738

                Select  pa_date,
                        gl_date,
                        recvr_pa_date,
                        recvr_gl_date,
                        pa_period_name,
                        gl_period_name,
                        recvr_pa_period_name,
                        recvr_gl_period_name
                Into
                        g_pa_date,
                        g_gl_date,
                        g_recvr_pa_date,
                        g_recvr_gl_date,
                        g_pa_period_name,
                        g_gl_period_name,
                        g_recvr_pa_period_name,
                        g_recvr_Gl_period_name
                From pa_cost_distribution_lines_all
                Where expenditure_item_id = P_Exp_Item_Id
                And line_type = 'R'
                And line_num = (
                        Select max(line_num)
                        From pa_cost_distribution_lines_all
                        Where expenditure_item_id = P_Exp_Item_Id
                        And line_type = 'R');

Line: 796

                Select  pa_date,
                        gl_date,
                        recvr_pa_date,
                        recvr_gl_date,
                        pa_period_name,
                        gl_period_name,
                        recvr_pa_period_name,
                        recvr_gl_period_name
                Into
                        g_pa_date,
                        g_gl_date,
                        g_recvr_pa_date,
                        g_recvr_gl_date,
                        g_pa_period_name,
                        g_gl_period_name,
                        g_recvr_pa_period_name,
                        g_recvr_Gl_period_name
                From pa_cost_distribution_lines_all
                Where expenditure_item_id = P_Exp_Item_Id
                And line_type = 'R'
                And line_num = (
                        Select max(line_num)
                        From pa_cost_distribution_lines_all
                        Where expenditure_item_id = P_Exp_Item_Id
                        And line_type = 'R');

Line: 854

                Select  pa_date,
                        gl_date,
                        recvr_pa_date,
                        recvr_gl_date,
                        pa_period_name,
                        gl_period_name,
                        recvr_pa_period_name,
                        recvr_gl_period_name
                Into
                        g_pa_date,
                        g_gl_date,
                        g_recvr_pa_date,
                        g_recvr_gl_date,
                        g_pa_period_name,
                        g_gl_period_name,
                        g_recvr_pa_period_name,
                        g_recvr_Gl_period_name
                From pa_cost_distribution_lines_all
                Where expenditure_item_id = P_Exp_Item_Id
                And line_type = 'R'
                And line_num = (
                        Select max(line_num)
                        From pa_cost_distribution_lines_all
                        Where expenditure_item_id = P_Exp_Item_Id
                        And line_type = 'R');

Line: 912

                Select  pa_date,
                        gl_date,
                        recvr_pa_date,
                        recvr_gl_date,
                        pa_period_name,
                        gl_period_name,
                        recvr_pa_period_name,
                        recvr_gl_period_name
                Into
                        g_pa_date,
                        g_gl_date,
                        g_recvr_pa_date,
                        g_recvr_gl_date,
                        g_pa_period_name,
                        g_gl_period_name,
                        g_recvr_pa_period_name,
                        g_recvr_Gl_period_name
                From pa_cost_distribution_lines_all
                Where expenditure_item_id = P_Exp_Item_Id
                And line_type = 'R'
                And line_num = (
                        Select max(line_num)
                        From pa_cost_distribution_lines_all
                        Where expenditure_item_id = P_Exp_Item_Id
                        And line_type = 'R');

Line: 970

                Select  pa_date,
                        gl_date,
                        recvr_pa_date,
                        recvr_gl_date,
                        pa_period_name,
                        gl_period_name,
                        recvr_pa_period_name,
                        recvr_gl_period_name
                Into
                        g_pa_date,
                        g_gl_date,
                        g_recvr_pa_date,
                        g_recvr_gl_date,
                        g_pa_period_name,
                        g_gl_period_name,
                        g_recvr_pa_period_name,
                        g_recvr_gl_period_name
                From pa_cost_distribution_lines_all
                Where expenditure_item_id = P_Exp_Item_Id
                And line_type = 'R'
                And line_num = (
                        Select max(line_num)
                        From pa_cost_distribution_lines_all
                        Where expenditure_item_id = P_Exp_Item_Id
                        And line_type = 'R');

Line: 1028

        SELECT
            TL.NAME
          INTO
            X_ORG_NAME
         FROM
          HR_ALL_ORGANIZATION_UNITS_TL TL
         WHERE
           TL.ORGANIZATION_ID = P_ORG_ID
           AND TL.LANGUAGE = USERENV('LANG') ;