DBA Data[Home] [Help]

APPS.IGI_EFC_UPGRADE dependencies on GL_BUDGET_ENTITIES

Line 125: gl_budget_entities ent,

121: CURSOR C_UPG_GL_BUDGET_ASSIGNMENT (pp_range_id NUMBER)
122: IS
123: SELECT IGIGL.*,ent.NAME BUDGET_NAME,led.NAME LEDGER_NAME
124: FROM IGI_UPG_GL_BUDGET_ASSIGNMENT IGIGL,
125: gl_budget_entities ent,
126: GL_LEDGERS led
127: WHERE IGIGL.RANGE_ID = pp_range_id
128: AND IGIGL.budget_entity_id = ent.budget_entity_id
129: AND IGIGL.ledger_id = led.ledger_id

Line 3123: FROM GL_BUDGET_ENTITIES glent

3119: AND NVL(BA3.SEGMENT30_HIGH,'X') = NVL(BA4.SEGMENT30_HIGH,'X')
3120: ))
3121: AND EXISTS
3122: (SELECT 1
3123: FROM GL_BUDGET_ENTITIES glent
3124: WHERE
3125: BA1.ledger_id = glent.ledger_id AND
3126: EXISTS (
3127: SELECT 1

Line 3138: FROM gl_budget_entities glent

3134:
3135: -- Fetches all EFC Enabled ledgers
3136: CURSOR c_ledger_info IS
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

Line 3454: FROM gl_budget_entities glent

3450: ATTRIBUTE14,
3451: ATTRIBUTE15
3452: FROM GL_BUDGET_ASSIGNMENT_RANGES gar
3453: WHERE exists (SELECT 1
3454: FROM gl_budget_entities glent
3455: WHERE
3456: gar.ledger_id = glent.ledger_id AND
3457: EXISTS (
3458: SELECT 1

Line 3812: FROM GL_BUDGET_ENTITIES glent

3808: ATTRIBUTE14,
3809: ATTRIBUTE15
3810: FROM GL_BUDGET_ASSIGNMENT_RANGES gar
3811: WHERE exists (SELECT 1
3812: FROM GL_BUDGET_ENTITIES glent
3813: WHERE
3814: gar.ledger_id = glent.ledger_id AND
3815: EXISTS (
3816: SELECT 1