DBA Data[Home] [Help]

APPS.PQP_GB_ABSENCE_PLAN_PROCESS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 8: FROM pay_element_type_extra_info eit

4: CURSOR csr_absence_pay_plan_category(p_pl_id NUMBER)
5: IS
6: SELECT eit.eei_information30 -- Absence Pay Plan Category
7: absence_pay_plan_category
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)

Line 19: FROM pay_element_type_extra_info eit

15: --
16: --
17: CURSOR csr_abs_plan_category_by_eid(p_element_type_id NUMBER) IS
18: SELECT eit.eei_information30 absence_pay_plan_category
19: FROM pay_element_type_extra_info eit
20: WHERE eit.element_type_id = p_element_type_id
21: AND ( -- is OSP Primary Element
22: ( eit.information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
23: AND