APPS.OKL_PRINT_CONS_BILL dependencies on HZ_CUST_ACCOUNTS

Line 94: FROM HZ_CUST_ACCOUNTS CA,

90: PY.CITY,
91: PY.STATE,
92: PY.POSTAL_CODE,
93: PY.COUNTRY
94: FROM HZ_CUST_ACCOUNTS CA,
95: HZ_PARTIES PY
96: WHERE CA.CUST_ACCOUNT_ID = p_id AND
97: PY.PARTY_ID = CA.PARTY_ID;
98:

Line 100: l_customer_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

96: WHERE CA.CUST_ACCOUNT_ID = p_id AND
97: PY.PARTY_ID = CA.PARTY_ID;
98:
99:
100: l_customer_number HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
101: l_customer_name hz_parties.PARTY_NAME%TYPE;
102: l_addr1 HZ_PARTIES.ADDRESS1%TYPE;
103: l_addr2 HZ_PARTIES.ADDRESS2%TYPE;
104: l_addr3 HZ_PARTIES.ADDRESS3%TYPE;