DBA Data[Home] [Help]

APPS.OZF_AR_INTERFACE_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 1095: FROM hz_customer_profiles

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

Line 1106: FROM hz_customer_profiles

1102: */
1103:
1104: CURSOR csr_cust_address_pay_term(cv_cust_account_id IN NUMBER, cv_site_use_id IN NUMBER) IS
1105: SELECT standard_terms
1106: FROM hz_customer_profiles
1107: WHERE cust_account_id = cv_cust_account_id
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