APPS.PA_CUSTOMERS_CONTACTS_UTILS dependencies on PA_PROJECT_CUSTOMERS

Line 719: FROM pa_project_customers

715: IS
716: l_dummy VARCHAR2(1) := NULL;
717: CURSOR C(c_project_id NUMBER, c_customer_id NUMBER) IS
718: SELECT 'x'
719: FROM pa_project_customers
720: WHERE project_id = p_project_id AND
721: customer_id = p_customer_id;
722: BEGIN
723: if (p_customer_id is not null) then

Line 844: FROM pa_project_customers

840: IS
841: l_total NUMBER;
842: CURSOR C(c_project_id NUMBER, c_customer_id NUMBER) IS
843: SELECT sum(customer_bill_split)
844: FROM pa_project_customers
845: WHERE project_id = c_project_id AND
846: customer_id <> c_customer_id;
847: BEGIN
848: open C(p_project_id, p_customer_id);

Line 932: to avoid full table scan of pa_project_customers -Bug 2782177 */

928: FROM pa_projects_all
929: WHERE project_id = c_project_id);
930:
931: /* Changed the having condition to the where condition in the following cursor c2
932: to avoid full table scan of pa_project_customers -Bug 2782177 */
933:
934: CURSOR C2(c_project_id NUMBER) IS
935: SELECT count(customer_id) count, sum(customer_bill_split) sum
936: FROM pa_project_customers

Line 936: FROM pa_project_customers

932: to avoid full table scan of pa_project_customers -Bug 2782177 */
933:
934: CURSOR C2(c_project_id NUMBER) IS
935: SELECT count(customer_id) count, sum(customer_bill_split) sum
936: FROM pa_project_customers
937: WHERE project_id = c_project_id
938: GROUP BY project_id;
939:
940: CURSOR C3(c_project_id NUMBER, c_customer_id NUMBER) IS

Line 942: FROM pa_project_customers

938: GROUP BY project_id;
939:
940: CURSOR C3(c_project_id NUMBER, c_customer_id NUMBER) IS
941: SELECT '1'
942: FROM pa_project_customers
943: WHERE project_id = c_project_id AND
944: customer_id = c_customer_id;
945:
946: l_dummy VARCHAR2(1) := NULL;

Line 1261: FROM pa_project_customers

1257:
1258:
1259: CURSOR C3(c_project_id NUMBER, c_customer_id NUMBER) IS
1260: SELECT customer_bill_split
1261: FROM pa_project_customers
1262: WHERE project_id = c_project_id AND
1263: customer_id = c_customer_id;
1264: BEGIN
1265: open C1(p_project_id);

Line 1422: FROM pa_project_customers

1418: IS
1419: l_total NUMBER;
1420: CURSOR C(c_project_id NUMBER) IS
1421: SELECT sum(customer_bill_split)
1422: FROM pa_project_customers
1423: WHERE project_id = c_project_id;
1424: BEGIN
1425: OPEN C(p_project_id);
1426: FETCH C INTO l_total;

Line 1490: pa_project_customers proj_cust,

1486: HZ_P.party_name ,
1487: HZ_P.party_number,
1488: 'Y'
1489: FROM
1490: pa_project_customers proj_cust,
1491: hz_cust_accounts HZ_C,
1492: HZ_PARTIES HZ_P
1493: WHERE
1494: proj_cust.project_id = p_project_id