APPS.CN_API dependencies on CN_PMT_PLANS

Line 792: RETURN cn_pmt_plans.name%TYPE IS

788: --| Function Name : get_pp_name
789: --| Desc : Pass in payment plan id then return payment plan name
790: --| ---------------------------------------------------------------------+
791: FUNCTION get_pp_name( p_pmt_plan_id NUMBER)
792: RETURN cn_pmt_plans.name%TYPE IS
793:
794: l_pmt_plan_name cn_pmt_plans.name%TYPE;
795:
796: BEGIN

Line 794: l_pmt_plan_name cn_pmt_plans.name%TYPE;

790: --| ---------------------------------------------------------------------+
791: FUNCTION get_pp_name( p_pmt_plan_id NUMBER)
792: RETURN cn_pmt_plans.name%TYPE IS
793:
794: l_pmt_plan_name cn_pmt_plans.name%TYPE;
795:
796: BEGIN
797: SELECT name
798: INTO l_pmt_plan_name

Line 799: FROM cn_pmt_plans_all

795:
796: BEGIN
797: SELECT name
798: INTO l_pmt_plan_name
799: FROM cn_pmt_plans_all
800: WHERE pmt_plan_id = p_pmt_plan_id;
801:
802: RETURN l_pmt_plan_name;
803:

Line 814: RETURN cn_pmt_plans.pmt_plan_id%TYPE IS

810: --| Function Name : get_pp_id
811: --| Desc : Pass in payment plan name then return payment plan id
812: --| ---------------------------------------------------------------------+
813: FUNCTION get_pp_id( p_pmt_plan_name VARCHAR2, p_org_id NUMBER)
814: RETURN cn_pmt_plans.pmt_plan_id%TYPE IS
815:
816: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
817:
818: BEGIN

Line 816: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;

812: --| ---------------------------------------------------------------------+
813: FUNCTION get_pp_id( p_pmt_plan_name VARCHAR2, p_org_id NUMBER)
814: RETURN cn_pmt_plans.pmt_plan_id%TYPE IS
815:
816: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
817:
818: BEGIN
819: SELECT pmt_plan_id
820: INTO l_pmt_plan_id

Line 821: FROM cn_pmt_plans_all

817:
818: BEGIN
819: SELECT pmt_plan_id
820: INTO l_pmt_plan_id
821: FROM cn_pmt_plans_all
822: WHERE name = p_pmt_plan_name
823: AND org_id = p_org_id;
824:
825: RETURN l_pmt_plan_id;