APPS.CN_GET_TX_DATA_PUB dependencies on CN_COMP_GROUPS

Line 1166: FROM cn_comp_groups

1162: IF (l_cg_flag = 'Y') THEN
1163: BEGIN
1164: SELECT name
1165: INTO x_adj_tbl(1).comp_group_name
1166: FROM cn_comp_groups
1167: WHERE comp_group_id = l_cg_id
1168: AND rownum < 2;
1169: EXCEPTION
1170: WHEN OTHERS THEN

Line 1293: l_comp_group_id cn_comp_groups.comp_group_id%TYPE;

1289: ------+
1290: -- Bug#2969534 Start
1291: ------+
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;

Line 1294: l_comp_group_name cn_comp_groups.name%TYPE;

1290: -- Bug#2969534 Start
1291: ------+
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: