APPS.CN_PMTPLAN_PVT dependencies on CN_PMT_PLANS_S

Line 59: SELECT nvl(p_PmtPlan_rec.pmt_plan_id,cn_pmt_plans_s.nextval)

55: FETCH get_PmtPlan_id INTO l_get_PmtPlan_id_rec;
56: IF get_PmtPlan_id%ROWCOUNT = 0
57: THEN
58: x_status := 'NEW PMT PLAN';
59: SELECT nvl(p_PmtPlan_rec.pmt_plan_id,cn_pmt_plans_s.nextval)
60: INTO x_pmt_plan_id
61: FROM dual;
62: ELSIF get_PmtPlan_id%ROWCOUNT = 1
63: THEN

Line 74: SELECT nvl(p_PmtPlan_rec.pmt_plan_id,cn_pmt_plans_s.nextval)

70: FETCH get_PmtPlan_id2 INTO l_get_PmtPlan_id_rec;
71: IF get_PmtPlan_id2%ROWCOUNT = 0
72: THEN
73: x_status := 'NEW PMT PLAN';
74: SELECT nvl(p_PmtPlan_rec.pmt_plan_id,cn_pmt_plans_s.nextval)
75: INTO x_pmt_plan_id
76: FROM dual;
77:
78: ELSIF get_PmtPlan_id2%ROWCOUNT = 1