APPS.PA_ORG SQL Statements

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

Line: 28

    dummy1		VARCHAR2(4);	--	into arg for main SELECT

Line: 30

    select 'X'
    from  pa_implementations_all pai
    where ( (p_org_structure_id = pai.organization_structure_id)
           OR (p_org_structure_id = pai.proj_org_structure_id)
           OR (p_org_structure_id = pai.exp_org_structure_id)
          );

Line: 65

        SELECT 'X'
          INTO dummy1
          FROM hr_organization_information
         WHERE organization_id = pa_utils.business_group_id
           AND org_information_context = 'Project Burdening Hierarchy'
           AND to_number(org_information1) = p_org_structure_id;

Line: 73

        /* Replacing the above SELECT with the below SELECT statement. */
        SELECT 'X'
          INTO dummy1
          FROM sys.dual
         WHERE exists (
            SELECT 'X'
              FROM pa_ind_rate_sch_revisions ind
             WHERE ind.organization_structure_id = p_org_structure_id
             );

Line: 103

    dummy1		VARCHAR2(4);	--	into arg for main SELECT

Line: 105

    select 'X'
    from  pa_implementations_all pai
    where ( (p_org_structure_version_id = pai.org_structure_version_id)
           OR (p_org_structure_version_id = pai.proj_org_structure_version_id)
           OR (p_org_structure_version_id = pai.exp_org_structure_version_id)
          );

Line: 139

          SELECT 'X'
          INTO dummy1
          FROM hr_organization_information
         WHERE organization_id = pa_utils.business_group_id
           AND org_information_context = 'Project Burdening Hierarchy'
           AND to_number(org_information2) = p_org_structure_version_id;

Line: 147

        /* Replacing the above SELECT with the below SELECT statement. */
        SELECT 'X'
          INTO dummy1
          FROM sys.dual
         WHERE exists (
            SELECT 'X'
              FROM pa_ind_rate_sch_revisions ind
             WHERE ind.org_structure_version_id = p_org_structure_version_id
             );

Line: 178

    dummy1		VARCHAR2(4); --	into arg for main SELECT

Line: 182

        SELECT  'X' /* Reporting Start Org */
	FROM    pa_implementations_all pai,
		per_org_structure_elements ose
	WHERE   p_org_structure_element_id = ose.org_structure_element_id
	AND     pai.org_structure_version_id = ose.org_structure_version_id
	AND     pai.start_organization_id   = ose.organization_id_child
               union
        SELECT  'X' /* Project Start Org */
	FROM    pa_implementations_all pai,
		per_org_structure_elements ose
	WHERE   p_org_structure_element_id = ose.org_structure_element_id
	AND     pai.proj_org_structure_version_id = ose.org_structure_version_id
	AND     pai.proj_start_org_id   = ose.organization_id_child
               union
        SELECT  'X' /* Exp Start Org */
	FROM    pa_implementations_all pai,
		per_org_structure_elements ose
	WHERE   p_org_structure_element_id = ose.org_structure_element_id
	AND     pai.exp_org_structure_version_id = ose.org_structure_version_id
	AND     pai.exp_start_org_id   = ose.organization_id_child
               UNION /* Added for bug 5405854 - Burdening start org */
        SELECT  'X'
        FROM    pa_ind_rate_sch_revisions ind,
                per_org_structure_elements ose
        WHERE   ose.org_structure_element_id = p_org_structure_element_id
	AND     ind.org_structure_version_id = ose.org_structure_version_id
        AND     ind.start_organization_id = ose.organization_id_child
      ) ;

Line: 224

        hr_utility.set_message (275,'PA_ORG_CANT_DELETE_STARTORG'); /* Message_name changed for bug fix 1713199 */

Line: 239

             SELECT 'X'
               INTO dummy1
               FROM sys.dual
              WHERE p_org_structure_element_id IN (
		 SELECT org_structure_element_id
		 FROM hr_organization_information info,
		      per_org_structure_elements ose
		 WHERE info.organization_id = pa_utils.business_group_id
		 AND ose.business_group_id = pa_utils.business_group_id
		 AND info.org_information_context = 'Project Burdening Hierarchy'
                 AND to_number(info.org_information2) = ose.org_structure_version_id
                 );

Line: 252

              /* Replacing the above SELECT with the below SELECT statement. */
              /* Check if the organization being deleted is used in Burdening */
-- hr_utility.trace('before check');

Line: 256

              SELECT 'X'
                INTO dummy1
                FROM sys.dual
               WHERE exists (
                     SELECT icm.organization_id
                       FROM pa_ind_cost_multipliers icm,
                            per_org_structure_elements ose
                      WHERE ose.org_structure_element_id = p_org_structure_element_id
                        AND ose.organization_id_child = icm.organization_id);

Line: 290

    dummy1		VARCHAR2(4); --	into arg for main SELECT

Line: 293

      select 'X'
      from   pa_all_organizations
      where organization_id = p_org_id;

Line: 298

      select 'X'
      from   pa_non_labor_resource_orgs
      where organization_id = p_org_id;

Line: 303

      select 'X'
      from pa_std_bill_rate_schedules
      where organization_id = p_org_id;