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_PROJECT_PVT dependencies on PA_PROJECT_TYPES_ALL

Line 587: PA_PROJECT_TYPES_ALL ppta

583: IS
584: SELECT 'Y'
585: FROM PA_VALID_CATEGORIES_V vc,
586: PA_PROJECTS_ALL ppa,
587: PA_PROJECT_TYPES_ALL ppta
588: WHERE ppa.project_id = c_project_id
589: AND ppa.project_type = ppta.project_type
590: AND nvl(ppa.org_id, -99) = nvl(ppta.org_id, -99)
591: AND ppta.project_type_id = vc.object_type_id

Line 604: PA_PROJECT_TYPES_ALL PPTA,

600: (
601: SELECT 'Y'
602: FROM PA_CLASS_CATEGORIES cc,
603: PA_VALID_CATEGORIES vc,
604: PA_PROJECT_TYPES_ALL PPTA,
605: PA_PROJECTS_ALL PPA
606: WHERE PPA.PROJECT_ID = c_project_id
607: AND PPA.PROJECT_TYPE = PPTA.PROJECT_TYPE
608: -- AND nvl(PPA.ORG_ID, -99) = nvl(PPTA.ORG_ID, -99) - R12: Bug 4364092

Line 11001: FROM pa_std_bill_rate_schedules_all brs, pa_project_types_all pt, pa_projects pa

10997: --R12: Bug 4363092 - removed nvl for org_id in below cursor
10998: CURSOR l_job_rate_sch_id_csr( p_job_bill_rate_schedule_id NUMBER)
10999: IS
11000: SELECT 'x'
11001: FROM pa_std_bill_rate_schedules_all brs, pa_project_types_all pt, pa_projects pa
11002: WHERE bill_rate_sch_id = p_job_bill_rate_schedule_id
11003: AND brs.job_group_id=pt.bill_job_group_id
11004: and brs.schedule_type = 'JOB'
11005: AND pa.project_type=pt.project_type