DBA Data[Home] [Help]

APPS.IGI_ITR_GL_INTERFACE_PKG dependencies on FND_APPLICATION

Line 15: From fnd_application

11: Where period_name = p_period_name
12: And set_of_books_id = p_set_of_books_id
13: And nvl(adjustment_period_flag,'N') = 'N'
14: And application_id = (Select application_id
15: From fnd_application
16: Where application_short_name = 'SQLGL');
17:
18: Cursor C_cat_name IS
19: Select user_je_category_name

Line 68: from fnd_application

64: where p1.period_type = p_period_type
65: and p1.set_of_books_id = p_set_of_books_id
66: and nvl(p1.adjustment_period_flag,'N') = 'N'
67: and p1.application_id = (select application_id
68: from fnd_application
69: where application_short_name = 'SQLGL')
70: and (p1.period_year >= p_start_period_year
71: and p1.period_year <= p_end_period_year)
72: and (p1.period_num >= p_start_period_num

Line 93: From fnd_application

89: Where trunc(sysdate) Between trunc(start_date) And trunc(end_date)
90: And set_of_books_id = p_set_of_books_id
91: And NVL(adjustment_period_flag,'N') = 'N'
92: And application_id = (Select application_id
93: From fnd_application
94: Where application_short_name = 'SQLGL');
95:
96: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
97: l_state_level number := FND_LOG.LEVEL_STATEMENT;