DBA Data[Home] [Help]

APPS.PV_CHECK_MATCH_PUB dependencies on GL_PERIODS

Line 1295: and exists (select 1 from gl_periods glp

1291: day.period_set_name = g_period_set_name AND
1292: day.period_type = g_period_type AND
1293: day.period_day = TRUNC(p_currency_conversion_date)
1294: --- Condition added to fix the bug # 5509934
1295: and exists (select 1 from gl_periods glp
1296: where glp.period_set_name=g_period_set_name
1297: and glp.adjustment_period_flag='N'
1298: and glp.period_type = g_period_type
1299: and glp.period_name = day.period_name

Line 1591: exists (select 1 from gl_periods glp

1587: day.period_set_name = g_period_set_name AND
1588: day.period_type = g_period_type AND
1589: day.period_day = TRUNC(l_currency_date) AND
1590: --- Condition added to fix the bug # 5509934
1591: exists (select 1 from gl_periods glp
1592: where glp.period_set_name=g_period_set_name
1593: and glp.adjustment_period_flag='N'
1594: and glp.period_type = g_period_type
1595: and glp.period_name = day.period_name