DBA Data[Home] [Help]

APPS.PQP_GB_PENSION_FUNCTIONS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 391: FROM pay_element_type_extra_info

387: CURSOR csr_get_sch_cate_type(c_element_type_id NUMBER)
388: IS
389: SELECT eei_information4, --Scheme Category
390: eei_information8 --Scheme Type(COSR/COMP)
391: FROM pay_element_type_extra_info
392: WHERE element_type_id = c_element_type_id
393: AND information_type = 'PQP_GB_PENSION_SCHEME_INFO';
394:
395: l_curr_ele_cate VARCHAR2 (10);

Line 1252: l_emp_deduction_mthd pay_element_type_extra_info.eei_information1%TYPE;

1248: l_element_type_id NUMBER;
1249: l_effective_start_date DATE;
1250: l_effective_end_date DATE;
1251: l_tab_element_types_info t_element_types;
1252: l_emp_deduction_mthd pay_element_type_extra_info.eei_information1%TYPE;
1253: --
1254: BEGIN
1255: --
1256: IF g_debug