[Home] [Help]
288: /* GL_USSGL_TRANSACTION_CODES */
289: /* GL_USSGL_ACCOUNT_PAIRS */
290: /* GL_BALANCES */
291: /* GL_BUDGETS */
292: /* GL_BUDGET_VERSIONS */
293: /* GL_BUDGET_ASSIGNMENTS */
294: /* GL_BUDGET_PERIOD_RANGES */
295: /* GL_JE_BATCHES */
296: /* GL_JE_HEADERS */
2684: and ba.code_combination_id (+) = bp.code_combination_id
2685: and bo.range_id(+) = ba.range_id
2686: and bo.funding_budget_version_id
2687: in (select BV1.budget_version_id
2688: from gl_budget_versions bv1, gl_budgets b,
2689: gl_period_statuses ps
2690: where ba.ledger_id = g_ledger_id
2691: and ba.currency_code = bp.currency_code
2692: and ba.code_combination_id = bp.code_combination_id
2864: (select decode(pk.actual_flag, 'B', pk.budget_version_id,
2865: bo.funding_budget_version_id)
2866: from gl_budget_assignments ba,
2867: gl_budgets b,
2868: gl_budget_versions bv,
2869: gl_period_statuses ps,
2870: gl_bc_packets pk,
2871: gl_budorg_bc_options bo
2872: where
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,
3017: psa_option_details_gt od,
3230: gl_account_hierarchies ah,
3231: gl_bc_packets bp,
3232: gl_summary_bc_options sb,
3233: gl_budgets b,
3234: gl_budget_versions bv,
3235: gl_period_statuses ps2
3236: where st.status = 'F'
3237: and sb.funds_check_level_code || od.funds_check_level_code <> 'DN'
3238: and st.template_id = ah.template_id
3591: -- packet that need to be considered in this category include all rows
3592: -- with Funds Check Level None, and all Advisory Transactions with a
3593: -- lower rowid than that of the row currently being processed
3594:
3595: -- Subquery needs to join to gl_budgets, gl_budget_versions and
3596: -- gl_period_statuses to get the last period in the latest open year of
3597: -- the Funding Budget for the Boundary Code 'project'
3598:
3599: -- Summary of WHERE clauses based on Amount Type and Boundary :
3666: 0)
3667: )
3668: from gl_period_statuses ps,
3669: gl_budgets bd,
3670: gl_budget_versions bv,
3671: gl_bc_packets pk,
3672: gl_bc_packet_arrival_order ao
3673: where ps.application_id = 101
3674: and ps.ledger_id = g_ledger_id
8258:
8259: l_tmp_stmt := l_tmp_stmt || ' FROM gl_je_lines l, gl_je_headers h, ';
8260:
8261: IF (l_actual_flag = 'B') THEN
8262: l_tmp_stmt := l_tmp_stmt || 'gl_budget_versions bv, ';
8263: END IF;
8264:
8265: l_tmp_stmt := l_tmp_stmt || ' gl_period_statuses ps WHERE ps.application_id = '||l_appl_id||
8266: ' AND ps.ledger_id = '||l_ledger_id ||
8970: GL_BC_PACKET_ARRIVAL_ORDER AO,
8971: GL_SUMMARY_TEMPLATES ST,
8972: GL_SUMMARY_BC_OPTIONS SB,
8973: GL_BUDGETS B,
8974: GL_BUDGET_VERSIONS BV,
8975: GL_PERIOD_STATUSES PS
8976:
8977: WHERE
8978: AH.ledger_id = p_ledger_id
9119: GL_BC_PACKET_ARRIVAL_ORDER AO,
9120: GL_SUMMARY_TEMPLATES ST,
9121: GL_SUMMARY_BC_OPTIONS SB,
9122: GL_BUDGETS B,
9123: GL_BUDGET_VERSIONS BV,
9124: GL_PERIOD_STATUSES PS
9125: WHERE AH.ledger_id = p_ledger_id
9126: AND AH.detail_code_combination_id = BP.code_combination_id
9127: AND AH.template_id = p_curr_temp_id
9234: gl_bc_packet_arrival_order ao,
9235: gl_summary_templates st,
9236: gl_summary_bc_options sb,
9237: gl_budgets b,
9238: gl_budget_versions bv,
9239: gl_period_statuses ps
9240: WHERE ah.ledger_id = p_ledger_id
9241: AND ah.template_id = p_curr_temp_id
9242: AND ah.summary_code_combination_id = bp2.code_combination_id