APPS.CN_GET_TX_DATA_PUB dependencies on CN_ROLES

Line 1206: FROM cn_roles

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

Line 1304: l_role_name cn_roles.name%TYPE;

1300: l_cust_id HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE;
1301: l_cust_name HZ_PARTIES.PARTY_NAME%TYPE;
1302: l_cust_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
1303:
1304: l_role_name cn_roles.name%TYPE;
1305: l_role_id cn_roles.role_id%TYPE;
1306:
1307: l_pe_id cn_quotas.quota_id%TYPE;
1308: l_pe_name cn_quotas.name%TYPE;

Line 1305: l_role_id cn_roles.role_id%TYPE;

1301: l_cust_name HZ_PARTIES.PARTY_NAME%TYPE;
1302: l_cust_num HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
1303:
1304: l_role_name cn_roles.name%TYPE;
1305: l_role_id cn_roles.role_id%TYPE;
1306:
1307: l_pe_id cn_quotas.quota_id%TYPE;
1308: l_pe_name cn_quotas.name%TYPE;
1309: