DBA Data[Home] [Help]

APPS.OZF_AR_INTERFACE_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 1091: FROM hz_customer_profiles

1087: AND ct.claim_type_id = cv_claim_type_id;
1088:
1089: CURSOR csr_cust_payment_term(cv_cust_account_id IN NUMBER) IS
1090: SELECT standard_terms
1091: FROM hz_customer_profiles
1092: WHERE cust_account_id = cv_cust_account_id
1093: AND site_use_id IS NULL;
1094: /*
1095: SELECT payment_term_id

Line 1102: FROM hz_customer_profiles

1098: */
1099:
1100: CURSOR csr_cust_address_pay_term(cv_cust_account_id IN NUMBER, cv_site_use_id IN NUMBER) IS
1101: SELECT standard_terms
1102: FROM hz_customer_profiles
1103: WHERE cust_account_id = cv_cust_account_id
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