DBA Data[Home] [Help]

APPS.CN_CALC_POPULATE_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 286: jtf_rs_role_relations rr

282: cn_quota_rules_all qr,
283: cn_dim_hierarchies_all dh,
284: jtf_rs_salesreps jrs,
285: jtf_rs_group_members mem,
286: jtf_rs_role_relations rr
287: where spa.salesrep_id = p_salesrep_id
288: and spa.org_id = g_org_id
289: and spa.start_date <= p_end_date
290: and nvl(spa.end_date, p_end_date) >= p_start_date

Line 345: jtf_rs_role_relations rr

341: cn_quotas_all q,
342: cn_quota_rules_all qr,
343: jtf_rs_salesreps jrs,
344: jtf_rs_group_members mem,
345: jtf_rs_role_relations rr
346: where spa.salesrep_id = p_salesrep_id
347: and spa.org_id = g_org_id
348: and spa.start_date <= p_end_date
349: and nvl(spa.end_date, p_end_date) >= p_start_date