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 208: L_Project_Id Pa_projects_all.project_id%type; /*Added varaible for bug#12922795 */

204: Is
205:
206: L_Allowed Varchar2(1) := 'N';
207: l_Found BOOLEAN := FALSE;
208: L_Project_Id Pa_projects_all.project_id%type; /*Added varaible for bug#12922795 */
209:
210: Begin
211:
212: L_Project_Id := NVL(P_Project_Id,0); /*Modified for bug#12922795 */

Line 244: From Pa_Projects_All P,

240: --Dbms_Output.Put_Line('select');
241:
242: Select I.Xface_Cwk_Timecards_Flag
243: Into L_Allowed
244: From Pa_Projects_All P,
245: Pa_Implementations_All I
246: Where P.Project_Id = L_Project_Id /*Modified for bug#12922795 */
247: AND p.org_id = i.org_id; -- bug 5365269
248: -- And nvl(P.Org_Id, -99) = nvl(I.Org_Id, -99); -- bug 5365269