APPS.PA_CROSS_BUSINESS_GRP SQL Statements

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

Line: 64

        	SELECT job_group_id
        	INTO l_From_Job_Grp_Id
        	FROM per_jobs
        	WHERE job_id = P_From_Job_Id ;

Line: 88

        		select to_job_id
			into l_To_Job_Id
        		from pa_job_relationships_view
        		where from_job_id = P_From_Job_Id
        		and   to_job_group_id = P_To_Job_Group_Id ;

Line: 197

	select to_job_id
	from pa_job_relationships_view
	where from_job_id = from_job_id
	and   to_job_group_id = to_grp_id ;

Line: 267

                        SELECT job_group_id
                        INTO l_From_Job_Grp_Id
                        FROM per_jobs
                        WHERE job_id = P_From_Job_Id_Tab(j) ;

Line: 408

		/* Based on the profile HR_CROSS_BUSINESS_GROUP this select statement will
                 * return the master group id.  Note that the way it is written if the customer
                 * has more than a single master group  or no master group for either the
                 * enterprise or the business group defined then either TOO MANY ROWS or
                 * NO DATA FOUND will occur and will be handled appropriately in the
                 * exception handler.  This can occur since HR is not restricting the form
                 * they are creating in this way, so we have to check and handle this in PA.
		 */
		select job_group_id
		into x_master_grp_id
		from per_job_groups
		where pa_cross_business_grp.IsCrossBGProfile = 'N'
		and business_group_id = P_Business_group_Id
		and master_flag = 'Y'
		 UNION ALL
		select job_group_id
		from per_job_groups
		where pa_cross_business_grp.IsCrossBGProfile = 'Y'
		and master_flag = 'Y' ;

Line: 499

	Select decode(business_group_id,NULL,'Y','N')
	into X_Global_Hierarchy
	from per_organization_structures
	where  organization_structure_id = P_Org_Structure_id ;

Line: 680

	select decode(P_Group_Type,'C',cost_job_group_id,'B',bill_job_group_id)
	into l_JobGroupId
	from pa_projects_all
	where project_id = P_Project_Id ;

Line: 742

	SELECT JOB_GROUP_ID
	INTO JobGroup
	FROM PER_JOB_GROUPS
	WHERE BUSINESS_GROUP_ID = P_Business_Group_Id
	AND   INTERNAL_NAME LIKE 'HR_%';