[Home] [Help]
278: /* GL_USSGL_ACCOUNT_PAIRS */
279: /* GL_BALANCES */
280: /* GL_BUDGETS */
281: /* GL_BUDGET_VERSIONS */
282: /* GL_BUDGET_ASSIGNMENTS */
283: /* GL_BUDGET_PERIOD_RANGES */
284: /* GL_JE_BATCHES */
285: /* GL_JE_HEADERS */
286: /* GL_JE_LINES */
2661: g_session_id,
2662: g_serial_id,
2663: g_resp_appl_id
2664: from psa_option_details_gt od,
2665: gl_budget_assignments ba,
2666: gl_bc_packets bp,
2667: gl_budorg_bc_options bo
2668: where (od.je_source_name || ';' || od.je_category_name =
2669: bp.je_source_name || ';' ||bp.je_category_name )
2851: update gl_bc_packets bp
2852: set bp.funding_budget_version_id =
2853: (select decode(pk.actual_flag, 'B', pk.budget_version_id,
2854: bo.funding_budget_version_id)
2855: from gl_budget_assignments ba,
2856: gl_budgets b,
2857: gl_budget_versions bv,
2858: gl_period_statuses ps,
2859: gl_bc_packets pk,
2906: RESULT_CODE=
2907: ( select DECODE(count(bo.FUNDING_BUDGET_VERSION_ID),1,'F77','F80')
2908: from
2909: gl_bc_packets pk,
2910: gl_budget_assignments ba,
2911: gl_budorg_bc_options bo
2912: where
2913: pk.rowid=bp.rowid
2914: and pk.code_combination_id=ba.code_combination_id
3037: min(bo.amount_type),
3038: min(bo.boundary_code)
3039: from gl_bc_packets pk,
3040: psa_option_details_gt od,
3041: gl_budget_assignments ba,
3042: gl_budorg_bc_options bo
3043: where pk.rowid = bp.rowid
3044: and (od.je_source_name || ';' || od.je_category_name =
3045: pk.je_source_name || ';' || pk.je_category_name )
3075: and bp.funds_check_level_code = 'N'
3076: and bp.funding_budget_version_id IS NULL
3077: and exists
3078: (select null
3079: from gl_budget_assignments ba
3080: where ba.code_combination_id = bp.code_combination_id
3081: and ba.ledger_id = bp.ledger_id
3082: and ba.currency_code = bp.currency_code
3083: