APPS.IEU_DIAG_AUDIT_TRACK_PVT dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 95: from JTF_RS_RESOURCE_EXTNS_vl

91: end;
92: else
93: begin
94: select resource_name into owner_name
95: from JTF_RS_RESOURCE_EXTNS_vl
96: where resource_id = cur_rec.owner_id;
97: exception
98: when no_data_found then null;
99: end;

Line 107: from JTF_RS_RESOURCE_EXTNS_vl

103: if cur_rec.assignee_id is not null then
104: if cur_rec.assignee_type = 'RS_INDIVIDUAL' then
105: begin
106: select resource_name into assignee_name
107: from JTF_RS_RESOURCE_EXTNS_vl
108: where resource_id = cur_rec.assignee_id;
109: exception
110: when no_data_found then null;
111: end;

Line 320: from JTF_RS_RESOURCE_EXTNS_vl

316: end;
317: else
318: begin
319: select resource_name into owner_name
320: from JTF_RS_RESOURCE_EXTNS_vl
321: where resource_id = cur_rec.owner_id;
322: exception
323: when no_data_found then null;
324: end;

Line 332: from JTF_RS_RESOURCE_EXTNS_vl

328: if cur_rec.assignee_id is not null then
329: if cur_rec.assignee_type = 'RS_INDIVIDUAL' then
330: begin
331: select resource_name into assignee_name
332: from JTF_RS_RESOURCE_EXTNS_vl
333: where resource_id = cur_rec.assignee_id;
334: exception
335: when no_data_found then null;
336: end;

Line 522: from JTF_RS_RESOURCE_EXTNS_vl

518: end;
519: else
520: begin
521: select resource_name into owner_name_prev
522: from JTF_RS_RESOURCE_EXTNS_vl
523: where resource_id = cur_rec.owner_id_prev;
524: exception
525: when no_data_found then null;
526: end;

Line 534: from JTF_RS_RESOURCE_EXTNS_vl

530: if cur_rec.assignee_id_prev is not null then
531: if cur_rec.assignee_type_prev = 'RS_INDIVIDUAL' then
532: begin
533: select resource_name into assignee_name_prev
534: from JTF_RS_RESOURCE_EXTNS_vl
535: where resource_id = cur_rec.assignee_id_prev;
536: exception
537: when no_data_found then null;
538: end;

Line 561: from JTF_RS_RESOURCE_EXTNS_vl

557: end;
558: else
559: begin
560: select resource_name into owner_name_curr
561: from JTF_RS_RESOURCE_EXTNS_vl
562: where resource_id = cur_rec.owner_id_curr;
563: exception
564: when no_data_found then null;
565: end;

Line 573: from JTF_RS_RESOURCE_EXTNS_vl

569: if cur_rec.assignee_id_curr is not null then
570: if cur_rec.assignee_type_curr = 'RS_INDIVIDUAL' then
571: begin
572: select resource_name into assignee_name_curr
573: from JTF_RS_RESOURCE_EXTNS_vl
574: where resource_id = cur_rec.assignee_id_curr;
575: exception
576: when no_data_found then null;
577: end;

Line 761: from JTF_RS_RESOURCE_EXTNS_vl

757: end;
758: else
759: begin
760: select resource_name into owner_name_prev
761: from JTF_RS_RESOURCE_EXTNS_vl
762: where resource_id = cur_rec.owner_id_prev;
763: exception
764: when no_data_found then null;
765: end;

Line 773: from JTF_RS_RESOURCE_EXTNS_vl

769: if cur_rec.assignee_id_prev is not null then
770: if cur_rec.assignee_type_prev = 'RS_INDIVIDUAL' then
771: begin
772: select resource_name into assignee_name_prev
773: from JTF_RS_RESOURCE_EXTNS_vl
774: where resource_id = cur_rec.assignee_id_prev;
775: exception
776: when no_data_found then null;
777: end;

Line 800: from JTF_RS_RESOURCE_EXTNS_vl

796: end;
797: else
798: begin
799: select resource_name into owner_name_curr
800: from JTF_RS_RESOURCE_EXTNS_vl
801: where resource_id = cur_rec.owner_id_curr;
802: exception
803: when no_data_found then null;
804: end;

