APPS.JTF_RS_SRP_GROUPS_CONC_PUB dependencies on JTF_RS_SALESREPS

Line 25: possible to have org_id as NULL in jtf_rs_salesreps

21: nsinghai 27-SEP-2004 Added logic to filter out -1 group_id
22: record from defaulting logic if any other
23: valid group is present even at lower level.
24: nsinghai 07-JAN-2005 added nvl conditions for org_id, since it is
25: possible to have org_id as NULL in jtf_rs_salesreps
26: table (Bug 4109716)
27: ***************************************************************************/
28:
29: PROCEDURE populate_default_groups

Line 81: FROM jtf_rs_salesreps

77: l_jtft varchar2(60);
78:
79: CURSOR c_outer IS
80: SELECT salesrep_id, org_id
81: FROM jtf_rs_salesreps
82: ;
83:
84: CURSOR c1 (ll_salesrep_id NUMBER, ll_org_id NUMBER )IS
85: SELECT salesrep_id, org_id, resource_id, user_id, group_id, start_date, end_date

Line 230: ,jtf_rs_salesreps srp

226: ,rol.role_type_code
227: ,COUNT(den.group_id) denorm_count
228: FROM jtf_rs_role_relations rrl
229: ,jtf_rs_group_members mem
230: ,jtf_rs_salesreps srp
231: ,jtf_rs_group_usages usg
232: ,jtf_rs_roles_b rol
233: ,jtf_rs_groups_denorm den
234: ,jtf_rs_resource_extns res

Line 291: jtf_rs_salesreps srp,

287: TO_DATE('01/01/1900','MM/DD/RRRR') START_DATE,
288: TO_DATE('12/31/4712','MM/DD/RRRR') END_DATE,
289: 99999999 denorm_count
290: FROM
291: jtf_rs_salesreps srp,
292: jtf_rs_resource_extns res
293: WHERE srp.resource_id = res.resource_id
294: ) x;
295: