APPS.CN_SALES_HIER_PUB dependencies on CN_SRP_COMP_GROUPS_V

Line 66: cn_srp_comp_groups_v cscg,

62: ) IS
63:
64: SELECT distinct cg.name comp_group_name, cscg.comp_group_id comp_group_id
65: FROM
66: cn_srp_comp_groups_v cscg,
67: cn_comp_groups cg
68: WHERE
69: ((l_salesrep_id = -9999 ) OR (cscg.salesrep_id = l_salesrep_id)) AND
70: cscg.comp_group_id = l_comp_group_id AND

Line 95: cn_srp_comp_groups_v cscg,

91: cscg.start_date_active mgr_start_date,
92: cscg.end_date_active mgr_end_date
93:
94: FROM
95: cn_srp_comp_groups_v cscg,
96: cn_salesreps cs
97: WHERE
98: cscg.comp_group_id = l_comp_group_id AND -- (master-detail passed in value)
99: ((cscg.end_date_active is null) OR

Line 120: cn_srp_comp_groups_v cscg,

116: cscg.role_name srp_role,
117: cscg.start_date_active srp_start_date,
118: cscg.end_date_active srp_end_date
119: FROM
120: cn_srp_comp_groups_v cscg,
121: cn_salesreps cs
122: WHERE
123: cscg.comp_group_id = l_comp_group_id AND -- (master-detail passed value)
124: cscg.salesrep_id = cs.salesrep_id AND