APPS.PJI_PMV_PREDICATE SQL Statements

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

Line: 16

				SELECT 1
				INTO l_Return_Value
				FROM pji_class_codes pjicc
				, pa_project_types_all papta
				WHERE
				pjicc.class_id = p_Class_Code
				AND pjicc.record_type = 'T'
				AND papta.project_type= pjicc.class_code
				AND papta.org_id = p_Org_ID;

Line: 26

				SELECT 1
				INTO l_Return_Value
				FROM pji_class_codes pjicc
				, pa_project_types_all papta
				WHERE
				pjicc.class_id = p_Class_Code
				AND pjicc.class_category = p_Class_Category
				AND pjicc.record_type = 'T'
				AND papta.project_type_class_code= SUBSTR(p_Class_Category,15)
				AND papta.project_type= pjicc.class_code
				AND papta.org_id = p_Org_ID;

Line: 40

					SELECT view_all_organizations_flag
					INTO l_Not_Secured_Flag
					FROM per_security_profiles prof
					WHERE security_profile_id = l_Security_Profile_ID;

Line: 47

					SELECT 1
					INTO l_Return_Value
					FROM pji_class_codes pjicc
					, pa_project_types_all papta
					, pa_implementations_all paimp
					WHERE
					pjicc.class_id = p_Class_Code
					AND pjicc.record_type = 'T'
					AND papta.project_type= pjicc.class_code
					AND paimp.org_id = papta.org_id;

Line: 58

					SELECT 1
					INTO l_Return_Value
					FROM pji_class_codes pjicc
					, pa_project_types_all papta
					, per_organization_list sec
					, pa_implementations_all paimp
					WHERE
					pjicc.class_id = p_Class_Code
					AND pjicc.record_type = 'T'
					AND papta.project_type= pjicc.class_code
					AND papta.org_id = sec.organization_id
					AND paimp.org_id = sec.organization_id
					AND sec.security_profile_id = l_Security_Profile_ID;

Line: 73

				SELECT 1
				INTO l_Return_Value
				FROM pji_class_codes
				WHERE
				class_id = p_Class_Code
				AND class_category = p_Class_Category;

Line: 103

			SELECT 1
			INTO l_Return_Value
			FROM
			pa_implementations_all paimp
			, gl_sets_of_books     glsob
			WHERE
			paimp.set_of_books_id = glsob.set_of_books_id
			and paimp.org_id = p_Org_ID
			and glsob.currency_code = p_Currency_Code;

Line: 135

            SELECT 1
            INTO l_Return_Value
            FROM pa_projects_all prj
			, pji_org_denorm pjd
            WHERE
            1=1
            AND project_id = p_Project_ID
            AND prj.carrying_out_organization_id = pjd.sub_organization_id
			AND pjd.organization_id = p_Organization_ID
            AND prj.org_id = p_Org_ID;

Line: 146

            SELECT 1
            INTO l_Return_Value
            FROM pa_projects_all prj
			, pji_org_denorm pjd
            WHERE
            1=1
            AND project_id = p_Project_ID
            AND prj.carrying_out_organization_id = pjd.sub_organization_id
			AND pjd.organization_id = p_Organization_ID;

Line: 176

        SELECT 1 into l_Return_Value
             FROM
                  pa_projects_all prj
      			, pji_org_denorm pjd
				, (SELECT project_id
			 	FROM pji_project_classes
			 	WHERE class_category = '$PROJECT_TYPE$'||p_Project_Type) PJC
            WHERE
            1=1
            and prj.project_id = pjc.project_id
            and prj.carrying_out_organization_id = pjd.sub_organization_id
            and prj.project_id = p_Project_ID
            and pjd.organization_id = p_Organization_ID
            and prj.org_id = p_Org_ID;

Line: 193

           SELECT 1 into l_Return_Value
            FROM
                 pa_projects_all prj
     			,pji_org_denorm pjd
				, (SELECT project_id
			 	FROM pji_project_classes
			 	WHERE class_category = '$PROJECT_TYPE$'||p_Project_type) PJC
            WHERE
            1=1
            and prj.project_id = pjc.project_id
            and prj.carrying_out_organization_id = pjd.sub_organization_id
            and prj.project_id = p_Project_ID
            and pjd.organization_id = p_Organization_ID;

Line: 225

			SELECT view_all_organizations_flag
			INTO l_Not_Secured_Flag
			FROM per_security_profiles prof
			WHERE security_profile_id = l_Security_Profile_ID;

Line: 230

				SELECT 1
				INTO l_Return_Value
				FROM pa_implementations_all imp
				WHERE org_id = p_Org_ID;

Line: 235

				SELECT 1
				INTO l_Return_Value
				FROM
				pa_implementations_all imp
				, per_organization_list list
				WHERE
				list.security_profile_id = l_Security_Profile_ID
				AND list.organization_id = p_Org_ID
				AND imp.org_id = list.organization_id;