DBA Data[Home] [Help]

APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_QUOTA_RULES_ALL

Line 842: cn_quota_rules_all qr

838: UPDATE cn_srp_per_quota_rc_all rc
839: SET period_to_date =
840: (SELECT nvl(sum(cl.perf_achieved), 0)
841: FROM cn_commission_lines_all cl,
842: cn_quota_rules_all qr
843: WHERE cl.credited_Salesrep_id = p_srp_pe_subledger.salesrep_id
844: AND cl.quota_id = p_srp_pe_subledger.quota_id
845: AND cl.processed_period_id = p_srp_pe_subledger.accu_period_id
846: AND cl.status = 'CALC'

Line 881: cn_quota_rules_all qr

877: UPDATE cn_srp_per_quota_rc_all rc
878: SET period_to_date =
879: (SELECT nvl(sum(cl.perf_achieved), 0)
880: FROM cn_commission_lines_all cl,
881: cn_quota_rules_all qr
882: WHERE cl.credited_Salesrep_id = p_srp_pe_subledger.salesrep_id
883: AND cl.quota_id = p_srp_pe_subledger.quota_id
884: AND cl.processed_period_id = p_srp_pe_subledger.accu_period_id
885: AND cl.status = 'CALC'