Line 812: from JTF_RS_RESOURCE_EXTNS_vl

808: if cur_rec.assignee_id_curr is not null then
809: if cur_rec.assignee_type_curr = 'RS_INDIVIDUAL' then
810: begin
811: select resource_name into assignee_name_curr
812: from JTF_RS_RESOURCE_EXTNS_vl
813: where resource_id = cur_rec.assignee_id_curr;
814: exception
815: when no_data_found then null;
816: end;

Line 982: from JTF_RS_RESOURCE_EXTNS_vl

978: end;
979: else
980: begin
981: select resource_name into owner_name
982: from JTF_RS_RESOURCE_EXTNS_vl
983: where resource_id = cur_rec.owner_id;
984: exception
985: when no_data_found then null;
986: end;

Line 994: from JTF_RS_RESOURCE_EXTNS_vl

990: if cur_rec.assignee_id is not null then
991: if cur_rec.assignee_type = 'RS_INDIVIDUAL' then
992: begin
993: select resource_name into assignee_name
994: from JTF_RS_RESOURCE_EXTNS_vl
995: where resource_id = cur_rec.assignee_id;
996: exception
997: when no_data_found then null;
998: end;

Line 1119: jtf_rs_groups_vl rs1, JTF_RS_RESOURCE_EXTNS_vl rs2

1115: '2', 'Distributing', '3', 'Distributed') WORKITEM_DIST_STATUS_ID_CURR ,
1116: a.workitem_obj_code,a.OWNER_ID_CURR, rs1.group_name owner_name,
1117: a.ASSIGNEE_ID_CURR, rs2.resource_name assignee_name, a.ws_code, a.work_item_number, b.ws_id, tl.ws_name ws_name
1118: FROM ieu_uwqm_audit_log a, ieu_uwqm_work_sources_b b, ieu_uwqm_work_sources_tl tl,
1119: jtf_rs_groups_vl rs1, JTF_RS_RESOURCE_EXTNS_vl rs2
1120: WHERE a.owner_type_curr = 'RS_GROUP'
1121: and a.assignee_type_curr = 'RS_INDIVIDUAL'
1122: AND a.owner_id_curr = rs1.group_id(+)
1123: AND a.assignee_id_curr = rs2.resource_id(+)

Line 1163: jtf_rs_groups_tl rs1, JTF_RS_RESOURCE_EXTNS_vl rs2

1159: a.workitem_obj_code,a.OWNER_ID_CURR, rs1.group_name owner_name,
1160: a.ASSIGNEE_ID_CURR, rs2.resource_name assignee_name, b.ws_id, tl.ws_name ws_name,
1161: a.work_item_number
1162: FROM ieu_uwqm_audit_log a, ieu_uwqm_work_sources_b b, ieu_uwqm_work_sources_tl tl,
1163: jtf_rs_groups_tl rs1, JTF_RS_RESOURCE_EXTNS_vl rs2
1164: WHERE a.owner_type_curr = 'RS_GROUP'
1165: and a.assignee_type_curr = 'RS_INDIVIDUAL'
1166: and a.workitem_obj_code = b.object_code
1167: and b.ws_id = tl.ws_id

Line 1419: from JTF_RS_RESOURCE_EXTNS_vl

1415: end;
1416: else
1417: begin
1418: select resource_name into owner_name
1419: from JTF_RS_RESOURCE_EXTNS_vl
1420: where resource_id = cur_rec.owner_id_curr;
1421: exception
1422: when no_data_found then null;
1423: end;

Line 1431: from JTF_RS_RESOURCE_EXTNS_vl

1427: if cur_rec.assignee_id_curr is not null then
1428: if cur_rec.assignee_type_curr = 'RS_INDIVIDUAL' then
1429: begin
1430: select resource_name into assignee_name
1431: from JTF_RS_RESOURCE_EXTNS_vl
1432: where resource_id = cur_rec.assignee_id_curr;
1433: exception
1434: when no_data_found then null;
1435: end;