DBA Data[Home] [Help]

APPS.OZF_AR_INTERFACE_PVT dependencies on HZ_CUST_ACCT_SITES

Line 1065: FROM hz_cust_acct_sites cas

1061:
1062: CURSOR csr_shipto_site(p_shipto_site_id IN NUMBER) IS
1063: SELECT cas.cust_account_id
1064: , cas.cust_acct_site_id
1065: FROM hz_cust_acct_sites cas
1066: , hz_cust_site_uses csu
1067: WHERE cas.cust_acct_site_id = csu.cust_acct_site_id
1068: AND csu.site_use_id = p_shipto_site_id;
1069:

Line 1113: , hz_cust_acct_sites site

1109:
1110: CURSOR csr_cust_site_pay_term(cv_cust_account_id IN NUMBER, cv_site_use_id IN NUMBER) IS
1111: SELECT use.payment_term_id
1112: FROM hz_cust_site_uses use
1113: , hz_cust_acct_sites site
1114: WHERE site.cust_acct_site_id = use.cust_acct_site_id
1115: AND site.cust_account_id = cv_cust_account_id
1116: AND use.site_use_id = cv_site_use_id;
1117: