APPS.CN_SRP_PMT_PLANS_PUB dependencies on CN_SRP_PMT_PLANS_ALL

Line 111: FROM cn_srp_pmt_plans_all

107: BEGIN
108: IF p_action = 'GETOLDREC' THEN
109: SELECT *
110: INTO x_srp_pmt_plans_row
111: FROM cn_srp_pmt_plans_all
112: WHERE pmt_plan_id = x_srp_pmt_plans_row.pmt_plan_id
113: AND salesrep_id = x_srp_pmt_plans_row.salesrep_id
114: AND trunc(start_date) = trunc(p_srp_pmt_plans_rec.start_date)
115: ;