APPS.OZF_AR_INTERFACE_PVT dependencies on HZ_CUST_SITE_USES

Line 1055: FROM hz_cust_site_uses

1051: WHERE memo_line_id = p_id;
1052:
1053: CURSOR party_site_csr(p_id IN NUMBER) IS
1054: SELECT cust_acct_site_id
1055: FROM hz_cust_site_uses
1056: WHERE site_use_id = p_id ;
1057:
1058: CURSOR csr_shipto_site(p_shipto_site_id IN NUMBER) IS
1059: SELECT cas.cust_account_id

Line 1062: , hz_cust_site_uses csu

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:
1066:

Line 1108: FROM hz_cust_site_uses use

1104: AND site_use_id = cv_site_use_id;
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;