APPS.CN_PMTPLAN_PUB dependencies on DUAL

Line 65: FROM dual;

61: THEN
62: x_status := 'NEW PMT PLAN';
63: SELECT cn_pmt_plans_s.nextval
64: INTO x_pmt_plan_id
65: FROM dual;
66: ELSIF get_PmtPlan_id%ROWCOUNT = 1
67: THEN
68: x_status := 'PMT PLAN EXISTS';
69: x_pmt_plan_id := l_get_PmtPlan_id_rec.pmt_plan_id;

Line 80: FROM dual;

76: THEN
77: x_status := 'NEW PMT PLAN';
78: SELECT cn_pmt_plans_s.nextval
79: INTO x_pmt_plan_id
80: FROM dual;
81: ELSIF get_PmtPlan_id2%ROWCOUNT = 1
82: THEN
83: x_status := 'PMT PLAN EXISTS';
84: x_pmt_plan_id := l_get_PmtPlan_id_rec.pmt_plan_id;