DBA Data[Home] [Help]

APPS.CN_SRP_QUOTA_ASSIGNS_PKG dependencies on CN_QUOTA_RULES_ALL

Line 114: , cn_quota_rules_all cqr

110: FROM
111: (
112: SELECT 'X'
113: FROM cn_srp_quota_assigns_all csqa
114: , cn_quota_rules_all cqr
115: , cn_srp_quota_rules_all csqr
116: , cn_quota_rule_uplifts_all cqru
117: , cn_srp_rule_uplifts_all csru
118: WHERE csqa.srp_quota_assign_id = x_srp_quota_assign_id

Line 574: FROM cn_quota_rules_all qr,

570: SELECT qr.target,
571: qr.payment_amount,
572: qr.performance_goal,
573: sqr.srp_quota_rule_id
574: FROM cn_quota_rules_all qr,
575: cn_srp_quota_rules_all sqr
576: WHERE qr.quota_rule_id = sqr.quota_rule_id
577: AND sqr.srp_quota_assign_id = x_srp_quota_assign_id
578: ;