APPS.ARP_ADDS_MINUS99 dependencies on AR_SYSTEM_PARAMETERS

Line 181: | Used to select distinct ORG_ID from AR_SYSTEM_PARAMETERS_ALL |

177: | PRIVATE CURSOR |
178: | organization_id_c |
179: | |
180: | DESCRIPTION |
181: | Used to select distinct ORG_ID from AR_SYSTEM_PARAMETERS_ALL |
182: | to create one record per ORG_ID for a new location_id in |
183: | AR_LOCATION_ACCOUNTS_ALL |
184: | |
185: | REQUIRES |

Line 188: | Returns distinct ORG_ID from AR_SYSTEM_PARAMETERS_ALL |

184: | |
185: | REQUIRES |
186: | |
187: | RETURNS |
188: | Returns distinct ORG_ID from AR_SYSTEM_PARAMETERS_ALL |
189: | |
190: | EXCEPTIONS RAISED |
191: | |
192: | MODIFICATION HISTORY |

Line 198: -- Organization Ids -3113 and -3114 are seeded in ar_system_parameters

194: | |
195: | |
196: +-------------------------------------------------------------------------*/
197:
198: -- Organization Ids -3113 and -3114 are seeded in ar_system_parameters
199: -- and we do not want to create records in ar_location_accounts_all table
200: -- for these org_id's. Hence we do not select them in the cursor.
201:
202: CURSOR organization_id_c is

Line 204: from ar_system_parameters_all

200: -- for these org_id's. Hence we do not select them in the cursor.
201:
202: CURSOR organization_id_c is
203: select nvl(org_id, -99), location_structure_id
204: from ar_system_parameters_all
205: where nvl(org_id, -99) not in (-3113, -3114)
206: and set_of_books_id <> -1;
207:
208: