[Home] [Help]
61: -- entity code 'PARENT'
62:
63: CURSOR find_entry(c_entity_id NUMBER) IS
64: SELECT min(entry_id), decode(min(entry_id), NULL, 'N', 'Y')
65: FROM GCS_ENTRY_HEADERS
66: WHERE hierarchy_id = p_hierarchy_id
67: AND entity_id = c_entity_id
68: AND currency_code = p_currency_code
69: AND balance_type_code = p_balance_type_code