DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on HZ_PARTY_SITES

Line 3346: HZ_PARTY_SITES PARTY_SITE,

3342:
3343: SELECT acct_site.cust_account_id
3344: INTO l_new_cust_account_id
3345: FROM HZ_CUST_SITE_USES_ALL SITE,
3346: HZ_PARTY_SITES PARTY_SITE,
3347: HZ_CUST_ACCT_SITES ACCT_SITE
3348: WHERE SITE.SITE_USE_ID = OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).new_invoice_to_org_id
3349: AND SITE.SITE_USE_CODE = 'BILL_TO'
3350: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 3357: HZ_PARTY_SITES PARTY_SITE,

3353:
3354: SELECT acct_site.cust_account_id
3355: INTO l_old_cust_account_id
3356: FROM HZ_CUST_SITE_USES_ALL SITE,
3357: HZ_PARTY_SITES PARTY_SITE,
3358: HZ_CUST_ACCT_SITES ACCT_SITE
3359: WHERE SITE.SITE_USE_ID = OE_CREDIT_CHECK_UTIL.G_CC_Invoice_tab(i).old_invoice_to_org_id
3360: AND SITE.SITE_USE_CODE = 'BILL_TO'
3361: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID