APPS.IGI_EFC_UPGRADE dependencies on GL_BUDGET_ENTITIES

Line 59: gl_budget_entities ent,

55: CURSOR C_UPG_GL_BUDGET_ASSIGNMENT (pp_range_id NUMBER)
56: IS
57: SELECT IGIGL.*,ent.NAME BUDGET_NAME,led.NAME LEDGER_NAME
58: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT IGIGL,
59: gl_budget_entities ent,
60: GL_LEDGERS led
61: WHERE IGIGL.RANGE_ID = pp_range_id
62: AND IGIGL.budget_entity_id = ent.budget_entity_id
63: AND IGIGL.ledger_id = led.ledger_id

Line 2774: FROM GL_BUDGET_ENTITIES glent

2770: AND NVL(BA3.SEGMENT30_HIGH,'X') = NVL(BA4.SEGMENT30_HIGH,'X')
2771: ))
2772: AND EXISTS
2773: (SELECT 1
2774: FROM GL_BUDGET_ENTITIES glent
2775: WHERE
2776: BA1.ledger_id = glent.ledger_id AND
2777: EXISTS (
2778: SELECT 1

Line 2788: FROM gl_budget_entities glent

2784: );
2785:
2786: CURSOR c_ledger_info IS
2787: SELECT DISTINCT glent.ledger_id
2788: FROM gl_budget_entities glent
2789: WHERE EXISTS (
2790: SELECT 1
2791: FROM psa_efc_options psaefc
2792: WHERE psaefc.set_of_books_id = glent.ledger_id

Line 3086: FROM gl_budget_entities glent

3082: ATTRIBUTE14,
3083: ATTRIBUTE15
3084: FROM GL_BUDGET_ASSIGNMENT_RANGES gar
3085: WHERE exists (SELECT 1
3086: FROM gl_budget_entities glent
3087: WHERE
3088: gar.ledger_id = glent.ledger_id AND
3089: EXISTS (
3090: SELECT 1

Line 3436: FROM GL_BUDGET_ENTITIES glent

3432: ATTRIBUTE14,
3433: ATTRIBUTE15
3434: FROM GL_BUDGET_ASSIGNMENT_RANGES gar
3435: WHERE exists (SELECT 1
3436: FROM GL_BUDGET_ENTITIES glent
3437: WHERE
3438: gar.ledger_id = glent.ledger_id AND
3439: EXISTS (
3440: SELECT 1