APPS.PA_FUND_REVAL_UTIL SQL Statements

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

Line: 37

		SELECT 'Y' INTO l_flag
		FROM DUAL
		WHERE exists (SELECT NULL FROM
			      PA_PROJECT_TYPES_ALL
			      WHERE org_id = p_org_id
	    /*  WHERE NVL(org_id,-99) = NVL(p_org_id,-99)  Bug 5900353*/
				AND NVL(include_gains_losses_flag,'N') ='Y');

Line: 58

		SELECT 'Y' INTO l_flag
		FROM DUAL
		WHERE exists (SELECT NULL FROM
			      PA_PROJECTS_ALL
			      WHERE org_id = p_org_id
			    /*  WHERE NVL(org_id,-99) = NVL(p_org_id,-99)  Bug 5900353*/
				AND NVL(include_gains_losses_flag,'N') ='Y');

Line: 78

		SELECT 'Y' INTO l_flag
		FROM DUAL
		WHERE exists (SELECT NULL FROM
		        PA_EVENTS evt, PA_PROJECTS_ALL pr,
		        PA_EVENT_TYPES evttyp
			WHERE pr.org_id = p_org_id
			/*  WHERE NVL(pr.org_id,-99) = NVL(p_org_id,-99) Bug 5900353 */
		          AND evt.project_id = pr.project_id
		          AND evt.event_type = evttyp.event_type
		          AND evttyp.event_type_classification in
				('REALIZED_GAINS','REALIZED_LOSSES'));

Line: 106

		SELECT NVL(imp.include_gains_losses_flag,'N')
		  INTO l_flag
		  FROM PA_IMPLEMENTATIONS_ALL imp
	         WHERE imp.org_id = p_org_id;

Line: 128

		SELECT NVL(pt.include_gains_losses_flag,'N')
		  INTO l_flag
		  FROM PA_PROJECT_TYPES_ALL pt
	         WHERE pt.org_id = p_org_id
	         /*  WHERE NVL(pt.org_id,-99) = NVL(p_org_id,-99)Bug 5900353  */
	           AND pt.project_type = p_project_type;