817:
818: BEGIN
819: SELECT name
820: INTO l_pmt_plan_name 821: FROM cn_pmt_plans_all 822: WHERE pmt_plan_id = p_pmt_plan_id;
823:
824: RETURN l_pmt_plan_name;
825:
Line 843: FROM cn_pmt_plans_all
839:
840: BEGIN
841: SELECT pmt_plan_id
842: INTO l_pmt_plan_id 843: FROM cn_pmt_plans_all 844: WHERE name = p_pmt_plan_name
845: AND org_id = p_org_id;
846:
847: RETURN l_pmt_plan_id;