DBA Data[Home] [Help]

APPS.FII_GL_EXTRACTION_UTIL dependencies on FND_FLEX_VALUES

Line 74: fnd_flex_values fv1,

70: and nvl( fnd_date.canonical_to_date( org_information4 ),
71: sysdate + 1 ) >= sysdate
72: ) mgr_tbl,
73: hr_organization_information org,
74: fnd_flex_values fv1,
75: fnd_flex_values fv2
76: where ccc_tbl.org_information_context = 'CLASS'
77: and ccc_tbl.org_information1 = 'CC'
78: and ccc_tbl.org_information2 = 'Y'

Line 75: fnd_flex_values fv2

71: sysdate + 1 ) >= sysdate
72: ) mgr_tbl,
73: hr_organization_information org,
74: fnd_flex_values fv1,
75: fnd_flex_values fv2
76: where ccc_tbl.org_information_context = 'CLASS'
77: and ccc_tbl.org_information1 = 'CC'
78: and ccc_tbl.org_information2 = 'Y'
79: and ccc_tbl.organization_id = mgr_tbl.organization_id (+)

Line 195: from fnd_flex_value_sets f1 ,fnd_flex_values f2

191: p_retcode := 0;
192:
193: select f1.FLEX_VALUE_SET_ID ,flex_value_id
194: INTO p_UNASSIGNED_VSET_ID, p_UNASSIGNED_ID
195: from fnd_flex_value_sets f1 ,fnd_flex_values f2
196: where flex_value_set_name = 'Financials Intelligence Internal Value Set'
197: and f1.flex_value_set_id = f2.flex_value_set_id
198: and flex_value = 'UNASSIGNED';
199: