DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_BUDORG_BC_OPTIONS

Line 2678: gl_budorg_bc_options bo

2674: g_resp_appl_id
2675: from psa_option_details_gt od,
2676: gl_budget_assignments ba,
2677: gl_bc_packets bp,
2678: gl_budorg_bc_options bo
2679: where (od.je_source_name || ';' || od.je_category_name =
2680: bp.je_source_name || ';' ||bp.je_category_name )
2681: and od.packet_id = bp.packet_id
2682: and ba.ledger_id (+) = g_ledger_id

Line 2871: gl_budorg_bc_options bo

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
2873: ba.ledger_id(+) = g_ledger_id
2874: and ba.currency_code(+) = decode(PK.currency_code,
2875: 'STAT', 'STAT',

Line 2922: gl_budorg_bc_options bo

2918: ( select DECODE(count(bo.FUNDING_BUDGET_VERSION_ID),1,'F77','F80')
2919: from
2920: gl_bc_packets pk,
2921: gl_budget_assignments ba,
2922: gl_budorg_bc_options bo
2923: where
2924: pk.rowid=bp.rowid
2925: and pk.code_combination_id=ba.code_combination_id
2926: and pk.ledger_id = ba.ledger_id

Line 3055: gl_budorg_bc_options bo

3051: min(bo.boundary_code)
3052: from gl_bc_packets pk,
3053: psa_option_details_gt od,
3054: gl_budget_assignments ba,
3055: gl_budorg_bc_options bo
3056: where pk.rowid = bp.rowid
3057: and (od.je_source_name || ';' || od.je_category_name =
3058: pk.je_source_name || ';' || pk.je_category_name )
3059: and od.packet_id = pk.packet_id