APPS.PAY_PL_SOE dependencies on PAY_PL_SOE

Line 1: PACKAGE BODY PAY_PL_SOE as

1: PACKAGE BODY PAY_PL_SOE as
2: /* $Header: pyplsoep.pkb 120.0 2005/10/14 03:53:12 mseshadr noship $ */
3:
4: l_sql long;
5: g_debug boolean := hr_utility.debug_enabled;

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

Line 237: end pay_pl_soe;

233: return getElements(p_assignment_action_id
234: ,pay_soe_util.getConfig('ELEMENTS2'));
235: end Elements2;
236: --
237: end pay_pl_soe;