APPS.PA_CUSTOMERS_CONTACTS_PUB dependencies on PA_PROJECTS_ALL

Line 132: FROM pa_projects_all

128:
129: --Billing setup related changes for FP_M development. Tracking bug 3279981
130: CURSOR C4 IS
131: SELECT enable_top_task_customer_flag
132: FROM pa_projects_all
133: WHERE project_id = p_project_id;
134: l_en_top_task_cust_flag VARCHAR2(1);
135:
136: /* End For Bug 2731449 */

Line 144: FROM pa_projects_all

140: --sunkalya:federal bug#5511353
141: CURSOR cur_chk_funds_consumption_flag
142: IS
143: SELECT DATE_EFF_FUNDS_CONSUMPTION
144: FROM pa_projects_all
145: WHERE
146: project_id= p_project_id;
147:
148: l_date_eff_funds_consumption VARCHAR2(1);

Line 836: FROM pa_projects_all

832: AND related_cust_account_id = l_ship_to_customer_id;
833:
834: CURSOR C1(c_project_id NUMBER) IS
835: SELECT project_currency_code
836: FROM pa_projects_all
837: WHERE project_id = c_project_id;
838:
839: -- Changed reference from pa_project_customers_v (view) to pa_project_customers (base table)
840: -- for Performance Bug 4878827 SQL ID 14907728

Line 851: FROM pa_projects_all

847:
848: --Billing setup related changes for FP_M development. Tracking bug 3279981
849: CURSOR C6 IS
850: SELECT enable_top_task_customer_flag
851: FROM pa_projects_all
852: WHERE project_id = p_project_id;
853: l_en_top_task_cust_flag VARCHAR2(1);
854:
855: /* END For Bug 2731449 */

Line 862: FROM pa_projects_all

858:
859: CURSOR cur_chk_funds_consumption_flag
860: IS
861: SELECT DATE_EFF_FUNDS_CONSUMPTION
862: FROM pa_projects_all
863: WHERE
864: project_id= p_project_id;
865:
866: l_date_eff_funds_consumption VARCHAR2(1);