APPS.CN_PMTPLAN_PVT dependencies on DUAL

Line 61: FROM dual;

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
64: x_status := 'PMT PLAN EXISTS';
65: x_pmt_plan_id := l_get_PmtPlan_id_rec.pmt_plan_id;

Line 76: FROM dual;

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
79: THEN
80: x_status := 'PMT PLAN EXISTS';