DBA Data[Home] [Help]

APPS.JAI_OM_WSH_PKG dependencies on JA_LOOKUPS

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

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

Line 272: FROM ja_lookups

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