3124: WHERE
3125: BA1.ledger_id = glent.ledger_id AND
3126: EXISTS (
3127: SELECT 1
3128: FROM PSA_EFC_OPTIONS psaefc
3129: WHERE psaefc.set_of_books_id = glent.ledger_id
3130: AND psaefc.mult_funding_budgets_flag = 'Y'
3131: ))
3132:
3137: SELECT DISTINCT glent.ledger_id
3138: FROM gl_budget_entities glent
3139: WHERE EXISTS (
3140: SELECT 1
3141: FROM psa_efc_options psaefc
3142: WHERE psaefc.set_of_books_id = glent.ledger_id
3143: AND psaefc.mult_funding_budgets_flag = 'Y'
3144: );
3145:
3455: WHERE
3456: gar.ledger_id = glent.ledger_id AND
3457: EXISTS (
3458: SELECT 1
3459: FROM psa_efc_options psaefc
3460: WHERE psaefc.set_of_books_id = glent.ledger_id
3461: AND psaefc.mult_funding_budgets_flag = 'Y'
3462: ));
3463:
3813: WHERE
3814: gar.ledger_id = glent.ledger_id AND
3815: EXISTS (
3816: SELECT 1
3817: FROM PSA_EFC_OPTIONS psaefc
3818: WHERE psaefc.set_of_books_id = glent.ledger_id
3819: AND psaefc.mult_funding_budgets_flag = 'Y'
3820: ));
3821: