DBA Data[Home] [Help]

APPS.PA_PJC_CWK_UTILS dependencies on PA_PROJECTS_ALL

Line 169: From Pa_Projects_All P,

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 (

Line 238: From Pa_Projects_All P,

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