APPS.IGIRRGPP dependencies on AR_SYSTEM_PARAMETERS

Line 75: and set_of_books_id = ( select set_of_books_id from ar_system_parameters )

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
78: ( select 'x'
79: from igi_rpi_items items

Line 118: and set_of_books_id = ( select set_of_books_id from ar_system_parameters )

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: ;
121:
122: CURSOR c_rpi_items Is

Line 146: ( select set_of_books_id from ar_system_parameters )

142: FROM igi_rpi_items
143: where item_code >= pp_item_code_from
144: AND item_code <= pp_item_code_to
145: AND set_of_books_id =
146: ( select set_of_books_id from ar_system_parameters )
147: ;
148:
149: lv_updated_price igi_rpi_update_lines.updated_price%TYPE;
150: lv_select_flag igi_rpi_update_lines.select_flag%TYPE;