APPS.CN_SRP_QUOTA_RULES_PKG dependencies on CN_SRP_QUOTA_ASSIGNS_ALL

Line 92: FROM cn_srp_quota_assigns_all q

88: r.performance_goal = x_performance_goal
89: WHERE r.quota_rule_id = x_quota_rule_id
90: AND r.srp_quota_rule_id = x_srp_quota_rule_id
91: AND EXISTS (SELECT 'quota rule belongs to a customized quota'
92: FROM cn_srp_quota_assigns_all q
93: WHERE q.srp_quota_assign_id = r.srp_quota_assign_id
94: AND q.customized_flag = 'Y')
95: ;
96:

Line 106: FROM cn_srp_quota_assigns_all q

102: r.payment_amount = x_payment_amount,
103: r.performance_goal = x_performance_goal
104: WHERE r.srp_quota_rule_id = x_srp_quota_rule_id
105: AND EXISTS (SELECT 'quota rule belongs to a customized quota'
106: FROM cn_srp_quota_assigns_all q
107: WHERE q.srp_quota_assign_id = r.srp_quota_assign_id
108: AND q.customized_flag = 'Y')
109: ;
110:

Line 119: FROM cn_srp_quota_assigns_all q

115: r.payment_amount = x_payment_amount,
116: r.performance_goal = x_performance_goal
117: WHERE r.quota_rule_id = x_quota_rule_id
118: AND EXISTS (SELECT 'quota rule belongs to a uncustomized quota'
119: FROM cn_srp_quota_assigns_all q
120: WHERE q.srp_quota_assign_id = r.srp_quota_assign_id
121: AND q.customized_flag = 'N')
122: ;
123: END IF;

Line 146: UPDATE cn_srp_quota_assigns_all

142: l_performance_goal
143: FROM cn_srp_quota_rules_all
144: WHERE srp_quota_assign_id = l_srp_quota_assign_id;
145:
146: UPDATE cn_srp_quota_assigns_all
147: SET target = l_target,
148: payment_amount = l_payment_amount,
149: performance_goal = l_performance_goal
150: WHERE srp_quota_assign_id = l_srp_quota_assign_id

Line 211: FROM cn_srp_quota_assigns_all sqa

207: ,fnd_global.user_id
208: ,Sysdate
209: ,fnd_global.login_id
210: ,sqa.org_id
211: FROM cn_srp_quota_assigns_all sqa
212: ,cn_quota_rules_all qr
213: WHERE sqa.srp_plan_assign_id = x_srp_plan_assign_id
214: AND sqa.quota_id = x_quota_id
215: AND qr.quota_id = sqa.quota_id

Line 252: FROM cn_srp_quota_assigns_all sqa

248: ,fnd_global.user_id
249: ,Sysdate
250: ,fnd_global.login_id
251: ,sqa.org_id
252: FROM cn_srp_quota_assigns_all sqa
253: ,cn_quota_rules_all qr
254: WHERE sqa.srp_plan_assign_id = x_srp_plan_assign_id
255: AND sqa.quota_id = qr.quota_id
256: AND sqa.quota_type_code IN ('FORMULA','EXTERNAL')

Line 295: FROM cn_srp_quota_assigns_all sqa

291: ,fnd_global.user_id
292: ,Sysdate
293: ,fnd_global.login_id
294: ,sqa.org_id
295: FROM cn_srp_quota_assigns_all sqa
296: ,cn_quota_rules_all qr
297: WHERE sqa.quota_id = x_quota_id
298: AND qr.quota_id = sqa.quota_id
299: AND qr.quota_rule_id = x_quota_rule_id

Line 337: FROM cn_srp_quota_assigns_all sqa

333: ,fnd_global.user_id
334: ,Sysdate
335: ,fnd_global.login_id
336: ,sqa.org_id
337: FROM cn_srp_quota_assigns_all sqa
338: ,cn_quota_rules_all qr
339: WHERE sqa.quota_id = x_quota_id
340: AND qr.quota_id = sqa.quota_id
341: AND sqa.quota_type_code IN ('FORMULA', 'EXTERNAL')