APPS.CN_PMTPLAN_PUB dependencies on CN_PMT_PLANS_S

Line 63: SELECT cn_pmt_plans_s.nextval

59: FETCH get_PmtPlan_id INTO l_get_PmtPlan_id_rec;
60: IF get_PmtPlan_id%ROWCOUNT = 0
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

Line 78: SELECT cn_pmt_plans_s.nextval

74: FETCH get_PmtPlan_id2 INTO l_get_PmtPlan_id_rec;
75: IF get_PmtPlan_id2%ROWCOUNT = 0
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

Line 444: l_start_date cn_pmt_plans.start_date%TYPE;

440: l_api_version CONSTANT NUMBER := 1.0;
441: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PUB';
442:
443: l_create_rec cn_pmtplan_pvt.PmtPlan_rec_type;
444: l_start_date cn_pmt_plans.start_date%TYPE;
445: l_status VARCHAR2(1);
446: cursor get_start_date is
447: select start_date from cn_pmt_plans
448: where name = p_PmtPlan_rec.name