APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_PROJECT_CUSTOMERS

Line 1303: FROM pa_project_customers

1299: is
1300:
1301: CURSOR cur_proj_cust IS
1302: SELECT 'x'
1303: FROM pa_project_customers
1304: WHERE INV_CURRENCY_CODE = p_curr_code
1305: AND project_id = p_project_id;
1306:
1307: v_dummy_char VARCHAR2(1);

Line 1343: WHERE Exists ( SELECt 1 FROM PA_Project_Customers

1339: BEGIN
1340: SELECT 'Y'
1341: INTO l_Flag
1342: FROM Dual
1343: WHERE Exists ( SELECt 1 FROM PA_Project_Customers
1344: WHERE Project_ID = p_Project_ID
1345: AND Inv_Currency_Code <> p_pfc_Currency_Code);
1346: EXCEPTION WHEN NO_DATA_FOUND THEN
1347: l_Flag := 'N';