69: AND items.item_id = lines.item_id
70: )
71: AND exists
72: ( select 'x'
73: from igi_rpi_standing_charges charges
74: where lines.standing_charge_id = charges.standing_charge_id
75: and set_of_books_id = ( select set_of_books_id from ar_system_parameters )
76: )
77: AND exists
112: AND items.item_id = lines.item_id
113: )
114: AND exists
115: ( select 'x'
116: from igi_rpi_standing_charges charges
117: where lines.standing_charge_id = charges.standing_charge_id
118: and set_of_books_id = ( select set_of_books_id from ar_system_parameters )
119: )
120: ;