DBA Data[Home] [Help]

APPS.IGIRGLOBE dependencies on IGI_AR_SYSTEM_OPTIONS_ALL

Line 62: from igi_ar_system_options_all

58: sysdate creation_date, sysdate last_update_date,
59: -1 last_updated_by, -1 created_by, -1 last_update_login
60: from ar_system_parameters_all aspa
61: where not exists ( select 'Already set up'
62: from igi_ar_system_options_all
63: where set_of_books_id = aspa.set_of_books_id
64: and org_id = aspa.org_id )
65: ;
66:

Line 71: insert into igi_ar_system_options_all ( set_of_books_id

67: BEGIN
68:
69:
70: for l_asp in c_ar_system_options loop
71: insert into igi_ar_system_options_all ( set_of_books_id
72: , accounting_method
73: , org_id
74: , creation_date
75: , created_by

Line 92: DELETE FROM igi_ar_system_options_all a

88: );
89: end loop;
90:
91: /* Start Bug 3749634 */
92: DELETE FROM igi_ar_system_options_all a
93: WHERE NOT EXISTS
94: (
95: SELECT 'X'
96: FROM ar_system_parameters_all