2585: update ra_cust_trx_line_salesreps
2586: set last_updated_by = pg_user_id,
2587: last_update_date = sysdate,
2588: last_update_login = pg_login_id,
2589: revenue_amount_split = arpcurr.CurrRound(
2590: p_line_amount *
2591: ( revenue_percent_split / 100 ),
2592: p_foreign_currency_code
2593: ),
2590: p_line_amount *
2591: ( revenue_percent_split / 100 ),
2592: p_foreign_currency_code
2593: ),
2594: non_revenue_amount_split = arpcurr.CurrRound(
2595: p_line_amount *
2596: ( non_revenue_percent_split / 100 ),
2597: p_foreign_currency_code
2598: )
2859: null, 100,
2860: null
2861: )
2862: ),
2863: arpcurr.CurrRound(
2864: (
2865: NVL(
2866: ctls.revenue_percent_split,
2867: DECODE(
2882: null
2883: )
2884: ),
2885: ctls.non_revenue_percent_split,
2886: arpcurr.CurrRound(
2887: (ctls.non_revenue_percent_split / 100 ) *
2888: ctl.extended_amount,
2889: ct.invoice_currency_code
2890: ),
2953: null, 100,
2954: null
2955: )
2956: ),
2957: arpcurr.CurrRound(
2958: (
2959: NVL(
2960: ctls.revenue_percent_split,
2961: DECODE(
2976: null
2977: )
2978: ),
2979: ctls.non_revenue_percent_split,
2980: arpcurr.CurrRound(
2981: (ctls.non_revenue_percent_split / 100 ) *
2982: ctl.extended_amount,
2983: ct.invoice_currency_code
2984: )
3099: prev_ctls.cust_trx_line_salesrep_id,
3100: decode(prev_ctls.cust_trx_line_salesrep_id,
3101: null, 100,
3102: prev_ctls.revenue_percent_split),
3103: arpcurr.CurrRound(
3104: (decode(prev_ctls.cust_trx_line_salesrep_id,
3105: null, 100,
3106: prev_ctls.revenue_percent_split) / 100 ) *
3107: ctl.extended_amount,
3107: ctl.extended_amount,
3108: p_currency_code
3109: ), /* revenue_amount_split */
3110: prev_ctls.non_revenue_percent_split,
3111: arpcurr.CurrRound(
3112: (prev_ctls.non_revenue_percent_split / 100 ) *
3113: ctl.extended_amount,
3114: p_currency_code
3115: ) /* non_revenue_amount_split */
3229: null, 100,
3230: null
3231: )
3232: ),
3233: arpcurr.CurrRound(
3234: (
3235: NVL(
3236: prev_ctls.revenue_percent_split,
3237: DECODE(
3244: ) * ctl.extended_amount,
3245: cm_ct.invoice_currency_code
3246: ),
3247: prev_ctls.non_revenue_percent_split,
3248: arpcurr.CurrRound(
3249: (prev_ctls.non_revenue_percent_split / 100 ) *
3250: ctl.extended_amount,
3251: cm_ct.invoice_currency_code
3252: ) /* non_revenue_amount_split */