[Home] [Help]
6976: --
6977: -- new cursor to get tmp query for xml publisher design 11.5.11
6978: CURSOR C_GET_RS (IN_USER_ID NUMBER) IS
6979: SELECT j.resource_id
6980: FROM jtf_rs_resource_extns j
6981: WHERE j.user_id = in_user_id;
6982: --
6983: CURSOR C_GET_ORG_EMAIL (IN_PARTY_ID NUMBER) IS
6984: SELECT email_address
7006:
7007: --Bug5233002. Fix by LKKUMAR on 31-May-2006. Start.
7008: CURSOR C_GET_RES_USER_ID IS
7009: SELECT j.user_id
7010: FROM jtf_rs_resource_extns j
7011: WHERE j.resource_id = p_resource_id;
7012: l_resource_user_id NUMBER;
7013: --Bug5233002. Fix by LKKUMAR on 31-May-2006. End.
7014:
9519: --------------------------------------------------------
9520:
9521: CURSOR c_get_person IS
9522: SELECT DISTINCT person_id, salesforce_id
9523: FROM as_accesses acc, jtf_rs_resource_extns rs
9524: WHERE acc.customer_id = p_party_id and rs.resource_id = acc.salesforce_id
9525: and rs.user_id is not null;
9526:
9527: -- clchang 02/26/2003 updated
9529: ----------------------------------------------------------------
9530:
9531: CURSOR c_party_resource_OLD(p_party_id NUMBER) IS
9532: SELECT DISTINCT rs.resource_id, 0
9533: FROM as_rpt_managers_v m, as_accesses acc, jtf_rs_resource_extns rs
9534: WHERE m.person_id = acc.person_id
9535: AND m.manager_person_id = rs.source_id
9536: AND acc.customer_id = p_party_id
9537: AND nvl(rs.end_date_active,sysdate) >= trunc(sysdate);
9545: AND t.task_status_id = s.task_status_id
9546: AND upper(s.name) = 'OPEN'
9547: AND t.owner_id in ( select DISTINCT rs.resource_id
9548: from as_rpt_managers_v m, as_accesses acc,
9549: jtf_rs_resource_extns rs
9550: where m.person_id = acc.person_id
9551: and m.manager_person_id = rs.source_id
9552: and acc.customer_id = p_party_id
9553: AND nvl(rs.end_date_active,sysdate) >= trunc(sysdate) )
9554: GROUP BY t.owner_id;
9555:
9556: CURSOR c_resource_notask_count_OLD(p_party_id NUMBER) IS
9557: SELECT DISTINCT rs.resource_id, 0
9558: FROM as_rpt_managers_v m, as_accesses acc, jtf_rs_resource_extns rs
9559: WHERE m.person_id = acc.person_id
9560: AND m.manager_person_id = rs.source_id
9561: AND acc.customer_id = p_party_id
9562: AND nvl(rs.end_date_active,sysdate) >= trunc(sysdate)
9598: AND t.task_status_id = s.task_status_id
9599: AND upper(s.name) = 'OPEN'
9600: AND t.owner_id in ( select DISTINCT rs.resource_id
9601: from as_accesses acc,
9602: jtf_rs_resource_extns rs
9603: where acc.customer_id = p_party_id
9604: and rs.resource_id = acc.salesforce_id
9605: and rs.category = 'EMPLOYEE'
9606: and rs.user_id is not null
9614: AND t2.task_status_id = s2.task_status_id
9615: AND upper(s2.name) = 'OPEN'
9616: AND t2.owner_id in ( select DISTINCT rs.resource_id
9617: from as_accesses acc,
9618: jtf_rs_resource_extns rs
9619: where acc.customer_id = p_party_id
9620: and rs.resource_id = acc.salesforce_id
9621: and rs.category = 'EMPLOYEE'
9622: and rs.user_id is not null
9633: AND t.task_status_id = s.task_status_id
9634: AND upper(s.name) = 'OPEN'
9635: AND t.owner_id in ( select DISTINCT rs.resource_id
9636: from as_accesses acc,
9637: jtf_rs_resource_extns rs
9638: where acc.customer_id = p_party_id
9639: and rs.resource_id = acc.salesforce_id
9640: and rs.category = 'EMPLOYEE'
9641: and rs.user_id is not null
9643: GROUP BY t.owner_id;
9644: --
9645: CURSOR c_resource_notask_count(p_party_id NUMBER) IS
9646: SELECT DISTINCT rs.resource_id, 0
9647: FROM as_accesses acc, jtf_rs_resource_extns rs
9648: WHERE acc.customer_id = p_party_id
9649: AND nvl(rs.end_date_active,sysdate) >= trunc(sysdate)
9650: AND rs.resource_id = acc.salesforce_id
9651: and rs.category = 'EMPLOYEE'