1371: X_Request_Id IN NUMBER,
1372: X_Err_Code IN OUT NOCOPY NUMBER,
1373: X_Err_Buff IN OUT NOCOPY VARCHAR2) IS
1374:
1375: X_Customer_Id pa_project_customers.customer_id%type;
1376: X_Bill_To_Site_Use_Id hz_cust_site_uses.site_use_id%type;
1377: X_Ship_To_Site_Use_Id hz_cust_site_uses.site_use_id%type;
1378:
1379: /* This Cursor fetches expenditure items for which tax codes has to be calculated */
1422:
1423: -- Bug Fix 2994625
1424: -- Added new local variables to store bill_to_customer_id and ship_to_customer_id
1425:
1426: l_Bill_to_customer_id PA_PROJECT_CUSTOMERS.BILL_TO_CUSTOMER_ID%TYPE;
1427: l_Ship_to_customer_id PA_PROJECT_CUSTOMERS.SHIP_TO_CUSTOMER_ID%TYPE;
1428:
1429: -- End of Fix for Bug 2994625
1430:
1423: -- Bug Fix 2994625
1424: -- Added new local variables to store bill_to_customer_id and ship_to_customer_id
1425:
1426: l_Bill_to_customer_id PA_PROJECT_CUSTOMERS.BILL_TO_CUSTOMER_ID%TYPE;
1427: l_Ship_to_customer_id PA_PROJECT_CUSTOMERS.SHIP_TO_CUSTOMER_ID%TYPE;
1428:
1429: -- End of Fix for Bug 2994625
1430:
1431: Begin
1467: l_bill_to_customer_id,
1468: l_ship_to_customer_id,
1469: X_Bill_To_Site_Use_Id,
1470: X_Ship_To_Site_Use_Id
1471: from pa_project_customers c,
1472: hz_cust_accounts cust_acct,
1473: hz_cust_site_uses ras,
1474: hz_cust_site_uses ras1
1475: where c.project_id = X_Award_Project_Id