DBA Data[Home] [Help]

APPS.FUN_SEQ_BATCH dependencies on XLA_ACCT_PROG_SEQ_V

Line 1285: FROM XLA_ACCT_PROG_SEQ_V

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

Line 1444: UPDATE xla_acct_prog_seq_v

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