APPS.CSTPPDOP SQL Statements

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

Line: 34

	select	count(1)
	into 	dummy
	from
        	CST_LE_COST_TYPES CLCT,
        	CST_ACCT_INFO_V OOD,
        	MTL_PARAMETERS MP
	where
        	clct.set_of_books_id = ood.LEDGER_ID
	AND     ood.LEGAL_ENTITY = p_legal_entity
	AND     ood.organization_id IN (    SELECT  ccga.organization_id
       		                            FROM    cst_cost_group_assignments ccga,
                                         	    cst_cost_groups ccg
                                    	    WHERE   ccg.legal_entity = p_legal_entity
                                            AND     ccga.cost_group_id = ccg.cost_group_id )
	AND     clct.legal_entity  = p_legal_entity
	AND     clct.cost_type_id  = p_cost_type_id
	AND	clct.primary_cost_method > 2
	AND     mp.organization_id = ood.organization_id
	AND     mp.general_ledger_update_code <> 3
	AND     ROWNUM < 2 ;

Line: 68

	SELECT  count(*)
	INTO	dummy
	FROM    cst_le_cost_types clct
	WHERE   clct.legal_entity = p_legal_entity
	AND     clct.cost_type_id <> p_cost_type_id
	AND	clct.set_of_books_id = (SELECT	clct1.set_of_books_id
					FROM	cst_le_cost_types clct1
					WHERE	clct1.cost_type_id = p_cost_type_id
					AND	clct1.legal_entity = p_legal_entity
					AND	clct.primary_cost_method > 2)
	AND     clct.post_to_gl = 'Y';

Line: 101

	SELECT	count(1)
	INTO	dummy
	FROM
        	cst_le_cost_types clct,
        	 CST_ACCT_INFO_V ood,
        	mtl_parameters mp
	WHERE
        	clct.set_of_books_id = ood.LEDGER_ID
	AND     ood.organization_id  = p_org_id
	AND     ood.organization_id  = mp.organization_id
	AND     clct.legal_entity    = (     SELECT  distinct ccg.legal_entity
       		                             FROM    cst_cost_group_assignments ccga,
       		                                     cst_cost_groups ccg
       		                             WHERE   ccga.organization_id = p_org_id
       		                             AND     ccga.cost_group_id = ccg.cost_group_id )
	AND     clct.post_to_gl = 'Y'
	AND     clct.primary_cost_method > 2
	AND     ROWNUM < 2;