APPS.CN_PMTPLAN_PVT dependencies on CN_SRP_PMT_PLANS

Line 1005: FROM cn_srp_pmt_plans

1001: END IF;
1002:
1003: SELECT COUNT(1)
1004: INTO l_count
1005: FROM cn_srp_pmt_plans
1006: WHERE pmt_plan_id = l_pmt_plan_id;
1007:
1008: -- If pmt plan has been assigned, select current definition of pmt plan
1009: -- Ensure min_rec_flag and max_rec_flag are not updated

Line 1049: FROM cn_srp_pmt_plans

1045: END IF;
1046:
1047: SELECT MIN(start_date)
1048: INTO l_start_date
1049: FROM cn_srp_pmt_plans
1050: WHERE pmt_plan_id = l_pmt_plan_id;
1051:
1052: SELECT MAX(end_date)
1053: INTO l_end_date

Line 1054: FROM cn_srp_pmt_plans

1050: WHERE pmt_plan_id = l_pmt_plan_id;
1051:
1052: SELECT MAX(end_date)
1053: INTO l_end_date
1054: FROM cn_srp_pmt_plans
1055: WHERE pmt_plan_id = l_pmt_plan_id
1056: AND end_date IS NOT NULL;
1057:
1058: SELECT count(1)

Line 1060: FROM cn_srp_pmt_plans

1056: AND end_date IS NOT NULL;
1057:
1058: SELECT count(1)
1059: INTO l_null_end_date_srps
1060: FROM cn_srp_pmt_plans
1061: WHERE pmt_plan_id = l_pmt_plan_id
1062: AND end_date IS NULL;
1063:
1064: IF l_start_date < p_pmtplan_rec.start_date

Line 1405: FROM cn_srp_pmt_plans

1401:
1402: -- Payment plan cannot be deleted if there are salesreps assiged to the payment plan
1403: SELECT COUNT(1)
1404: INTO l_count
1405: FROM cn_srp_pmt_plans
1406: WHERE pmt_plan_id = l_pmt_plan_id;
1407: IF l_count <> 0
1408: THEN
1409: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)