122: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PVT';
123:
124: CURSOR get_credit_type_id IS
125: SELECT credit_type_id
126: FROM cn_credit_types
127: WHERE name = p_PmtPlan_rec.credit_type_name
128: and org_id = p_PmtPlan_rec.org_id;
129:
130: CURSOR get_pay_interval_type_id IS
434: L_PROGRAM_TYPE VARCHAR2(30);
435:
436: CURSOR get_credit_type_id IS
437: SELECT credit_type_id
438: FROM cn_credit_types
439: WHERE name = p_PmtPlan_rec.credit_type_name
440: and org_id = p_PmtPlan_rec.org_id;
441:
442: CURSOR get_pay_interval_type_id IS
767: L_PROGRAM_TYPE VARCHAR2(30);
768:
769: CURSOR get_credit_type_id IS
770: SELECT credit_type_id
771: FROM cn_credit_types
772: WHERE name = p_PmtPlan_rec.credit_type_name
773: and org_id = p_PmtPlan_rec.org_id;
774:
775:
791: l_pp_oldrec get_pmt_plan%ROWTYPE;
792:
793: CURSOR get_credit_type_curs ( l_credit_type_id VArchar2) IS
794: SELECT name
795: FROM cn_credit_types
796: WHERE credit_type_id = l_credit_type_id
797: AND org_id = p_PmtPlan_rec.org_id;
798:
799: CURSOR get_interval_type_curs ( l_interval_type_id Varchar2 ) IS