APPS.FV_1099_TRANSACTION dependencies on HZ_PARTIES

Line 16: v_cust_name hz_parties.party_name%TYPE;

12: v_rec_activity IN number,
13: v_include_charges IN varchar2)
14: IS
15: l_module_name VARCHAR2(200) ;
16: v_cust_name hz_parties.party_name%TYPE;
17: v_tax_ref hz_parties.tax_reference%TYPE;
18: v_address1 hz_locations.address1%TYPE;
19: v_address2 hz_locations.address2%TYPE;
20: v_address3 hz_locations.address3%TYPE;

Line 17: v_tax_ref hz_parties.tax_reference%TYPE;

13: v_include_charges IN varchar2)
14: IS
15: l_module_name VARCHAR2(200) ;
16: v_cust_name hz_parties.party_name%TYPE;
17: v_tax_ref hz_parties.tax_reference%TYPE;
18: v_address1 hz_locations.address1%TYPE;
19: v_address2 hz_locations.address2%TYPE;
20: v_address3 hz_locations.address3%TYPE;
21: v_address4 hz_locations.address4%TYPE;

Line 148: FROM hz_parties hzp, hz_cust_accounts hzca

144:
145: BEGIN
146: SELECT hzp.party_name,hzp.tax_reference
147: INTO v_cust_name, v_tax_ref
148: FROM hz_parties hzp, hz_cust_accounts hzca
149: WHERE hzca.cust_account_id = v_customer_id
150: AND hzca.party_id = hzp.party_id;
151:
152: EXCEPTION