APPS.FWK_TBX_SEED dependencies on FWK_TBX_LOOKUP_CODES_B

Line 44: insert into fwk_tbx_lookup_codes_b (

40: p_end_date date)
41: is
42: begin
43:
44: insert into fwk_tbx_lookup_codes_b (
45: lookup_type,
46: lookup_code,
47: start_date_active,
48: end_date_active

Line 56: from fwk_tbx_lookup_codes_b

52: p_start_date,
53: p_end_date
54: from dual
55: where not exists (select null
56: from fwk_tbx_lookup_codes_b
57: where lookup_type = p_lookup_type
58: and lookup_code = p_lookup_code);
59:
60: insert into fwk_tbx_lookup_codes_tl (

Line 115: update fwk_tbx_lookup_codes_b set

111: p_end_date date)
112: is
113: begin
114:
115: update fwk_tbx_lookup_codes_b set
116: lookup_type = p_lookup_type,
117: lookup_code = p_lookup_code,
118: start_date_active = p_start_date,
119: end_date_active = p_end_date

Line 163: delete from fwk_tbx_lookup_codes_b

159: p_lookup_code varchar2)
160: is
161: begin
162:
163: delete from fwk_tbx_lookup_codes_b
164: where lookup_type = p_lookup_type
165: and lookup_code = p_lookup_code;
166:
167: if (sql%notfound) then