DBA Data[Home] [Help]

APPS.IGIRGLOBE dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 60: from ar_system_parameters_all aspa

56: cursor c_ar_system_options is
57: select set_of_books_id, org_id, accounting_method,
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 )

Line 96: FROM ar_system_parameters_all

92: DELETE FROM igi_ar_system_options_all a
93: WHERE NOT EXISTS
94: (
95: SELECT 'X'
96: FROM ar_system_parameters_all
97: WHERE org_id = a.org_id
98: AND set_of_books_id = a.set_of_books_id
99: );
100: /* End Bug 3749634 */