APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_PROJECT_CUSTOMERS

Line 565: FROM PA_PROJECT_CUSTOMERS PPC,

561: -- 3703272 Included substrb in the Cursor select statement while retrieving Customer Name
562: CURSOR C1 (c_project_id NUMBER)
563: IS
564: Select PPC.customer_id, NVL(PPC.customer_bill_split,0) bill_split, substrb(PCV.customer_name,1,50)
565: FROM PA_PROJECT_CUSTOMERS PPC,
566: PA_CUSTOMERS_V PCV
567: WHERE PPC.project_id = c_project_id
568: AND PPC.customer_id = PCV.customer_id
569: ORDER BY bill_split DESC, customer_name;

Line 606: FROM PA_PROJECT_CUSTOMERS PPC,

602:
603: CURSOR C1 (c_project_id NUMBER)
604: IS
605: Select PPC.customer_id, NVL(PPC.customer_bill_split,0) bill_split, substrb(PCV.customer_name,1,50)
606: FROM PA_PROJECT_CUSTOMERS PPC,
607: PA_CUSTOMERS_V PCV
608: WHERE PPC.project_id = c_project_id
609: AND PPC.customer_id = PCV.customer_id
610: ORDER BY bill_split DESC, customer_name;