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.PA_PROGRESS_REPORT_WORKFLOW dependencies on PER_ASSIGNMENTS_F

Line 1322: per_assignments_f p1

1318: p2.full_name person_name
1319: from
1320: pa_proj_parties_prog_ev_v ppp,
1321: fnd_user fu,per_all_people_f p2,
1322: per_assignments_f p1
1323: where ppp.project_id = l_project_id
1324: and ppp.project_role_id = 1
1325: and ppp.resource_source_id = p1.person_id
1326: and p1.primary_flag='Y'

Line 1336: and exists ( select 1 from per_assignments_f p3

1332: and p1.effective_end_date -- Removed nvl for bug 2911451
1333: and trunc(sysdate) between fu.START_DATE and nvl(fu.END_DATE, sysdate+1)
1334: and trunc(sysdate) between ppp.START_DATE_active
1335: and nvl(ppp.END_DATE_active, sysdate+1)
1336: and exists ( select 1 from per_assignments_f p3
1337: where p3.person_id = p1.supervisor_id
1338: and p3.primary_flag='Y'
1339: and p3.Assignment_type in ('E', 'C')
1340: and trunc(sysdate) between p3.EFFECTIVE_START_DATE and Nvl(p3.effective_end_date, Sysdate + 1));