APPS.PA_MC_BILLING_PUB dependencies on PA_TASKS

Line 74: FROM pa_tasks

70: IF (l_task_id IS NULL) AND (p_task_number IS NOT NULL) THEN
71:
72: SELECT task_id
73: INTO l_task_id
74: FROM pa_tasks
75: WHERE task_number = p_task_number
76: AND Project_ID = l_project_id; -- Added for Bug 2675566
77:
78: END IF;

Line 208: FROM pa_tasks

204: IF (l_task_id IS NULL) AND (p_task_number IS NOT NULL) THEN
205:
206: SELECT task_id
207: INTO l_task_id
208: FROM pa_tasks
209: WHERE task_number = p_task_number
210: AND Project_ID = l_project_id; -- Added for Bug 2675566
211:
212: END IF;

Line 315: FROM pa_tasks

311: IF (l_task_id IS NULL) AND (p_task_number IS NOT NULL) THEN
312:
313: SELECT task_id
314: INTO l_task_id
315: FROM pa_tasks
316: WHERE task_number = p_task_number
317: AND Project_ID = l_project_id; -- Added for Bug 2675566
318:
319: END IF;

Line 423: FROM pa_tasks

419: IF (l_task_id IS NULL) AND (p_task_number IS NOT NULL) THEN
420:
421: SELECT task_id
422: INTO l_task_id
423: FROM pa_tasks
424: WHERE task_number = p_task_number
425: AND Project_ID = l_project_id; -- Added for Bug 2675566
426:
427: END IF;

Line 531: FROM pa_tasks

527: IF (l_task_id IS NULL) AND (p_task_number IS NOT NULL) THEN
528:
529: SELECT task_id
530: INTO l_task_id
531: FROM pa_tasks
532: WHERE task_number = p_task_number
533: AND Project_ID = l_project_id; -- Added for Bug 2675566
534:
535: END IF;