APPS.PA_TASKS_MAINT_PVT dependencies on PA_PROJECTS_ALL

Line 617: FROM PA_PROJECTS_ALL pa,

613: --End PA L Capital Project changes 2872708
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

Line 625: FROM PA_PROJECTS_ALL

621: pa.ORG_ID = pt.ORG_ID;--MOAC Changes: Bug 4363092 : removed nvl usage with org_id
622:
623: CURSOR work_type_from_proj IS
624: SELECT WORK_TYPE_ID, PROJECT_TYPE, CARRYING_OUT_ORGANIZATION_ID
625: FROM PA_PROJECTS_ALL
626: WHERE PROJECT_ID = p_project_id;
627:
628: /* Commented for bug#3512486
629: CURSOR work_type_from_proj_type(v_project_type VARCHAR2) IS

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:

Line 2846: from pa_projects_all

2842: IF (p_receive_project_invoice_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_receive_project_invoice_flag IS NULL ) THEN
2843: --dbms_output.put_line( 'In update task 16' );
2844:
2845: select project_type INTO TPROJECT_TYPE
2846: from pa_projects_all
2847: where project_id = p_project_id;
2848: PA_TASKS_MAINT_UTILS.Check_Chargeable_Flag( p_chargeable_flag => TCHARGEABLE,
2849: p_receive_project_invoice_flag => p_receive_project_invoice_flag,
2850: p_project_type => TPROJECT_TYPE,