APPS.CN_SRP_PMT_PLANS_PKG dependencies on CN_SRP_PMT_PLANS_S

Line 34: SELECT cn_srp_pmt_plans_s.nextval

30: PROCEDURE Get_UID( X_srp_pmt_plan_id IN OUT NOCOPY NUMBER) IS
31:
32: BEGIN
33:
34: SELECT cn_srp_pmt_plans_s.nextval
35: INTO X_srp_pmt_plan_id
36: FROM dual;
37:
38: END Get_UID;

Line 328: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;

324: ,x_object_version_number NUMBER
325: ,x_lock_flag VARCHAR2 ) IS
326:
327: l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;
328: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
329: l_org_id cn_srp_pmt_plans.org_id%TYPE;
330: l_role_id cn_srp_pmt_plans.role_id%TYPE;
331: l_credit_type_id cn_srp_pmt_plans.credit_type_id%TYPE;
332: l_start_date cn_srp_pmt_plans.start_date%TYPE;

Line 332: l_start_date cn_srp_pmt_plans.start_date%TYPE;

328: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
329: l_org_id cn_srp_pmt_plans.org_id%TYPE;
330: l_role_id cn_srp_pmt_plans.role_id%TYPE;
331: l_credit_type_id cn_srp_pmt_plans.credit_type_id%TYPE;
332: l_start_date cn_srp_pmt_plans.start_date%TYPE;
333: l_end_date cn_srp_pmt_plans.end_date%TYPE;
334: l_minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE;
335: l_maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE;
336: l_max_recovery_amount cn_srp_pmt_plans.max_recovery_amount%TYPE;