DBA Data[Home] [Help]

APPS.FV_SF133_LOAD dependencies on FV_SF133_DEFINITIONS_LINES

Line 46: FROM fv_sf133_definitions_lines

42: -- ------------------------------------
43: -- Clear and Load SF133 Line Definitions
44: -- ------------------------------------
45: DELETE
46: FROM fv_sf133_definitions_lines
47: WHERE set_of_books_id = g_set_of_books_id;
48: --
49:
50: INSERT

Line 51: INTO fv_sf133_definitions_lines

47: WHERE set_of_books_id = g_set_of_books_id;
48: --
49:
50: INSERT
51: INTO fv_sf133_definitions_lines
52: (sf133_line_id,
53: set_of_books_id,
54: sf133_line_number,
55: sf133_line_label,

Line 90: FROM fv_sf133_definitions_lines

86: FROM fv_sf133_definitions_accts
87: WHERE (sf133_line_id)
88: IN
89: (SELECT set_of_books_id
90: FROM fv_sf133_definitions_lines
91: WHERE g_set_of_books_id = set_of_books_id);
92: --
93: IF g_load_accounts = 'Y' THEN
94: -- ------------------------------------

Line 229: FROM fv_sf133_definitions_lines line,

225: decode(v_account_segment_name,
226: 'SEGMENT29',load.sf133_line_account, NULL),
227: decode(v_account_segment_name,
228: 'SEGMENT30',load.sf133_line_account, NULL)
229: FROM fv_sf133_definitions_lines line,
230: fv_sf133_load_accts load
231: WHERE line.sf133_line_number = load.sf133_line_number
232: AND line.set_of_books_id = g_set_of_books_id;
233: END IF;