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_ADVERTISEMENTS_PVT dependencies on PA_PEOPLE_ROLE_ON_ORGS_V

Line 746: FROM pa_people_role_on_orgs_v pro, per_people_f pf

742: -- in the given organization
743:
744: CURSOR get_people_with_proj_authority IS
745: SELECT pro.person_name, pro.person_id
746: FROM pa_people_role_on_orgs_v pro, per_people_f pf
747: WHERE pro.organization_id = to_char(p_organization_id)
748: AND pro.project_role_type = '3'
749: AND sysdate between pro.start_date_active and
750: nvl(pro.end_date_active, sysdate)

Line 759: FROM pa_people_role_on_orgs_v

755:
756: /* Changed the cursor as above for bug 4600093
757: CURSOR get_people_with_proj_authority IS
758: SELECT person_name, person_id
759: FROM pa_people_role_on_orgs_v
760: WHERE organization_id = to_char(p_organization_id)
761: AND project_role_type = '3'
762: AND sysdate between start_date_active and nvl(end_date_active, sysdate);
763: */