APPS.RCV_DISTRIBUTIONS_S dependencies on PA_TASKS

Line 217: pa_tasks_expend_v pte

213: pte.task_number
214: INTO x_project_number,
215: x_task_number
216: FROM pjm_projects_all_v ppa,
217: pa_tasks_expend_v pte
218: WHERE ppa.project_id = x_project_id
219: AND pte.task_id = x_task_id
220: AND ppa.project_id = pte.project_id;*/
221:

Line 231: PA_TASKS T

227: T.TASK_NUMBER
228: into x_project_number,
229: x_task_number
230: from PA_PROJECTS_ALL p,
231: PA_TASKS T
232: where P.PROJECT_ID = T.PROJECT_ID
233: and p.project_id = x_project_id
234: and T.task_id = x_task_id;
235: ELSE

Line 717: --pa_tasks_expend_v PTE,

713: x_rate,
714: x_rate_date
715: FROM po_distributions_all POD, -- Bug 10203707
716: --pjm_projects_all_v PPA,
717: --pa_tasks_expend_v PTE,
718: mtl_kanban_cards MKC
719: WHERE POD.po_distribution_id = NVL(p_po_distribution_id,
720: POD.po_distribution_id)
721: AND POD.line_location_id = p_line_location_id

Line 735: PA_TASKS T

731: T.TASK_NUMBER
732: into x_project_number,
733: x_task_number
734: from PA_PROJECTS_ALL p,
735: PA_TASKS T
736: where P.PROJECT_ID = T.PROJECT_ID
737: and p.project_id = l_project_id
738: and T.task_id = l_task_id;
739: ELSE

Line 888: pa_tasks_expend_v pte

884: pte.task_number
885: INTO x_project_number,
886: x_task_number
887: FROM pjm_projects_all_v ppa,
888: pa_tasks_expend_v pte
889: WHERE ppa.project_id = x_project_id
890: AND pte.task_id = x_task_id
891: AND ppa.project_id = pte.project_id;*/
892:

Line 900: PA_TASKS T

896: T.TASK_NUMBER
897: into x_project_number,
898: x_task_number
899: from PA_PROJECTS_ALL p,
900: PA_TASKS T
901: where P.PROJECT_ID = T.PROJECT_ID
902: and p.project_id = x_project_id
903: and T.task_id = x_task_id;
904: ELSE