APPS.OZF_AR_INTERFACE_PVT dependencies on HZ_CUST_SITE_USES

Line 1059: FROM hz_cust_site_uses

1055: WHERE memo_line_id = p_id;
1056:
1057: CURSOR party_site_csr(p_id IN NUMBER) IS
1058: SELECT cust_acct_site_id
1059: FROM hz_cust_site_uses
1060: WHERE site_use_id = p_id ;
1061:
1062: CURSOR csr_shipto_site(p_shipto_site_id IN NUMBER) IS
1063: SELECT cas.cust_account_id

Line 1066: , hz_cust_site_uses csu

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

Line 1112: FROM hz_cust_site_uses use

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