APPS.CSP_PARTS_ORDER dependencies on HZ_CUSTOMER_PROFILE_V2PUB

Line 1344: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

1340: l_cust_site_id number;
1341: l_cust_acct_site_use_id NUMBER;
1342: v_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;
1343: v_cust_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
1344: v_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1345: x_cust_acct_site_id NUMBER;
1346: x_site_use_id NUMBER;
1347: temp_bill_to_site_id number;
1348: temp_ship_to_use_id number;

Line 1400: v_bill_cust_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

1396: x_pri_bill_acct_site_id number;
1397: l_bill_acct_site_use_id number;
1398: v_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
1399: v_pri_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
1400: v_bill_cust_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1401: v_pri_bill_cust_prf_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1402:
1403: cursor get_bill_site_id is
1404: select cust_acct_site_id

Line 1401: v_pri_bill_cust_prf_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;

1397: l_bill_acct_site_use_id number;
1398: v_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
1399: v_pri_bill_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
1400: v_bill_cust_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1401: v_pri_bill_cust_prf_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1402:
1403: cursor get_bill_site_id is
1404: select cust_acct_site_id
1405: from HZ_CUST_SITE_USES_ALL