DBA Data[Home] [Help]

APPS.PSA_FUNDS_CHECKER_PKG dependencies on GL_BUDORG_BC_OPTIONS

Line 2667: gl_budorg_bc_options bo

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 )
2670: and od.packet_id = bp.packet_id
2671: and ba.ledger_id (+) = g_ledger_id

Line 2860: gl_budorg_bc_options bo

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

Line 2911: gl_budorg_bc_options bo

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
2915: and pk.ledger_id = ba.ledger_id

Line 3042: gl_budorg_bc_options bo

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 )
3046: and od.packet_id = pk.packet_id