374: (
375: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
376: p_pmt_amount_adj_rec IN NUMBER,
377: p_pmt_amount_adj_nrec IN NUMBER,
378: p_payment_group_code IN cn_srp_pmt_plans_v.payment_group_code%TYPE,
379: p_period_id IN cn_payruns.pay_period_id%TYPE,
380: p_incentive_type IN cn_quotas.incentive_type_code%TYPE,
381: x_calc_rec_tbl IN OUT NOCOPY calc_rec_tbl_type,
382: --R12
911:
912: TYPE srppmtplncurtype IS REF CURSOR;
913:
914: srp_pmt_plan_cur srppmtplncurtype;
915: srp_pmt_plan cn_srp_pmt_plans_v%ROWTYPE;
916: l_stmt VARCHAR2(4000);
917:
918: -- Cursor to get the Periods
919: CURSOR get_prd_statuses(p_period_id NUMBER) IS