APPS.PSP_XMLGEN dependencies on PA_TASKS_EXPEND_V

Line 1762: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug : 16391366

1758: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1759: WHERE paa.project_id = perd.project_id),
1760: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1761: WHERE gaa.award_id = perd.award_id),
1762: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug : 16391366
1763: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1764: WHERE haou.organization_id = perd.expenditure_organization_id),
1765: actual_salary_amt = NVL(actual_salary_amt, 0),
1766: payroll_percent = NVL(payroll_percent, 0),

Line 1821: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug 16391366

1817: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1818: WHERE paa.project_id = perd.project_id),
1819: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1820: WHERE gaa.award_id = perd.award_id),
1821: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug 16391366
1822: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1823: WHERE haou.organization_id = perd.expenditure_organization_id),
1824: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1825: WHERE papf.person_id = (SELECT person_id FROM gms_personnel gp

Line 1855: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug 16391366

1851: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1852: WHERE paa.project_id = perd.project_id),
1853: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1854: WHERE gaa.award_id = perd.award_id),
1855: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug 16391366
1856: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1857: WHERE haou.organization_id = perd.expenditure_organization_id),
1858: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1859: --- added max person_id for uva issue

Line 1890: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug 16391366

1886: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1887: WHERE paa.project_id = perd.project_id),
1888: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1889: WHERE gaa.award_id = perd.award_id),
1890: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug 16391366
1891: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1892: WHERE haou.organization_id = perd.expenditure_organization_id),
1893: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1894: WHERE papf.person_id = (select task_manager_person_id from pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id) -- Bug 16391366

Line 1894: WHERE papf.person_id = (select task_manager_person_id from pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id) -- Bug 16391366

1890: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id), -- Bug 16391366
1891: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1892: WHERE haou.organization_id = perd.expenditure_organization_id),
1893: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1894: WHERE papf.person_id = (select task_manager_person_id from pa_tasks_expend_v pt WHERE pt.task_id = perd.task_id) -- Bug 16391366
1895: AND papf.effective_start_date <= r_effort_report.r_end_date(I)
1896: AND papf.effective_end_date >= r_effort_report.r_start_date(I) AND ROWNUM = 1),
1897: actual_salary_amt = NVL(actual_salary_amt, 0),
1898: payroll_percent = NVL(payroll_percent, 0),