APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 3032: from pay_element_type_extra_info

3028:
3029: /*
3030: CURSOR csr_ele_code (p_ele_type_id NUMBER , p_le_org_id NUMBER ) IS
3031: select eei_information1
3032: from pay_element_type_extra_info
3033: where element_type_id = p_ele_type_id
3034: and ( eei_information2 = p_le_org_id OR eei_information2 is null )
3035: and information_type = 'NO_ELEMENT_CODES'
3036: and eei_information_category = 'NO_ELEMENT_CODES'

Line 3044: select nvl((select eei_information1 from pay_element_type_extra_info petei

3040:
3041: -- modifying the above cursor
3042:
3043: cursor csr_ele_code(p_ele_type_id NUMBER , p_leg_emp_id NUMBER ) is
3044: select nvl((select eei_information1 from pay_element_type_extra_info petei
3045: where petei.information_type='NO_ELEMENT_CODES'
3046: and element_type_id = p_ele_type_id
3047: and petei.eei_information2 = p_leg_emp_id
3048: and rownum=1),

Line 3049: (select eei_information1 from pay_element_type_extra_info petei

3045: where petei.information_type='NO_ELEMENT_CODES'
3046: and element_type_id = p_ele_type_id
3047: and petei.eei_information2 = p_leg_emp_id
3048: and rownum=1),
3049: (select eei_information1 from pay_element_type_extra_info petei
3050: where petei.information_type='NO_ELEMENT_CODES'
3051: and element_type_id = p_ele_type_id
3052: and eei_information2 is null
3053: and rownum=1)) from dual;

Line 4305: from pay_element_type_extra_info

4301:
4302: /*
4303: CURSOR csr_ele_code (p_ele_type_id NUMBER , p_le_org_id NUMBER ) IS
4304: select eei_information1
4305: from pay_element_type_extra_info
4306: where element_type_id = p_ele_type_id
4307: and ( eei_information2 = p_le_org_id OR eei_information2 is null )
4308: and information_type = 'NO_ELEMENT_CODES'
4309: and eei_information_category = 'NO_ELEMENT_CODES'

Line 4317: select nvl((select eei_information1 from pay_element_type_extra_info petei

4313:
4314: -- modifying the above cursor
4315:
4316: cursor csr_ele_code(p_ele_type_id NUMBER , p_leg_emp_id NUMBER ) is
4317: select nvl((select eei_information1 from pay_element_type_extra_info petei
4318: where petei.information_type='NO_ELEMENT_CODES'
4319: and element_type_id = p_ele_type_id
4320: and petei.eei_information2 = p_leg_emp_id
4321: and rownum=1),

Line 4322: (select eei_information1 from pay_element_type_extra_info petei

4318: where petei.information_type='NO_ELEMENT_CODES'
4319: and element_type_id = p_ele_type_id
4320: and petei.eei_information2 = p_leg_emp_id
4321: and rownum=1),
4322: (select eei_information1 from pay_element_type_extra_info petei
4323: where petei.information_type='NO_ELEMENT_CODES'
4324: and element_type_id = p_ele_type_id
4325: and eei_information2 is null
4326: and rownum=1)) from dual;