DBA Data[Home] [Help]

APPS.PA_MULTI_CURRENCY_BILLING dependencies on PA_PROJECT_CUSTOMERS

Line 1310: FROM pa_project_customers

1306: is
1307:
1308: CURSOR cur_proj_cust IS
1309: SELECT 'x'
1310: FROM pa_project_customers
1311: WHERE INV_CURRENCY_CODE = p_curr_code
1312: AND project_id = p_project_id;
1313:
1314: v_dummy_char VARCHAR2(1);

Line 1350: WHERE Exists ( SELECt 1 FROM PA_Project_Customers

1346: BEGIN
1347: SELECT 'Y'
1348: INTO l_Flag
1349: FROM Dual
1350: WHERE Exists ( SELECt 1 FROM PA_Project_Customers
1351: WHERE Project_ID = p_Project_ID
1352: AND Inv_Currency_Code <> p_pfc_Currency_Code);
1353: EXCEPTION WHEN NO_DATA_FOUND THEN
1354: l_Flag := 'N';