DBA Data[Home] [Help]

APPS.FII_BUDGET_INTERFACE_PKG dependencies on GL_LEDGERS_PUBLIC_V

Line 68: gl_ledgers_public_v where

64: fnd_flex_values_tl d
65: WHERE a.ID_FLEX_CODE = 'GL#'
66: AND a.APPLICATION_ID = 101
67: AND a.ID_FLEX_NUM in (select chart_of_accounts_id from
68: gl_ledgers_public_v where
69: ledger_id = X_Ledger)
70: AND a.application_id = b.application_id
71: AND a.id_flex_code = b.id_flex_code
72: AND a.id_flex_num = b.id_flex_num

Line 94: gl_ledgers_public_v where

90: fnd_flex_values_tl d
91: WHERE a.ID_FLEX_CODE = 'GL#'
92: AND a.APPLICATION_ID = 101
93: AND a.ID_FLEX_NUM in (select chart_of_accounts_id from
94: gl_ledgers_public_v where
95: ledger_id = X_Ledger)
96: AND a.application_id = b.application_id
97: AND a.id_flex_code = b.id_flex_code
98: AND a.id_flex_num = b.id_flex_num

Line 120: gl_ledgers_public_v where

116: fnd_flex_values_tl d
117: WHERE a.ID_FLEX_CODE = 'GL#'
118: AND a.APPLICATION_ID = 101
119: AND a.ID_FLEX_NUM in (select chart_of_accounts_id from
120: gl_ledgers_public_v where
121: ledger_id = X_Ledger)
122: AND a.application_id = b.application_id
123: AND a.id_flex_code = b.id_flex_code
124: AND a.id_flex_num = b.id_flex_num

Line 148: gl_ledgers_public_v sob

144: WHERE dimension_short_name = 'FII_USER_DEFINED_1'
145: UNION
146: SELECT map.flex_value_set_id1 id
147: FROM fii_dim_mapping_rules map, fii_slg_assignments sts, fii_source_ledger_groups slg,
148: gl_ledgers_public_v sob
149: WHERE map.dimension_short_name = 'FII_USER_DEFINED_1'
150: AND map.chart_of_accounts_id = sts.chart_of_accounts_id
151: AND sts.source_ledger_group_id = slg.source_ledger_group_id
152: AND slg.usage_code = 'DBI'