DBA Data[Home] [Help]

APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_CUSTOMERS_V

Line 566: PA_CUSTOMERS_V PCV

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;
570:

Line 607: PA_CUSTOMERS_V PCV

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;
611: