APPS.PA_TASKS_MAINT_PVT dependencies on PA_PROJECT_TYPES_ALL

Line 618: PA_PROJECT_TYPES_ALL pt

614: NULL,
615: --end bug 3032842
616: pa.Non_lab_std_bill_rt_sch_id -- Added for bug 4963525.
617: FROM PA_PROJECTS_ALL pa,
618: PA_PROJECT_TYPES_ALL pt
619: WHERE pa.PROJECT_ID = p_project_id and
620: pa.PROJECT_TYPE = pt.PROJECT_TYPE and
621: pa.ORG_ID = pt.ORG_ID;--MOAC Changes: Bug 4363092 : removed nvl usage with org_id
622:

Line 638: FROM PA_PROJECT_TYPES_ALL PT, PA_PROJECTS_ALL PA

634: /* Modified the cursor work_type_from_proj_type for bug#3512486 */
635: --MOAC Changes: Bug 4363092 : removed nvl usage with org_id
636: CURSOR work_type_from_proj_type(v_project_type VARCHAR2) IS
637: SELECT PT.WORK_TYPE_ID
638: FROM PA_PROJECT_TYPES_ALL PT, PA_PROJECTS_ALL PA
639: WHERE PT.PROJECT_TYPE = v_project_type
640: and PA.PROJECT_ID = p_project_id
641: and PA.ORG_ID = PT.ORG_ID;
642: