eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_GAR_PROPOSALS_PUB dependencies on JTF_TAE_1001_PROP_WINNERS

Line 248: FROM JTF_TAE_1001_PROP_WINNERS

244:
245: CURSOR c_get_res_type_count(c_resource_type VARCHAR2, c_request_id NUMBER, c_worker_id NUMBER)
246: IS
247: SELECT count(*)
248: FROM JTF_TAE_1001_PROP_WINNERS
249: WHERE request_id = c_request_id
250: AND resource_type = c_resource_type
251: AND worker_id = c_worker_id
252: AND ROWNUM < 2;

Line 291: INSERT INTO JTF_TAE_1001_PROP_WINNERS

287: /** Note
288: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
289: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
290: **/
291: INSERT INTO JTF_TAE_1001_PROP_WINNERS
292: (trans_object_id,
293: trans_detail_object_id,
294: terr_id,
295: resource_id,

Line 348: JTF_TAE_1001_PROP_WINNERS T,

344: J.person_id,
345: T.org_id,
346: T.worker_id
347: FROM
348: JTF_TAE_1001_PROP_WINNERS T,
349: (
350: SELECT TM.team_resource_id resource_id,
351: TM.person_id person_id2,
352: MIN(G.group_id)group_id,

Line 463: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_PROP_WINNERS rt1

459: WHERE j.team_id = t.resource_id
460: AND t.request_id = l_request_id
461: AND t.worker_id = l_worker_id
462: AND t.resource_type = 'RS_TEAM'
463: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_PROP_WINNERS rt1
464: WHERE rt1.resource_id = j.resource_id
465: AND NVL(rt1.group_id,-1) = NVL(j.group_id,-1)
466: AND rt1.request_id = t.request_id
467: AND rt1.worker_id = t.worker_id

Line 515: FROM JTF_TAE_1001_PROP_WINNERS

511:
512: CURSOR c_get_res_type_count(c_resource_type VARCHAR2, c_request_id NUMBER, c_worker_id NUMBER)
513: IS
514: SELECT count(*)
515: FROM JTF_TAE_1001_PROP_WINNERS
516: WHERE request_id = c_request_id
517: AND resource_type = c_resource_type
518: AND worker_id = c_worker_id
519: AND ROWNUM < 2;

Line 558: INSERT INTO JTF_TAE_1001_PROP_WINNERS

554: Hard coding RS_EMPLOYEE INSTEAD OF resource_category IN following SQL
555: because JTA returns RS_EMPLOYEE AND NOT EMPLOYEE
556: **/
557:
558: INSERT INTO JTF_TAE_1001_PROP_WINNERS
559: (trans_object_id,
560: trans_detail_object_id,
561: terr_id,
562: resource_id,

Line 616: JTF_TAE_1001_PROP_WINNERS t,

612: J.person_id,
613: T.org_id,
614: T.worker_id
615: FROM
616: JTF_TAE_1001_PROP_WINNERS t,
617: (
618: SELECT MIN(m.resource_id) resource_id,
619: res.CATEGORY resource_category,
620: m.group_id group_id, MIN(res.source_id) person_id

Line 646: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_PROP_WINNERS rt1

642: WHERE j.group_id = t.resource_id
643: AND t.request_id = l_request_id
644: AND t.worker_id = l_worker_id
645: AND t.resource_type = 'RS_GROUP'
646: AND NOT EXISTS (SELECT 1 FROM JTF_TAE_1001_PROP_WINNERS rt1
647: WHERE rt1.resource_id = j.resource_id
648: AND NVL(rt1.group_id,-1) = NVL(j.group_id,-1)
649: AND rt1.request_id = t.request_id
650: AND rt1.worker_id = t.worker_id

Line 718: JTF_TAE_1001_PROP_WINNERS WIN

714: A.resource_id,
715: A.resource_group_id,
716: decode(NVL(WIN.full_access_flag,'N'),'Y','FULL','READ') full_access_flag
717: FROM PRP_PROPOSAL_ACCESSES A,
718: JTF_TAE_1001_PROP_WINNERS WIN
719: WHERE NVL(A.ACCESS_LEVEL,'N') <> decode(NVL(WIN.full_access_flag,'N'),'Y','FULL','READ')
720: AND WIN.SOURCE_ID = -1001
721: AND WIN.worker_id = c_worker_id
722: AND WIN.resource_type IN ('RS_EMPLOYEE','RS_PARTNER','RS_PARTY')

Line 882: FROM JTF_TAE_1001_PROP_WINNERS W

878: SELECT W.resource_id,
879: W.group_id grp_id,
880: W.trans_object_id proposal_id,
881: DECODE(MAX(W.full_access_flag),'Y','FULL','READ') faf
882: FROM JTF_TAE_1001_PROP_WINNERS W
883: WHERE W.source_id = -1001
884: AND W.worker_id = c_worker_id
885: AND W.resource_type = 'RS_EMPLOYEE'
886: AND W.group_id IS NOT NULL --- Added to work around the JTY functionality which allows group_id to be NULL during setup of resources.

Line 1091: FROM JTF_TAE_1001_PROP_WINNERS W

1087: SELECT w.terr_id
1088: ,w.trans_object_id
1089: ,w.resource_id
1090: ,w.group_id
1091: FROM JTF_TAE_1001_PROP_WINNERS W
1092: WHERE W.source_id = -1001
1093: AND W.worker_id = c_worker_id
1094: AND W.resource_type = 'RS_EMPLOYEE'
1095: AND W.group_id IS NOT NULL --- Added to work around the JTY functionality which allows group_id to be NULL during setup of resources.

Line 1393: FROM JTF_TAE_1001_PROP_WINNERS W

1389: DELETE PRP_PROPOSAL_ACCESSES ACC
1390: WHERE ACC.PROPOSAL_ID=l_proposal_id(i)
1391: AND ACC.KEEP_FLAG = 'N'
1392: AND NOT EXISTS (SELECT 'X'
1393: FROM JTF_TAE_1001_PROP_WINNERS W
1394: WHERE W.TRANS_OBJECT_ID = ACC.PROPOSAL_ID
1395: AND W.WORKER_ID = l_worker_id
1396: AND W.RESOURCE_ID = ACC.RESOURCE_ID
1397: AND NVL(W.GROUP_ID,-777)=NVL(ACC.RESOURCE_GROUP_ID,-777))

Line 1416: FROM JTF_TAE_1001_PROP_WINNERS W

1412: DELETE PRP_PROPOSAL_ACCESSES ACC
1413: WHERE ACC.PROPOSAL_ID=l_proposal_id(i)
1414: AND ACC.KEEP_FLAG = 'N'
1415: AND NOT EXISTS (SELECT 'X'
1416: FROM JTF_TAE_1001_PROP_WINNERS W
1417: WHERE W.TRANS_OBJECT_ID = ACC.PROPOSAL_ID
1418: AND W.WORKER_ID = l_worker_id
1419: AND W.RESOURCE_ID = ACC.RESOURCE_ID
1420: AND NVL(W.GROUP_ID,-777)=NVL(ACC.RESOURCE_GROUP_ID,-777));