APPS.GMS_BILLING dependencies on HZ_CUST_SITE_USES

Line 1376: X_Bill_To_Site_Use_Id hz_cust_site_uses.site_use_id%type;

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 */
1380: Cursor get_exp_items is

Line 1377: X_Ship_To_Site_Use_Id hz_cust_site_uses.site_use_id%type;

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 */
1380: Cursor get_exp_items is
1381: select --distinct

Line 1473: hz_cust_site_uses ras,

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
1476: -- and c.customer_id = rc.customer_id
1477: -- and nvl(rc.status,'A') = 'A'

Line 1474: hz_cust_site_uses ras1

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
1476: -- and c.customer_id = rc.customer_id
1477: -- and nvl(rc.status,'A') = 'A'
1478: and c.customer_id = cust_acct.cust_account_id