APPS.CN_GET_TX_DATA_PUB dependencies on CN_ROLES

Line 1205: FROM cn_roles

1201: IF (l_role_flag = 'Y') THEN
1202: BEGIN
1203: SELECT name
1204: INTO x_adj_tbl(1).role_name
1205: FROM cn_roles
1206: WHERE role_id = l_role_id
1207: AND rownum < 2;
1208: EXCEPTION
1209: WHEN OTHERS THEN

Line 1303: l_role_name cn_roles.name%TYPE;

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:
1306: l_pe_id cn_quotas.quota_id%TYPE;
1307: l_pe_name cn_quotas.name%TYPE;

Line 1304: l_role_id cn_roles.role_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:
1306: l_pe_id cn_quotas.quota_id%TYPE;
1307: l_pe_name cn_quotas.name%TYPE;
1308: