DBA Data[Home] [Help]

APPS.FUN_SEQ_BATCH dependencies on XLA_ACCT_PROG_SEQ_V

Line 1286: FROM XLA_ACCT_PROG_SEQ_V

1282: l_doc_category_code_tbl,
1283: l_acct_event_type_code_tbl,
1284: l_acct_entry_type_code_tbl,
1285: l_gl_date_tbl
1286: FROM XLA_ACCT_PROG_SEQ_V
1287: WHERE completion_acct_seq_assign_id IS NULL
1288: AND completion_acct_seq_version_id IS NULL
1289: AND completion_acct_seq_value IS NULL;
1290:

Line 1445: UPDATE xla_acct_prog_seq_v

1441: -- Update XLA View in Bulk
1442: --
1443: IF l_sorted_assign_id_tbl.COUNT > 0 THEN
1444: FOR i IN l_sorted_assign_id_tbl.FIRST .. l_sorted_assign_id_tbl.LAST LOOP
1445: UPDATE xla_acct_prog_seq_v
1446: SET completion_acct_seq_assign_id = l_sorted_assign_id_tbl(i),
1447: completion_acct_seq_version_id = l_sorted_seq_ver_id_tbl(i),
1448: completion_acct_seq_value = l_sorted_seq_value_tbl(i),
1449: completion_date = l_sorted_seq_date_tbl(i)