[Home] [Help]
14034: --
14035: -- new cursor to get tmp query for xml publisher design 11.5.11
14036: CURSOR C_GET_RS (IN_USER_ID NUMBER) IS
14037: SELECT j.resource_id
14038: FROM jtf_rs_resource_extns j
14039: WHERE j.user_id = in_user_id;
14040: --
14041: CURSOR C_GET_ORG_EMAIL (IN_PARTY_ID NUMBER) IS
14042: SELECT email_address
14065:
14066: --Bug5233002. Fix by LKKUMAR on 31-May-2006. Start.
14067: CURSOR C_GET_RES_USER_ID IS
14068: SELECT j.user_id
14069: FROM jtf_rs_resource_extns j
14070: WHERE j.resource_id = p_resource_id;
14071: l_resource_user_id NUMBER;
14072: --Bug5233002. Fix by LKKUMAR on 31-May-2006. End.
14073:
14142: l_defined boolean;
14143:
14144: cursor c_user_level_profile(p_resource_id number) is
14145: select user_id
14146: from jtf_rs_resource_extns
14147: where resource_id = p_resource_id;
14148: -- end for bug 8916424
14149:
14150: l_dunning_type varchar2(20);
17232: --------------------------------------------------------
17233:
17234: CURSOR c_get_person IS
17235: SELECT DISTINCT person_id, salesforce_id
17236: FROM as_accesses acc, jtf_rs_resource_extns rs
17237: WHERE acc.customer_id = p_party_id and rs.resource_id = acc.salesforce_id
17238: and rs.user_id is not null;
17239:
17240: -- clchang 02/26/2003 updated
17242: ----------------------------------------------------------------
17243:
17244: CURSOR c_party_resource_OLD(p_party_id NUMBER) IS
17245: SELECT DISTINCT rs.resource_id, 0
17246: FROM as_rpt_managers_v m, as_accesses acc, jtf_rs_resource_extns rs
17247: WHERE m.person_id = acc.person_id
17248: AND m.manager_person_id = rs.source_id
17249: AND acc.customer_id = p_party_id
17250: AND nvl(rs.end_date_active,sysdate) >= trunc(sysdate);
17258: AND t.task_status_id = s.task_status_id
17259: AND upper(s.name) = 'OPEN'
17260: AND t.owner_id in ( select DISTINCT rs.resource_id
17261: from as_rpt_managers_v m, as_accesses acc,
17262: jtf_rs_resource_extns rs
17263: where m.person_id = acc.person_id
17264: and m.manager_person_id = rs.source_id
17265: and acc.customer_id = p_party_id
17266: AND nvl(rs.end_date_active,sysdate) >= trunc(sysdate) )
17267: GROUP BY t.owner_id;
17268:
17269: CURSOR c_resource_notask_count_OLD(p_party_id NUMBER) IS
17270: SELECT DISTINCT rs.resource_id, 0
17271: FROM as_rpt_managers_v m, as_accesses acc, jtf_rs_resource_extns rs
17272: WHERE m.person_id = acc.person_id
17273: AND m.manager_person_id = rs.source_id
17274: AND acc.customer_id = p_party_id
17275: AND nvl(rs.end_date_active,sysdate) >= trunc(sysdate)
17310: AND t.task_status_id = s.task_status_id
17311: AND upper(s.name) = 'OPEN'
17312: AND t.owner_id in ( select DISTINCT rs.resource_id
17313: from as_accesses acc,
17314: jtf_rs_resource_extns rs
17315: where acc.customer_id = p_party_id
17316: and rs.resource_id = acc.salesforce_id
17317: and rs.category = 'EMPLOYEE'
17318: and rs.user_id is not null
17326: AND t2.task_status_id = s2.task_status_id
17327: AND upper(s2.name) = 'OPEN'
17328: AND t2.owner_id in ( select DISTINCT rs.resource_id
17329: from as_accesses acc,
17330: jtf_rs_resource_extns rs
17331: where acc.customer_id = p_party_id
17332: and rs.resource_id = acc.salesforce_id
17333: and rs.category = 'EMPLOYEE'
17334: and rs.user_id is not null
17345: AND t.task_status_id = s.task_status_id
17346: AND upper(s.name) = 'OPEN'
17347: AND t.owner_id in ( select DISTINCT rs.resource_id
17348: from as_accesses acc,
17349: jtf_rs_resource_extns rs
17350: where acc.customer_id = p_party_id
17351: and rs.resource_id = acc.salesforce_id
17352: and rs.category = 'EMPLOYEE'
17353: and rs.user_id is not null
17355: GROUP BY t.owner_id;
17356: --
17357: CURSOR c_resource_notask_count(p_party_id NUMBER) IS
17358: SELECT DISTINCT rs.resource_id, 0
17359: FROM as_accesses acc, jtf_rs_resource_extns rs
17360: WHERE acc.customer_id = p_party_id
17361: AND nvl(rs.end_date_active,sysdate) >= trunc(sysdate)
17362: AND rs.resource_id = acc.salesforce_id
17363: and rs.category = 'EMPLOYEE'