DBA Data[Home] [Help]

APPS.FEM_UD_PKG dependencies on DUAL

Line 1901: FROM dual;

1897: v_new_columns := FALSE;
1898:
1899: -- Retrieve number to identify this calculation from the sequence
1900: SELECT fem_ud_upd_dep_s.nextval INTO x_upd_dep_calc_id
1901: FROM dual;
1902:
1903: -- Retrieve ledger, dataset code and calendar period for the candidate
1904: SELECT ledger_id, output_dataset_code, cal_period_id
1905: INTO v_ledger_id, v_output_dataset_code, v_cal_period_id

Line 3788: -- same undo logic as above for the individual statements).

3784: -- =========================================================================
3785: -- S2C: Process statements in FEM_PL_TABLES (MERGE statement section)
3786: -- Undo handles MERGE statements with the same logic as undoing an INSERT
3787: -- statement followed by the undoing of an UPDATE statement (using the
3788: -- same undo logic as above for the individual statements).
3789: -- =========================================================================
3790:
3791: -- Test to make sure that if Rule registered update columns,
3792: -- that the table being updated is an undo type that