APPS.CN_API dependencies on CN_PMT_PLANS

Line 814: RETURN cn_pmt_plans.name%TYPE IS

810: --| Function Name : get_pp_name
811: --| Desc : Pass in payment plan id then return payment plan name
812: --| ---------------------------------------------------------------------+
813: FUNCTION get_pp_name( p_pmt_plan_id NUMBER)
814: RETURN cn_pmt_plans.name%TYPE IS
815:
816: l_pmt_plan_name cn_pmt_plans.name%TYPE;
817:
818: BEGIN

Line 816: l_pmt_plan_name cn_pmt_plans.name%TYPE;

812: --| ---------------------------------------------------------------------+
813: FUNCTION get_pp_name( p_pmt_plan_id NUMBER)
814: RETURN cn_pmt_plans.name%TYPE IS
815:
816: l_pmt_plan_name cn_pmt_plans.name%TYPE;
817:
818: BEGIN
819: SELECT name
820: INTO l_pmt_plan_name

Line 821: FROM cn_pmt_plans_all

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 836: RETURN cn_pmt_plans.pmt_plan_id%TYPE IS

832: --| Function Name : get_pp_id
833: --| Desc : Pass in payment plan name then return payment plan id
834: --| ---------------------------------------------------------------------+
835: FUNCTION get_pp_id( p_pmt_plan_name VARCHAR2, p_org_id NUMBER)
836: RETURN cn_pmt_plans.pmt_plan_id%TYPE IS
837:
838: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
839:
840: BEGIN

Line 838: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;

834: --| ---------------------------------------------------------------------+
835: FUNCTION get_pp_id( p_pmt_plan_name VARCHAR2, p_org_id NUMBER)
836: RETURN cn_pmt_plans.pmt_plan_id%TYPE IS
837:
838: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
839:
840: BEGIN
841: SELECT pmt_plan_id
842: INTO l_pmt_plan_id

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;