APPS.IGI_RPI_UPDATE_VAT_RATE dependencies on IGI_RPI_LINE_DETAILS_ALL

Line 129: FROM igi_rpi_line_details_all ld

125:
126: CURSOR C_line_details (cp_standing_charge_id in number
127: ,cp_old_vat_id in number ) IS
128: SELECT ld.*
129: FROM igi_rpi_line_details_all ld
130: WHERE ld.standing_charge_id = cp_standing_charge_id
131: AND ld.vat_tax_id = cp_old_vat_id;
132:
133:

Line 209: UPDATE igi_rpi_line_details_all ld SET

205:
206:
207: /* Updating new VAT Rate to all charge lines */
208:
209: UPDATE igi_rpi_line_details_all ld SET
210: ld.VAT_TAX_ID = p_new_vat_id
211: WHERE ld.standing_charge_id = C_standing_charges_rec.standing_charge_id
212: AND ld.line_item_id = C_line_details_rec.line_item_id
213: AND ld.org_id = p_org_id;