APPS.PA_BILLING_VALIDATE dependencies on PA_PROJECTS

Line 55: FROM pa_tasks t, pa_projects p

51: dummy VARCHAR2(30);
52: BEGIN
53: SELECT 'Valid Proj/Task/Assgn'
54: INTO dummy
55: FROM pa_tasks t, pa_projects p
56: WHERE t.project_id = X2_project_id
57: AND t.top_task_id = nvl(X2_top_task_id, t.top_task_id)
58: AND t.project_id = p.project_id
59: AND rownum = 1;