APPS.AR_LOCVS_PKG dependencies on AR_SYSTEM_PARAMETERS_ALL

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

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 |

Line 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

Line 116: from ar_system_parameters_all

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;