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)
172: And P.Project_Id = Po.Project_Id
173: And PA_PJC_CWK_UTILS.is_rate_based_line (
234: --Dbms_Output.Put_Line('select');
235:
236: Select I.Xface_Cwk_Timecards_Flag
237: Into L_Allowed
238: From Pa_Projects_All P,
239: Pa_Implementations_All I
240: Where P.Project_Id = P_Project_Id
241: AND p.org_id = i.org_id; -- bug 5365269
242: -- And nvl(P.Org_Id, -99) = nvl(I.Org_Id, -99); -- bug 5365269