698: l_ap_pa_tbl(1).unit_price := ap_inv_rec.unit_price;
699:
700: ----Modified for bug 8927385
701: IF ap_inv_rec.invoice_distribution_type = 'IPV' THEN
702: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
703: p_invoice_id => ap_inv_rec.invoice_id,
704: p_invoice_dist_type => 'IPV');
705: ELSIF ap_inv_rec.invoice_distribution_type = 'FREIGHT' THEN
706: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
702: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
703: p_invoice_id => ap_inv_rec.invoice_id,
704: p_invoice_dist_type => 'IPV');
705: ELSIF ap_inv_rec.invoice_distribution_type = 'FREIGHT' THEN
706: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
707: p_invoice_id => ap_inv_rec.invoice_id,
708: p_invoice_dist_type => 'FREIGHT');
709: ELSIF ap_inv_rec.invoice_distribution_type = 'REC_TAX' THEN
710: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
706: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
707: p_invoice_id => ap_inv_rec.invoice_id,
708: p_invoice_dist_type => 'FREIGHT');
709: ELSIF ap_inv_rec.invoice_distribution_type = 'REC_TAX' THEN
710: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
711: p_invoice_id => ap_inv_rec.invoice_id,
712: p_invoice_dist_type => 'RTAX');
713: ELSIF ap_inv_rec.invoice_distribution_type = 'NONREC_TAX' THEN
714: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
710: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
711: p_invoice_id => ap_inv_rec.invoice_id,
712: p_invoice_dist_type => 'RTAX');
713: ELSIF ap_inv_rec.invoice_distribution_type = 'NONREC_TAX' THEN
714: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
715: p_invoice_id => ap_inv_rec.invoice_id,
716: p_invoice_dist_type => 'NRTAX');
717: ELSIF ap_inv_rec.invoice_distribution_type = 'TRV' THEN
718: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
714: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
715: p_invoice_id => ap_inv_rec.invoice_id,
716: p_invoice_dist_type => 'NRTAX');
717: ELSIF ap_inv_rec.invoice_distribution_type = 'TRV' THEN
718: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
719: p_invoice_id => ap_inv_rec.invoice_id,
720: p_invoice_dist_type => 'TRV');
721: ELSIF ap_inv_rec.invoice_distribution_type = 'TIPV' THEN
722: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
718: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
719: p_invoice_id => ap_inv_rec.invoice_id,
720: p_invoice_dist_type => 'TRV');
721: ELSIF ap_inv_rec.invoice_distribution_type = 'TIPV' THEN
722: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
723: p_invoice_id => ap_inv_rec.invoice_id,
724: p_invoice_dist_type => 'TIPV');
725: ELSIF ap_inv_rec.invoice_distribution_type = 'ERV' THEN
726: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
722: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
723: p_invoice_id => ap_inv_rec.invoice_id,
724: p_invoice_dist_type => 'TIPV');
725: ELSIF ap_inv_rec.invoice_distribution_type = 'ERV' THEN
726: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
727: p_invoice_id => ap_inv_rec.invoice_id,
728: p_invoice_dist_type => 'EXCHANGE_RATE_VARIANCE');
729: ELSIF ap_inv_rec.invoice_distribution_type = 'TERV' THEN
730: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
726: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
727: p_invoice_id => ap_inv_rec.invoice_id,
728: p_invoice_dist_type => 'EXCHANGE_RATE_VARIANCE');
729: ELSIF ap_inv_rec.invoice_distribution_type = 'TERV' THEN
730: l_ap_pa_tbl(1).inv_dist_ccid := cse_asset_util_pkg.get_ap_sla_acct_id(
731: p_invoice_id => ap_inv_rec.invoice_id,
732: p_invoice_dist_type => 'TERV');
733: END IF; -- need to put TIPV for TIPV case --Modified for bug 8927385
734: