[Home] [Help]
277: /* GL_USSGL_TRANSACTION_CODES */
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 */
2673: and ba.code_combination_id (+) = bp.code_combination_id
2674: and bo.range_id(+) = ba.range_id
2675: and bo.funding_budget_version_id
2676: in (select BV1.budget_version_id
2677: from gl_budget_versions bv1, gl_budgets b,
2678: gl_period_statuses ps
2679: where ba.ledger_id = g_ledger_id
2680: and ba.currency_code = bp.currency_code
2681: and ba.code_combination_id = bp.code_combination_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,
2860: gl_budorg_bc_options bo
2861: where
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,
3004: psa_option_details_gt od,
3217: gl_account_hierarchies ah,
3218: gl_bc_packets bp,
3219: gl_summary_bc_options sb,
3220: gl_budgets b,
3221: gl_budget_versions bv,
3222: gl_period_statuses ps2
3223: where st.status = 'F'
3224: and sb.funds_check_level_code || od.funds_check_level_code <> 'DN'
3225: and st.template_id = ah.template_id
3517: -- packet that need to be considered in this category include all rows
3518: -- with Funds Check Level None, and all Advisory Transactions with a
3519: -- lower rowid than that of the row currently being processed
3520:
3521: -- Subquery needs to join to gl_budgets, gl_budget_versions and
3522: -- gl_period_statuses to get the last period in the latest open year of
3523: -- the Funding Budget for the Boundary Code 'project'
3524:
3525: -- Summary of WHERE clauses based on Amount Type and Boundary :
3592: 0)
3593: )
3594: from gl_period_statuses ps,
3595: gl_budgets bd,
3596: gl_budget_versions bv,
3597: gl_bc_packets pk,
3598: gl_bc_packet_arrival_order ao
3599: where ps.application_id = 101
3600: and ps.ledger_id = g_ledger_id
8072:
8073: l_tmp_stmt := l_tmp_stmt || ' FROM gl_je_lines l, gl_je_headers h, ';
8074:
8075: IF (l_actual_flag = 'B') THEN
8076: l_tmp_stmt := l_tmp_stmt || 'gl_budget_versions bv, ';
8077: END IF;
8078:
8079: l_tmp_stmt := l_tmp_stmt || ' gl_period_statuses ps WHERE ps.application_id = '||l_appl_id||
8080: ' AND ps.ledger_id = '||l_ledger_id ||
8784: GL_BC_PACKET_ARRIVAL_ORDER AO,
8785: GL_SUMMARY_TEMPLATES ST,
8786: GL_SUMMARY_BC_OPTIONS SB,
8787: GL_BUDGETS B,
8788: GL_BUDGET_VERSIONS BV,
8789: GL_PERIOD_STATUSES PS
8790:
8791: WHERE
8792: AH.ledger_id = p_ledger_id
8933: GL_BC_PACKET_ARRIVAL_ORDER AO,
8934: GL_SUMMARY_TEMPLATES ST,
8935: GL_SUMMARY_BC_OPTIONS SB,
8936: GL_BUDGETS B,
8937: GL_BUDGET_VERSIONS BV,
8938: GL_PERIOD_STATUSES PS
8939: WHERE AH.ledger_id = p_ledger_id
8940: AND AH.detail_code_combination_id = BP.code_combination_id
8941: AND AH.template_id = p_curr_temp_id
9048: gl_bc_packet_arrival_order ao,
9049: gl_summary_templates st,
9050: gl_summary_bc_options sb,
9051: gl_budgets b,
9052: gl_budget_versions bv,
9053: gl_period_statuses ps
9054: WHERE ah.ledger_id = p_ledger_id
9055: AND ah.template_id = p_curr_temp_id
9056: AND ah.summary_code_combination_id = bp2.code_combination_id