DBA Data[Home] [Help]

APPS.IGIRRPS dependencies on IGI_RPI_LINE_DETAILS_ALL

Line 512: from igi_rpi_line_details_all

508: charge_item_number,
509: item_id,
510: price,
511: current_effective_date
512: from igi_rpi_line_details_all
513: where standing_charge_id = cp_sc_id
514: ;
515:
516: BEGIN

Line 737: update igi_rpi_line_details_all

733: x_previous_price => line_rec.PRICE,
734: x_previous_effective_date => line_rec.CURRENT_EFFECTIVE_DATE
735:
736: );
737: update igi_rpi_line_details_all
738: set previous_price = price,
739: previous_effective_date = current_effective_date,
740: price = revised_price,
741: current_effective_date = revised_effective_date,