APPS.CN_GET_TX_DATA_PUB dependencies on CN_REVENUE_CLASSES

Line 1179: FROM cn_revenue_classes

1175: IF (l_rc_flag = 'Y') THEN
1176: BEGIN
1177: SELECT name
1178: INTO x_adj_tbl(1).revenue_class_name
1179: FROM cn_revenue_classes
1180: WHERE revenue_class_id = l_rc_id
1181: AND rownum < 2;
1182: EXCEPTION
1183: WHEN OTHERS THEN

Line 1296: l_rev_class_name cn_revenue_classes.name%TYPE;

1292:
1293: l_comp_group_id cn_comp_groups.comp_group_id%TYPE;
1294: l_comp_group_name cn_comp_groups.name%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;

Line 1297: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;

1293: l_comp_group_id cn_comp_groups.comp_group_id%TYPE;
1294: l_comp_group_name cn_comp_groups.name%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;