APPS.CN_GET_TX_DATA_PUB dependencies on HZ_CUST_ACCOUNTS

Line 1220: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT

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

Line 1299: l_cust_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;

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

Line 1301: l_cust_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

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