DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_COMMISSION_LINES_S

Line 2292: SELECT cn_commission_lines_s.nextval, line.credited_salesrep_id,

2288: posting_status, input_achieved,
2289: output_achieved, perf_achieved,
2290: pay_period_id, pending_status,
2291: role_id, pending_date, credited_comp_group_id, org_id )
2292: SELECT cn_commission_lines_s.nextval, line.credited_salesrep_id,
2293: line.processed_period_id, line.processed_date,
2294: line.quota_id, line.credit_type_id, line.quota_rule_id,
2295: line.event_factor, line.payment_factor,
2296: line.quota_factor, -( Nvl(line.commission_amount, 0) ),

Line 3579: (cn_commission_lines_s.NEXTVAL, p_trx_rec.salesrep_id, l_header_id,

3575: trx_type, created_during, error_reason,
3576: last_update_date, last_updated_by, creation_date,
3577: created_by, last_update_login, org_id )
3578: VALUES
3579: (cn_commission_lines_s.NEXTVAL, p_trx_rec.salesrep_id, l_header_id,
3580: p_trx_rec.quota_id, p_trx_rec.credit_type_id, p_trx_rec.srp_plan_assign_id, l_role_id, p_trx_rec.status,
3581: Round(Nvl(p_trx_rec.commission_amount,0), g_ext_precision),
3582: Round(Nvl(p_trx_rec.commission_rate,0), CN_GLOBAL_VAR.g_ext_precision ),
3583: Nvl(p_trx_rec.rate_tier_id, 0), Nvl(p_trx_rec.tier_split, 0),