DBA Data[Home] [Help]

APPS.PA_CUSTOMERS_CONTACTS_UTILS dependencies on PA_IMPLEMENTATIONS

Line 1040: FROM pa_implementations_all

1036: WHERE project_id = c_project_id) AND
1037: (b.cc_prvdr_flag = 'N' OR b.cc_prvdr_flag is NULL);
1038: CURSOR C2(c_customer_id NUMBER) IS
1039: SELECT '1'
1040: FROM pa_implementations_all
1041: WHERE customer_id = c_customer_id;
1042: CURSOR C3 IS
1043: SELECT '1'
1044: FROM pa_implementations

Line 1044: FROM pa_implementations

1040: FROM pa_implementations_all
1041: WHERE customer_id = c_customer_id;
1042: CURSOR C3 IS
1043: SELECT '1'
1044: FROM pa_implementations
1045: WHERE cc_ic_billing_prvdr_flag = 'Y';
1046: BEGIN
1047: open C1(p_project_id);
1048: fetch C1 into l_dummy;

Line 1357: FROM pa_implementations;

1353: x_org_id NUMBER;
1354: BEGIN
1355: SELECT org_id
1356: INTO x_org_id
1357: FROM pa_implementations;
1358: return x_org_id;
1359: EXCEPTION
1360: when OTHERS then
1361: null;