DBA Data[Home] [Help]

APPS.CN_GET_TX_DATA_PUB dependencies on CN_QUOTAS

Line 1193: FROM cn_quotas

1189: IF (l_quota_flag = 'Y') THEN
1190: BEGIN
1191: SELECT name
1192: INTO x_adj_tbl(1).quota_name
1193: FROM cn_quotas
1194: WHERE quota_id = l_quota_id
1195: AND rownum < 2;
1196: EXCEPTION
1197: WHEN OTHERS THEN

Line 1307: l_pe_id cn_quotas.quota_id%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:
1310: ------+
1311: -- Bug#2969534 End

Line 1308: l_pe_name cn_quotas.name%TYPE;

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:
1310: ------+
1311: -- Bug#2969534 End
1312: ------+