163: --Dbms_Output.Put_Line('select');
164:
165: Select 'Y'
166: Into L_Exists
167: From Dual
168: Where Exists (Select 1
169: From Pa_Projects_All P,
170: Po_Distributions_All Po
171: Where nvl(P.Org_Id, -99) = nvl(P_Org_Id, -99)