60: ,fnd_global.login_id
61: ,sqa.org_id
62: FROM cn_srp_quota_assigns_all sqa
63: ,cn_srp_quota_rules_all sqr
64: ,cn_quota_rule_uplifts_all qru
65: WHERE sqa.srp_plan_assign_id = p_srp_plan_assign_id
66: AND sqa.quota_id = p_quota_id
67: AND sqa.srp_quota_assign_id = sqr.srp_quota_assign_id
68: AND sqa.srp_plan_assign_id = sqr.srp_plan_assign_id
99: ,fnd_global.login_id
100: ,sqa.org_id
101: FROM cn_srp_quota_assigns_all sqa
102: ,cn_srp_quota_rules_all sqr
103: ,cn_quota_rule_uplifts_all qru
104: WHERE sqa.srp_plan_assign_id = p_srp_plan_assign_id
105: AND sqa.srp_quota_assign_id = sqr.srp_quota_assign_id
106: AND sqa.srp_plan_assign_id = sqr.srp_plan_assign_id
107: AND sqr.quota_rule_id = qru.quota_rule_id
137: ,Sysdate
138: ,fnd_global.login_id
139: ,sqr.org_id
140: FROM cn_srp_quota_rules_all sqr
141: ,cn_quota_rule_uplifts_all qru
142: WHERE sqr.quota_rule_id = p_quota_rule_id
143: AND qru.quota_rule_id = p_quota_rule_id
144: AND qru.quota_rule_id = sqr.quota_rule_id --bugfix 3633243
145: AND qru.quota_rule_uplift_id = p_quota_rule_uplift_id
173: ,Sysdate
174: ,fnd_global.login_id
175: ,sqr.org_id
176: FROM cn_srp_quota_rules_all sqr
177: ,cn_quota_rule_uplifts_all qru
178: WHERE sqr.quota_rule_id = qru.quota_rule_id
179: AND qru.quota_rule_id = p_quota_rule_id;
180:
181: