DBA Data[Home] [Help]

APPS.CN_SRP_RULE_UPLIFTS_PKG dependencies on CN_QUOTA_RULE_UPLIFTS_ALL

Line 64: ,cn_quota_rule_uplifts_all qru

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

Line 103: ,cn_quota_rule_uplifts_all qru

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

Line 141: ,cn_quota_rule_uplifts_all qru

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

Line 177: ,cn_quota_rule_uplifts_all qru

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: