eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_XMLGEN dependencies on PA_TASKS

Line 1735: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),

1731: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1732: WHERE paa.project_id = perd.project_id),
1733: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1734: WHERE gaa.award_id = perd.award_id),
1735: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),
1736: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1737: WHERE haou.organization_id = perd.expenditure_organization_id),
1738: actual_salary_amt = NVL(actual_salary_amt, 0),
1739: payroll_percent = NVL(payroll_percent, 0),

Line 1792: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),

1788: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1789: WHERE paa.project_id = perd.project_id),
1790: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1791: WHERE gaa.award_id = perd.award_id),
1792: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),
1793: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1794: WHERE haou.organization_id = perd.expenditure_organization_id),
1795: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1796: WHERE papf.person_id = (SELECT person_id FROM gms_personnel gp

Line 1824: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),

1820: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1821: WHERE paa.project_id = perd.project_id),
1822: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1823: WHERE gaa.award_id = perd.award_id),
1824: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),
1825: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1826: WHERE haou.organization_id = perd.expenditure_organization_id),
1827: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1828: --- added max person_id for uva issue

Line 1857: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),

1853: (project_name, project_number) = (SELECT name, segment1 FROM pa_projects_all paa
1854: WHERE paa.project_id = perd.project_id),
1855: (award_short_name, award_number) = (SELECT award_short_name, award_number FROM gms_awards_all gaa
1856: WHERE gaa.award_id = perd.award_id),
1857: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),
1858: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1859: WHERE haou.organization_id = perd.expenditure_organization_id),
1860: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1861: WHERE papf.person_id = (select task_manager_person_id from pa_tasks pt WHERE pt.task_id = perd.task_id)

Line 1861: WHERE papf.person_id = (select task_manager_person_id from pa_tasks pt WHERE pt.task_id = perd.task_id)

1857: (task_name, task_number) = (SELECT task_name, task_number FROM pa_tasks pt WHERE pt.task_id = perd.task_id),
1858: exp_org_name = (SELECT name FROM hr_all_organization_units haou
1859: WHERE haou.organization_id = perd.expenditure_organization_id),
1860: (investigator_name, investigator_person_id) = (SELECT full_name, person_id FROM per_all_people_f papf
1861: WHERE papf.person_id = (select task_manager_person_id from pa_tasks pt WHERE pt.task_id = perd.task_id)
1862: AND papf.effective_start_date <= r_effort_report.r_end_date(I)
1863: AND papf.effective_end_date >= r_effort_report.r_start_date(I) AND ROWNUM = 1),
1864: actual_salary_amt = NVL(actual_salary_amt, 0),
1865: payroll_percent = NVL(payroll_percent, 0),