DBA Data[Home] [Help]

APPS.FV_BE_INT_PKG dependencies on FV_LOOKUP_CODES

Line 36: g_advance_type_code fv_lookup_codes.lookup_code%TYPE;

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

Line 1232: from fv_lookup_codes

1228: segs_array(29) := valid_rec.segment29;
1229: segs_array(30) := valid_rec.segment30;
1230: begin
1231: select 'x' into v_source_exists
1232: from fv_lookup_codes
1233: where lookup_type='BE_SOURCE'
1234: AND lookup_code=valid_rec.source;
1235:
1236: exception

Line 2136: FROM fv_lookup_codes

2132: THEN
2133: BEGIN
2134: SELECT lookup_code
2135: INTO g_advance_type_code
2136: FROM fv_lookup_codes
2137: WHERE lookup_type = 'ADVANCE_FLAG'
2138: AND description = v_advance_type;
2139: EXCEPTION WHEN NO_DATA_FOUND THEN
2140: v_error_code := -7;