DBA Data[Home] [Help]

APPS.FII_GL_EXTRACTION_UTIL dependencies on FND_DATE

Line 68: and nvl( fnd_date.canonical_to_date( org_information3 ),

64: from hr_organization_information ccc_tbl,
65: ( select /*+ parallel(b) */ organization_id, org_information2
66: from hr_organization_information b
67: where org_information_context = 'Organization Name Alias'
68: and nvl( fnd_date.canonical_to_date( org_information3 ),
69: sysdate + 1 ) <= sysdate
70: and nvl( fnd_date.canonical_to_date( org_information4 ),
71: sysdate + 1 ) >= sysdate
72: ) mgr_tbl,

Line 70: and nvl( fnd_date.canonical_to_date( org_information4 ),

66: from hr_organization_information b
67: where org_information_context = 'Organization Name Alias'
68: and nvl( fnd_date.canonical_to_date( org_information3 ),
69: sysdate + 1 ) <= sysdate
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,