APPS.FV_BE_INT_PKG dependencies on FV_LOOKUP_CODES

Line 35: g_advance_type_code fv_lookup_codes.lookup_code%TYPE;

31: g_pub_law_code_flag VARCHAR2(1);
32: g_advance_flag VARCHAR2(1);
33: g_transfer_flag VARCHAR2(1);
34:
35: g_advance_type_code fv_lookup_codes.lookup_code%TYPE;
36:
37: CURSOR app_col(v_sob_id IN NUMBER) IS
38: SELECT application_column_name,flex_value_set_id
39: FROM fnd_id_flex_segments ffs,

Line 1164: from fv_lookup_codes

1160: segs_array(29) := valid_rec.segment29;
1161: segs_array(30) := valid_rec.segment30;
1162: begin
1163: select 'x' into v_source_exists
1164: from fv_lookup_codes
1165: where lookup_type='BE_SOURCE'
1166: AND lookup_code=valid_rec.source;
1167:
1168: exception

Line 2049: FROM fv_lookup_codes

2045: THEN
2046: BEGIN
2047: SELECT lookup_code
2048: INTO g_advance_type_code
2049: FROM fv_lookup_codes
2050: WHERE lookup_type = 'ADVANCE_FLAG'
2051: AND description = v_advance_type;
2052: EXCEPTION WHEN NO_DATA_FOUND THEN
2053: v_error_code := -7;