103: | PRIVATE CURSOR |
104: | organization_id_c |
105: | |
106: | DESCRIPTION |
107: | Used to select distinct ORG_ID from AR_SYSTEM_PARAMETERS_ALL |
108: | to create one record per ORG_ID for a new location_id in |
109: | AR_LOCATION_ACCOUNTS_ALL |
110: | RETURNS |
111: | Returns distinct ORG_ID from AR_SYSTEM_PARAMETERS_ALL |
107: | Used to select distinct ORG_ID from AR_SYSTEM_PARAMETERS_ALL |
108: | to create one record per ORG_ID for a new location_id in |
109: | AR_LOCATION_ACCOUNTS_ALL |
110: | RETURNS |
111: | Returns distinct ORG_ID from AR_SYSTEM_PARAMETERS_ALL |
112: +-------------------------------------------------------------------------*/
113:
114: CURSOR organization_id_c is
115: select nvl(org_id, -99), location_structure_id
112: +-------------------------------------------------------------------------*/
113:
114: CURSOR organization_id_c is
115: select nvl(org_id, -99), location_structure_id
116: from ar_system_parameters_all
117: where nvl(org_id, -99) not in (-3113, -3114)
118: and set_of_books_id <> -1;
119:
120: l_location_value_account_id number;