DBA Data[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JA_LOOKUPS

Line 265: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, lv_lookup_type ja_lookups.lookup_type%type) IS

261: WHERE A.register_id = B.register_id
262: AND B.organization_id = p_organization_id
263: AND B.location_id = p_location_id);
264:
265: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, lv_lookup_type ja_lookups.lookup_type%type) IS
266: SELECT meaning
267: FROM ja_lookups
268: WHERE lookup_code = p_register_code
269: AND lookup_type = lv_lookup_type ; /*'JAI_REGISTER_TYPE'; Ramananda for removal of SQL LITERALs */

Line 267: FROM ja_lookups

263: AND B.location_id = p_location_id);
264:
265: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, lv_lookup_type ja_lookups.lookup_type%type) IS
266: SELECT meaning
267: FROM ja_lookups
268: WHERE lookup_code = p_register_code
269: AND lookup_type = lv_lookup_type ; /*'JAI_REGISTER_TYPE'; Ramananda for removal of SQL LITERALs */
270:
271: CURSOR fin_year_cur(p_organization_id IN NUMBER) IS