DBA Data[Home] [Help]

APPS.IGI_RPI_UPDATE_VAT_RATE dependencies on IGI_RPI_STANDING_CHARGES_ALL

Line 115: FROM igi_rpi_standing_charges_all sc

111:
112: CURSOR C_standing_charges ( cp_org_id in number
113: , cp_effective_date in date ) IS
114: SELECT sc.*
115: FROM igi_rpi_standing_charges_all sc
116: WHERE org_id = cp_org_id
117: AND upper(sc.status) = 'ACTIVE'
118: AND sc.START_DATE <= cp_effective_date
119: AND sc.NEXT_DUE_DATE >= cp_effective_date;