DBA Data[Home] [Help]

APPS.IGIRRPS dependencies on AR_SYSTEM_PARAMETERS

Line 187: from ar_system_parameters )

183: SELECT sc.period_name
184: FROM igi_rpi_standing_charges sc
185: WHERE sc.standing_charge_id = pp_standing_charge_id
186: AND sc.set_of_books_id = ( select set_of_books_id
187: from ar_system_parameters )
188: AND sc.status = CHARGE_STATUS
189: ;
190: CURSOR C_periods ( pp_period_name in varchar2) IS
191: SELECT nvl(js.schedule_id,0) schedule_id

Line 239: from ar_system_parameters )

235: SELECT sc.period_name
236: FROM igi_rpi_standing_charges sc
237: WHERE sc.standing_charge_id = pp_standing_charge_id
238: AND sc.set_of_books_id = ( select set_of_books_id
239: from ar_system_parameters )
240: AND sc.status = CHARGE_STATUS
241: ;
242: CURSOR C_periods ( pp_period_name in varchar2) IS
243: SELECT nvl(js.schedule_id,-1) schedule_id

Line 296: from ar_system_parameters )

292: FROM igi_rpi_standing_charges sc
293: WHERE sc.standing_charge_id = cp_standing_charge_id
294: AND sc.generate_sequence = cp_generate_sequence
295: AND sc.set_of_books_id = ( select set_of_books_id
296: from ar_system_parameters )
297: AND sc.status = CHARGE_STATUS
298: ;
299: CURSOR c_lines ( cp_standing_charge_id in number) IS
300: select rowid row_id, start_date