APPS.OKL_PRINT_CONS_BILL dependencies on HZ_PARTIES

Line 56: FROM hz_parties

52:
53: CURSOR party_name_csr ( p_party_id NUMBER ) is
54: SELECT party_name,
55: party_id
56: FROM hz_parties
57: where party_id = p_party_id;
58:
59:
60: CURSOR curr_csr ( p_code VARCHAR2 ) IS

Line 95: HZ_PARTIES PY

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:
99:

Line 101: l_customer_name hz_parties.PARTY_NAME%TYPE;

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;
105: l_addr4 HZ_PARTIES.ADDRESS4%TYPE;

Line 102: l_addr1 HZ_PARTIES.ADDRESS1%TYPE;

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;
105: l_addr4 HZ_PARTIES.ADDRESS4%TYPE;
106: l_city HZ_PARTIES.CITY%TYPE;

Line 103: l_addr2 HZ_PARTIES.ADDRESS2%TYPE;

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;
105: l_addr4 HZ_PARTIES.ADDRESS4%TYPE;
106: l_city HZ_PARTIES.CITY%TYPE;
107: l_state HZ_PARTIES.STATE%TYPE;

Line 104: l_addr3 HZ_PARTIES.ADDRESS3%TYPE;

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;
105: l_addr4 HZ_PARTIES.ADDRESS4%TYPE;
106: l_city HZ_PARTIES.CITY%TYPE;
107: l_state HZ_PARTIES.STATE%TYPE;
108: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;

Line 105: l_addr4 HZ_PARTIES.ADDRESS4%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;
105: l_addr4 HZ_PARTIES.ADDRESS4%TYPE;
106: l_city HZ_PARTIES.CITY%TYPE;
107: l_state HZ_PARTIES.STATE%TYPE;
108: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
109: l_country HZ_PARTIES.COUNTRY%TYPE;

Line 106: l_city HZ_PARTIES.CITY%TYPE;

102: l_addr1 HZ_PARTIES.ADDRESS1%TYPE;
103: l_addr2 HZ_PARTIES.ADDRESS2%TYPE;
104: l_addr3 HZ_PARTIES.ADDRESS3%TYPE;
105: l_addr4 HZ_PARTIES.ADDRESS4%TYPE;
106: l_city HZ_PARTIES.CITY%TYPE;
107: l_state HZ_PARTIES.STATE%TYPE;
108: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
109: l_country HZ_PARTIES.COUNTRY%TYPE;
110:

Line 107: l_state HZ_PARTIES.STATE%TYPE;

103: l_addr2 HZ_PARTIES.ADDRESS2%TYPE;
104: l_addr3 HZ_PARTIES.ADDRESS3%TYPE;
105: l_addr4 HZ_PARTIES.ADDRESS4%TYPE;
106: l_city HZ_PARTIES.CITY%TYPE;
107: l_state HZ_PARTIES.STATE%TYPE;
108: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
109: l_country HZ_PARTIES.COUNTRY%TYPE;
110:
111: l_format_type VARCHAR2(5) := '0';

Line 108: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;

104: l_addr3 HZ_PARTIES.ADDRESS3%TYPE;
105: l_addr4 HZ_PARTIES.ADDRESS4%TYPE;
106: l_city HZ_PARTIES.CITY%TYPE;
107: l_state HZ_PARTIES.STATE%TYPE;
108: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
109: l_country HZ_PARTIES.COUNTRY%TYPE;
110:
111: l_format_type VARCHAR2(5) := '0';
112: l_format_set BOOLEAN := FALSE;

Line 109: l_country HZ_PARTIES.COUNTRY%TYPE;

105: l_addr4 HZ_PARTIES.ADDRESS4%TYPE;
106: l_city HZ_PARTIES.CITY%TYPE;
107: l_state HZ_PARTIES.STATE%TYPE;
108: l_postal_code HZ_PARTIES.POSTAL_CODE%TYPE;
109: l_country HZ_PARTIES.COUNTRY%TYPE;
110:
111: l_format_type VARCHAR2(5) := '0';
112: l_format_set BOOLEAN := FALSE;
113: