DBA Data[Home] [Help]

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_SRP_PMT_PLANS_V

Line 380: p_payment_group_code IN cn_srp_pmt_plans_v.payment_group_code%TYPE,

376: (
377: p_salesrep_id IN cn_salesreps.salesrep_id%TYPE,
378: p_pmt_amount_adj_rec IN NUMBER,
379: p_pmt_amount_adj_nrec IN NUMBER,
380: p_payment_group_code IN cn_srp_pmt_plans_v.payment_group_code%TYPE,
381: p_period_id IN cn_payruns.pay_period_id%TYPE,
382: p_incentive_type IN cn_quotas.incentive_type_code%TYPE,
383: x_calc_rec_tbl IN OUT NOCOPY calc_rec_tbl_type,
384: --R12

Line 917: srp_pmt_plan cn_srp_pmt_plans_v%ROWTYPE;

913:
914: TYPE srppmtplncurtype IS REF CURSOR;
915:
916: srp_pmt_plan_cur srppmtplncurtype;
917: srp_pmt_plan cn_srp_pmt_plans_v%ROWTYPE;
918: l_stmt VARCHAR2(4000);
919:
920: -- Cursor to get the Periods
921: CURSOR get_prd_statuses(p_period_id NUMBER) IS