DBA Data[Home] [Help]

APPS.PER_FR_UPGRADE_DATA_PKG dependencies on FND_LOOKUP_VALUES

Line 128: Note: fnd_lookup_values is used for the source table as we need to check

124: p_core_lookup_type in varchar2) return number
125: IS
126: --
127: /* Find which lookups are in the french lookup but not the core lookup
128: Note: fnd_lookup_values is used for the source table as we need to check
129: lookups for any dates. hr_lookups only gets lookup at session date
130: The destination table is hr_leg_lookups. This is necessary as some
131: APIs validate to this view and we need to ensure that the TAG column
132: is taken into account. This view obtains at session date, this is

Line 139: from fnd_lookup_values lup1

135: cursor csr_missing_lookup
136: IS
137: select lup1.lookup_code
138: ,lup1.meaning
139: from fnd_lookup_values lup1
140: where lup1.lookup_type = p_fr_lookup_type
141: and NOT exists (select lup2.lookup_code
142: from hr_leg_lookups lup2
143: where lup2.lookup_type = p_core_lookup_type