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 1669: /* select adj_on_std_inv into l_adj_on_std_inv from pa_projects_all where project_id =p_project_id;

1665:
1666:
1667: /* Added for 12.2Payroll billing ER 11899223 */
1668: if l_parent_task_Id is null then
1669: /* select adj_on_std_inv into l_adj_on_std_inv from pa_projects_all where project_id =p_project_id;
1670: commented for bug 12659208 */
1671:
1672: l_adj_on_std_inv := NULL;
1673: else

Line 2864: from pa_projects_all

2860: IF (p_receive_project_invoice_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR OR p_receive_project_invoice_flag IS NULL ) THEN
2861: --dbms_output.put_line( 'In update task 16' );
2862:
2863: select project_type INTO TPROJECT_TYPE
2864: from pa_projects_all
2865: where project_id = p_project_id;
2866: PA_TASKS_MAINT_UTILS.Check_Chargeable_Flag( p_chargeable_flag => TCHARGEABLE,
2867: p_receive_project_invoice_flag => p_receive_project_invoice_flag,
2868: p_project_type => TPROJECT_TYPE,