DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_COMMISSION_LINES_S

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

2272: posting_status, input_achieved,
2273: output_achieved, perf_achieved,
2274: pay_period_id, pending_status,
2275: role_id, pending_date, credited_comp_group_id, org_id )
2276: SELECT cn_commission_lines_s.nextval, line.credited_salesrep_id,
2277: line.processed_period_id, line.processed_date,
2278: line.quota_id, line.credit_type_id, line.quota_rule_id,
2279: line.event_factor, line.payment_factor,
2280: line.quota_factor, -( Nvl(line.commission_amount, 0) ),

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

3546: trx_type, created_during, error_reason,
3547: last_update_date, last_updated_by, creation_date,
3548: created_by, last_update_login, org_id )
3549: VALUES
3550: (cn_commission_lines_s.NEXTVAL, p_trx_rec.salesrep_id, l_header_id,
3551: 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,
3552: Round(Nvl(p_trx_rec.commission_amount,0), g_ext_precision),
3553: Round(Nvl(p_trx_rec.commission_rate,0), CN_GLOBAL_VAR.g_ext_precision ),
3554: Nvl(p_trx_rec.rate_tier_id, 0), Nvl(p_trx_rec.tier_split, 0),