DBA Data[Home] [Help]

APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_QUOTA_RULES_ALL

Line 844: cn_quota_rules_all qr

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

Line 883: cn_quota_rules_all qr

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