APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_PROJECT_CUSTOMERS

Line 552: FROM PA_PROJECT_CUSTOMERS PPC,

548: -- 3703272 Included substrb in the Cursor select statement while retrieving Customer Name
549: CURSOR C1 (c_project_id NUMBER)
550: IS
551: Select PPC.customer_id, NVL(PPC.customer_bill_split,0) bill_split, substrb(PCV.customer_name,1,50)
552: FROM PA_PROJECT_CUSTOMERS PPC,
553: PA_CUSTOMERS_V PCV
554: WHERE PPC.project_id = c_project_id
555: AND PPC.customer_id = PCV.customer_id
556: ORDER BY bill_split DESC, customer_name;

Line 593: FROM PA_PROJECT_CUSTOMERS PPC,

589:
590: CURSOR C1 (c_project_id NUMBER)
591: IS
592: Select PPC.customer_id, NVL(PPC.customer_bill_split,0) bill_split, substrb(PCV.customer_name,1,50)
593: FROM PA_PROJECT_CUSTOMERS PPC,
594: PA_CUSTOMERS_V PCV
595: WHERE PPC.project_id = c_project_id
596: AND PPC.customer_id = PCV.customer_id
597: ORDER BY bill_split DESC, customer_name;