APPS.RCV_DISTRIBUTIONS_S dependencies on PA_TASKS

Line 166: pa_tasks_expend_v pte

162: pte.task_number
163: INTO x_project_number,
164: x_task_number
165: FROM pjm_projects_all_v ppa,
166: pa_tasks_expend_v pte
167: WHERE ppa.project_id = x_project_id
168: AND pte.task_id = x_task_id
169: AND ppa.project_id = pte.project_id;*/
170:

Line 180: PA_TASKS T

176: T.TASK_NUMBER
177: into x_project_number,
178: x_task_number
179: from PA_PROJECTS_ALL p,
180: PA_TASKS T
181: where P.PROJECT_ID = T.PROJECT_ID
182: and p.project_id = x_project_id
183: and T.task_id = x_task_id;
184: ELSE

Line 666: --pa_tasks_expend_v PTE,

662: x_rate,
663: x_rate_date
664: FROM po_distributions POD,
665: --pjm_projects_all_v PPA,
666: --pa_tasks_expend_v PTE,
667: mtl_kanban_cards MKC
668: WHERE POD.po_distribution_id = NVL(p_po_distribution_id,
669: POD.po_distribution_id)
670: AND POD.line_location_id = p_line_location_id

Line 684: PA_TASKS T

680: T.TASK_NUMBER
681: into x_project_number,
682: x_task_number
683: from PA_PROJECTS_ALL p,
684: PA_TASKS T
685: where P.PROJECT_ID = T.PROJECT_ID
686: and p.project_id = l_project_id
687: and T.task_id = l_task_id;
688: ELSE

Line 837: pa_tasks_expend_v pte

833: pte.task_number
834: INTO x_project_number,
835: x_task_number
836: FROM pjm_projects_all_v ppa,
837: pa_tasks_expend_v pte
838: WHERE ppa.project_id = x_project_id
839: AND pte.task_id = x_task_id
840: AND ppa.project_id = pte.project_id;*/
841:

Line 849: PA_TASKS T

845: T.TASK_NUMBER
846: into x_project_number,
847: x_task_number
848: from PA_PROJECTS_ALL p,
849: PA_TASKS T
850: where P.PROJECT_ID = T.PROJECT_ID
851: and p.project_id = x_project_id
852: and T.task_id = x_task_id;
853: ELSE