DBA Data[Home] [Help]

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_SRP_PMT_PLANS_V

Line 378: p_payment_group_code IN cn_srp_pmt_plans_v.payment_group_code%TYPE,

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

Line 915: srp_pmt_plan cn_srp_pmt_plans_v%ROWTYPE;

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