DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_USSGL_TRANSACTION_CODES

Line 277: /* GL_USSGL_TRANSACTION_CODES */

273: /* GL_BC_DUAL2 */
274: /* GL_CONCURRENCY_CONTROL */
275: /* GL_PERIOD_STATUSES */
276: /* GL_LOOKUPS */
277: /* GL_USSGL_TRANSACTION_CODES */
278: /* GL_USSGL_ACCOUNT_PAIRS */
279: /* GL_BALANCES */
280: /* GL_BUDGETS */
281: /* GL_BUDGET_VERSIONS */

Line 2148: 'gl_ussgl_transaction_codes uc, ' ||

2144: if g_reverse_tc_flag = 'N' then
2145:
2146: sql_ussgl := sql_ussgl ||
2147: 'from gl_lookups lu, ' ||
2148: 'gl_ussgl_transaction_codes uc, ' ||
2149: 'gl_ussgl_account_pairs guap, ' ||
2150: 'gl_code_combinations ccg, ' ||
2151: 'gl_code_combinations cco, ' ||
2152: 'gl_bc_packets bp, ' ||

Line 2184: 'gl_ussgl_transaction_codes uc, ' ||

2180:
2181: sql_ussgl := sql_ussgl ||
2182:
2183: 'from gl_lookups lu, ' ||
2184: 'gl_ussgl_transaction_codes uc, ' ||
2185: 'gl_ussgl_account_pairs guap, ' ||
2186: 'gl_code_combinations ccg, ' ||
2187: 'gl_code_combinations cco, ' ||
2188: 'gl_bc_packets bp ' ||

Line 2999: from gl_ussgl_transaction_codes uc,

2995: nvl(pk.bc_date, sysdate)) - nvl(pk.bc_date, sysdate)), -1, 'F28',
2996: decode(substr(pk.result_code,1,1),
2997: 'X', 'F' || substr(pk.result_code,2),
2998: null)))))))))))
2999: from gl_ussgl_transaction_codes uc,
3000: gl_budget_versions bv,
3001: gl_budget_period_ranges br,
3002: gl_period_statuses ps,
3003: gl_code_combinations cc,