DBA Data[Home] [Help]

APPS.PQP_UK_UNION_DEDUCTION dependencies on PAY_ELEMENT_TYPES_F

Line 46: FROM pay_element_types_f ele

42: SELECT TO_NUMBER(eei.eei_information1) -- Union Organisation_ID
43: ,eei.eei_information2 -- Union Level Balance Name
44: ,hrl.meaning -- Pension Rate Type Name
45: ,eei.eei_information4 -- Union Funds Lookup Type - Fund List
46: FROM pay_element_types_f ele
47: ,pay_element_type_extra_info eei
48: ,hr_lookups hrl
49: ,fnd_sessions fnd
50: WHERE ele.element_type_id = p_element_type_id

Line 67: FROM pay_element_types_f ele

63: SELECT TO_NUMBER(eei.eei_information1) -- Union Organisation_ID
64: ,eei.eei_information2 -- Union Level Balance Name
65: ,hrl.meaning -- Pension Rate Type Name
66: ,eei.eei_information4 -- Union Funds Lookup Type - Fund List
67: FROM pay_element_types_f ele
68: ,pay_element_type_extra_info eei
69: ,fnd_sessions fnd
70: ,(SELECT *
71: FROM fnd_lookup_values