DBA Data[Home] [Help]

APPS.PAY_PL_SOE dependencies on FND_PROFILE

Line 112: if fnd_profile.value('PAY_PL_SOE_ELEMENTS_DISPLAY') = 'Y' then

108: if g_debug then
109: hr_utility.set_location('Entering pay_soe_glb.getElements', 10);
110: end if;
111: --
112: if fnd_profile.value('PAY_PL_SOE_ELEMENTS_DISPLAY') = 'Y' then
113:
114: l_sql :=
115: 'select /*+ ORDERED */ nvl(ettl.reporting_name,et.element_type_id) COL01
116: , nvl(ettl.reporting_name,ettl.element_name) COL02

Line 156: elsif fnd_profile.value('PAY_PL_SOE_ELEMENTS_DISPLAY') = 'N' then

152: , ettl.reporting_name
153: ,nvl(ettl.reporting_name,et.element_type_id)
154: order by nvl(ettl.reporting_name,ettl.element_name)';
155: --
156: elsif fnd_profile.value('PAY_PL_SOE_ELEMENTS_DISPLAY') = 'N' then
157:
158: l_sql :=
159: 'select /*+ ORDERED */ nvl(ettl.reporting_name,et.element_type_id) COL01
160: , nvl(ettl.reporting_name,ettl.element_name) COL02