DBA Data[Home] [Help]

APPS.FUN_SEQ_BATCH dependencies on DUAL

Line 1965: FROM dual ) sqtmp

1961: INTO x_ae_header_id_tbl,
1962: x_assign_id_tbl,
1963: x_seq_ver_id_tbl
1964: FROM THE (SELECT CAST( l_temp_tab as fun_seq_bt_tbl_type)
1965: FROM dual ) sqtmp
1966: ORDER BY
1967: sqtmp.seq_version_id,
1968: sqtmp.sorting_key;
1969:

Line 2018: FROM dual ) sqtmp, gl_period_statuses ps, gl_je_headers h

2014: sqtmp.seq_version_id seq_version_id,
2015: ps.period_num period_num,
2016: sqtmp.sorting_key sorting_key
2017: FROM THE (SELECT CAST( l_temp_tab as fun_seq_bt_tbl_type)
2018: FROM dual ) sqtmp, gl_period_statuses ps, gl_je_headers h
2019: WHERE
2020: ps.period_name = h.period_name
2021: AND ps.ledger_id = h.ledger_id
2022: AND ps.application_id = 101

Line 2033: FROM dual ) sqtmp, gl_period_statuses ps, xla_ae_headers ah

2029: sqtmp.seq_version_id seq_version_id,
2030: ps.period_num period_num,
2031: sqtmp.sorting_key sorting_key
2032: FROM THE (SELECT CAST( l_temp_tab as fun_seq_bt_tbl_type)
2033: FROM dual ) sqtmp, gl_period_statuses ps, xla_ae_headers ah
2034: WHERE
2035: ps.period_name = ah.period_name
2036: AND ps.ledger_id = ah.ledger_id
2037: AND ps.application_id = 101