APPS.PQP_ITERATIVE_ARREARAGE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 41: pay_element_type_extra_info pei

37: ,c_information_type In Varchar2) Is
38: select pei.eei_information1 -- Arrears Allowed
39: ,pei.eei_information2 -- Partial Allowed
40: from pay_element_types_f pet,
41: pay_element_type_extra_info pei
42: where pet.element_type_id = c_ele_type_id
43: and (pet.business_group_id = c_business_grp_id or
44: pet.legislation_code = l_legislation_code)
45: and pei.element_type_id = pet.element_type_id

Line 50: l_ele_information_type pay_element_type_extra_info.information_type%TYPE;

46: and pei.information_type = c_information_type
47: and trunc(c_effective_date) between pet.effective_start_date
48: and pet.effective_end_date;
49:
50: l_ele_information_type pay_element_type_extra_info.information_type%TYPE;
51: l_org_information_type hr_organization_information.org_information_context%TYPE;
52: l_arr_info_rec csr_arr_info%ROWTYPE;
53: l_org_info_rec csr_org_info%ROWTYPE;
54: l_calc_method hr_organization_information.org_information1%TYPE;