DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 3345: FROM HZ_CUST_SITE_USES_ALL SITE,

3341: IF x_credit_level = 'CUSTOMER' AND l_credit_profile_level ='CUSTOMER' THEN
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'

Line 3356: FROM HZ_CUST_SITE_USES_ALL SITE,

3352: AND SITE.ORG_ID = ACCT_SITE.ORG_ID;
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'