DBA Data[Home] [Help]

APPS.JAI_AR_IMPORT_POPU_PKG dependencies on SO_LOOKUPS

Line 3215: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_lookup_type So_lookups.lookup_type%TYPE ) IS

3211: FROM JAI_CMN_INVENTORY_ORGS
3212: WHERE organization_id = p_organization_id AND
3213: location_id = p_location_id;
3214:
3215: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_lookup_type So_lookups.lookup_type%TYPE ) IS
3216: SELECT meaning
3217: FROM So_lookups
3218: WHERE lookup_code = p_register_code
3219: AND lookup_type = cp_lookup_type;

Line 3217: FROM So_lookups

3213: location_id = p_location_id;
3214:
3215: CURSOR Register_Code_Meaning_Cur(p_register_code IN VARCHAR2, cp_lookup_type So_lookups.lookup_type%TYPE ) IS
3216: SELECT meaning
3217: FROM So_lookups
3218: WHERE lookup_code = p_register_code
3219: AND lookup_type = cp_lookup_type;
3220:
3221: CURSOR fin_year_cur(p_org_id IN NUMBER) IS