DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_USSGL_TRANSACTION_CODES

Line 288: /* GL_USSGL_TRANSACTION_CODES */

284: /* GL_BC_DUAL2 */
285: /* GL_CONCURRENCY_CONTROL */
286: /* GL_PERIOD_STATUSES */
287: /* GL_LOOKUPS */
288: /* GL_USSGL_TRANSACTION_CODES */
289: /* GL_USSGL_ACCOUNT_PAIRS */
290: /* GL_BALANCES */
291: /* GL_BUDGETS */
292: /* GL_BUDGET_VERSIONS */

Line 2159: 'gl_ussgl_transaction_codes uc, ' ||

2155: if g_reverse_tc_flag = 'N' then
2156:
2157: sql_ussgl := sql_ussgl ||
2158: ' from gl_lookups lu, ' ||
2159: 'gl_ussgl_transaction_codes uc, ' ||
2160: 'gl_ussgl_account_pairs guap, ' ||
2161: 'gl_code_combinations ccg, ' ||
2162: 'gl_code_combinations cco, ' ||
2163: 'gl_bc_packets bp, ' ||

Line 2195: 'gl_ussgl_transaction_codes uc, ' ||

2191:
2192: sql_ussgl := sql_ussgl ||
2193:
2194: ' from gl_lookups lu, ' ||
2195: 'gl_ussgl_transaction_codes uc, ' ||
2196: 'gl_ussgl_account_pairs guap, ' ||
2197: 'gl_code_combinations ccg, ' ||
2198: 'gl_code_combinations cco, ' ||
2199: 'gl_bc_packets bp ' ||

Line 3012: from gl_ussgl_transaction_codes uc,

3008: nvl(pk.bc_date, sysdate)) - nvl(pk.bc_date, sysdate)), -1, 'F28',
3009: decode(substr(pk.result_code,1,1),
3010: 'X', 'F' || substr(pk.result_code,2),
3011: null)))))))))))))
3012: from gl_ussgl_transaction_codes uc,
3013: gl_budget_versions bv,
3014: gl_budget_period_ranges br,
3015: gl_period_statuses ps,
3016: gl_code_combinations cc,