DBA Data[Home] [Help]

APPS.FA_TRANSFER_XIT_PKG dependencies on DUAL

Line 28: FROM dual

24: CURSOR n_sob_id (p_psob_id IN NUMBER,
25: p_book_type_code IN VARCHAR2) is
26: SELECT p_psob_id AS sob_id,
27: 1 AS index_id
28: FROM dual
29: UNION
30: SELECT set_of_books_id AS sob_id,
31: 2 AS index_id
32: FROM fa_mc_book_controls

Line 874: -- individual fa_adjustments rows. other values already set in fautfr.

870: X_adj.code_combination_id := h_ccid;
871: X_adj.distribution_id := h_dist_id;
872:
873: -- call the insert into fa_adjusments funtion in SINGLE mode to insert the
874: -- individual fa_adjustments rows. other values already set in fautfr.
875:
876: X_adj.selection_mode := fa_adjust_type_pkg.FA_AJ_TRANSFER_SINGLE;
877: X_adj.gen_ccid_flag := TRUE;
878:

Line 1928: FROM dual

1924: CURSOR n_sob_id (p_psob_id IN NUMBER,
1925: p_book_type_code IN VARCHAR2) is
1926: SELECT p_psob_id AS sob_id,
1927: 1 AS index_id
1928: FROM dual
1929: UNION
1930: SELECT set_of_books_id AS sob_id,
1931: 2 AS index_id
1932: FROM fa_mc_book_controls