DBA Data[Home] [Help]

APPS.OZF_AR_INTERFACE_PVT dependencies on HZ_CUST_ACCT_SITES

Line 1061: FROM hz_cust_acct_sites cas

1057:
1058: CURSOR csr_shipto_site(p_shipto_site_id IN NUMBER) IS
1059: SELECT cas.cust_account_id
1060: , cas.cust_acct_site_id
1061: FROM hz_cust_acct_sites cas
1062: , hz_cust_site_uses csu
1063: WHERE cas.cust_acct_site_id = csu.cust_acct_site_id
1064: AND csu.site_use_id = p_shipto_site_id;
1065:

Line 1109: , hz_cust_acct_sites site

1105:
1106: CURSOR csr_cust_site_pay_term(cv_cust_account_id IN NUMBER, cv_site_use_id IN NUMBER) IS
1107: SELECT use.payment_term_id
1108: FROM hz_cust_site_uses use
1109: , hz_cust_acct_sites site
1110: WHERE site.cust_acct_site_id = use.cust_acct_site_id
1111: AND site.cust_account_id = cv_cust_account_id
1112: AND use.site_use_id = cv_site_use_id;
1113: