APPS.CN_SRP_RULE_UPLIFTS_PKG dependencies on CN_SRP_QUOTA_ASSIGNS

Line 62: FROM cn_srp_quota_assigns_all sqa

58: ,fnd_global.user_id
59: ,Sysdate
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

Line 101: FROM cn_srp_quota_assigns_all sqa

97: ,fnd_global.user_id
98: ,Sysdate
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

Line 258: , cn_srp_quota_assigns sqa

254: DELETE FROM cn_srp_rule_uplifts_all sru
255: WHERE sru.srp_quota_rule_id IN
256: ( SELECT sqr.srp_quota_rule_id
257: FROM cn_srp_quota_rules_all sqr
258: , cn_srp_quota_assigns sqa
259: WHERE sqa.srp_quota_assign_id = sqr.srp_quota_assign_id
260: AND sqa.srp_plan_assign_id = sqr.srp_plan_assign_id
261: AND sqa.srp_plan_assign_id = p_srp_plan_assign_id
262: AND sqa.quota_id = p_quota_id )

Line 323: FROM cn_srp_quota_assigns_all q,

319: set u.payment_factor = p_payment_factor
320: , u.quota_factor = p_quota_factor
321: WHERE u.quota_rule_uplift_id = p_quota_rule_uplift_id
322: AND EXISTS (SELECT 'quota rule uplift belongs to a uncustomized quota'
323: FROM cn_srp_quota_assigns_all q,
324: cn_srp_quota_rules_all r
325: WHERE q.srp_quota_assign_id = r.srp_quota_assign_id
326: AND r.srp_quota_rule_id = u.srp_quota_rule_id
327: AND q.customized_flag = 'N')