APPS.PA_IC_INV_UTILS dependencies on HZ_CUST_SITE_USES
Line 727: FROM HZ_CUST_SITE_USES
723: SITE_USE_ID
724: INTO P_SITE_STATUS,
725: P_SITE_USE_ID
726: /* FROM RA_SITE_USES Commented for TCA changes. */ 727: FROM HZ_CUST_SITE_USES 728: WHERE CUST_ACCT_SITE_ID = P_ADDRESS_ID /* The column address_id has been replaced with CUST_ACCT_SITE_ID for tca change */
729: AND SITE_USE_CODE = P_SITE_USE_CODE
730: AND STATUS = 'A';
731: