APPS.CN_GET_TX_DATA_PUB dependencies on HZ_CUST_ACCOUNTS

Line 1221: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT

1217: SELECT substrb(PARTY.PARTY_NAME,1,50),
1218: CUST_ACCT.ACCOUNT_NUMBER
1219: INTO x_adj_tbl(1).customer_name,
1220: x_adj_tbl(1).customer_number
1221: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
1222: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
1223: AND CUST_ACCT.CUST_ACCOUNT_ID = l_cust_id
1224: AND rownum < 2;
1225: EXCEPTION

Line 1300: l_cust_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;

1296:
1297: l_rev_class_name cn_revenue_classes.name%TYPE;
1298: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;
1299:
1300: l_cust_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;
1301: l_cust_name HZ_PARTIES.PARTY_NAME%TYPE;
1302: l_cust_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
1303:
1304: l_role_name cn_roles.name%TYPE;

Line 1302: l_cust_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

1298: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;
1299:
1300: l_cust_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;
1301: l_cust_name HZ_PARTIES.PARTY_NAME%TYPE;
1302: l_cust_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
1303:
1304: l_role_name cn_roles.name%TYPE;
1305: l_role_id cn_roles.role_id%TYPE;
1306: