APPS.CN_GET_TX_DATA_PUB dependencies on CN_COMP_GROUPS

Line 1167: FROM cn_comp_groups

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

Line 1294: l_comp_group_id cn_comp_groups.comp_group_id%TYPE;

1290: ------+
1291: -- Bug#2969534 Start
1292: ------+
1293:
1294: l_comp_group_id cn_comp_groups.comp_group_id%TYPE;
1295: l_comp_group_name cn_comp_groups.name%TYPE;
1296:
1297: l_rev_class_name cn_revenue_classes.name%TYPE;
1298: l_rev_class_id cn_revenue_classes.revenue_class_id%TYPE;

Line 1295: l_comp_group_name cn_comp_groups.name%TYPE;

1291: -- Bug#2969534 Start
1292: ------+
1293:
1294: l_comp_group_id cn_comp_groups.comp_group_id%TYPE;
1295: l_comp_group_name cn_comp_groups.name%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: