DBA Data[Home] [Help]

APPS.PQP_GB_ABSENCE_PLAN_PROCESS dependencies on FND_NUMBER

Line 12: AND eit.eei_information1 = fnd_number.number_to_canonical(p_pl_id)

8: FROM pay_element_type_extra_info eit
9: WHERE UPPER(eit.eei_information19) = 'ABSENCE INFO'
10: AND eit.information_type IN -- either
11: ('PQP_GB_OSP_ABSENCE_PLAN_INFO', 'PQP_GB_OMP_ABSENCE_PLAN_INFO')
12: AND eit.eei_information1 = fnd_number.number_to_canonical(p_pl_id)
13: AND ROWNUM < 2; -- any element will do
14: --
15: --
16: --