APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 3021: from pay_element_type_extra_info

3017:
3018: /*
3019: CURSOR csr_ele_code (p_ele_type_id NUMBER , p_le_org_id NUMBER ) IS
3020: select eei_information1
3021: from pay_element_type_extra_info
3022: where element_type_id = p_ele_type_id
3023: and ( eei_information2 = p_le_org_id OR eei_information2 is null )
3024: and information_type = 'NO_ELEMENT_CODES'
3025: and eei_information_category = 'NO_ELEMENT_CODES'

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

3029:
3030: -- modifying the above cursor
3031:
3032: cursor csr_ele_code(p_ele_type_id NUMBER , p_leg_emp_id NUMBER ) is
3033: select nvl((select eei_information1 from pay_element_type_extra_info petei
3034: where petei.information_type='NO_ELEMENT_CODES'
3035: and element_type_id = p_ele_type_id
3036: and petei.eei_information2 = p_leg_emp_id
3037: and rownum=1),

Line 3038: (select eei_information1 from pay_element_type_extra_info petei

3034: where petei.information_type='NO_ELEMENT_CODES'
3035: and element_type_id = p_ele_type_id
3036: and petei.eei_information2 = p_leg_emp_id
3037: and rownum=1),
3038: (select eei_information1 from pay_element_type_extra_info petei
3039: where petei.information_type='NO_ELEMENT_CODES'
3040: and element_type_id = p_ele_type_id
3041: and eei_information2 is null
3042: and rownum=1)) from dual;

Line 4294: from pay_element_type_extra_info

4290:
4291: /*
4292: CURSOR csr_ele_code (p_ele_type_id NUMBER , p_le_org_id NUMBER ) IS
4293: select eei_information1
4294: from pay_element_type_extra_info
4295: where element_type_id = p_ele_type_id
4296: and ( eei_information2 = p_le_org_id OR eei_information2 is null )
4297: and information_type = 'NO_ELEMENT_CODES'
4298: and eei_information_category = 'NO_ELEMENT_CODES'

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

4302:
4303: -- modifying the above cursor
4304:
4305: cursor csr_ele_code(p_ele_type_id NUMBER , p_leg_emp_id NUMBER ) is
4306: select nvl((select eei_information1 from pay_element_type_extra_info petei
4307: where petei.information_type='NO_ELEMENT_CODES'
4308: and element_type_id = p_ele_type_id
4309: and petei.eei_information2 = p_leg_emp_id
4310: and rownum=1),

Line 4311: (select eei_information1 from pay_element_type_extra_info petei

4307: where petei.information_type='NO_ELEMENT_CODES'
4308: and element_type_id = p_ele_type_id
4309: and petei.eei_information2 = p_leg_emp_id
4310: and rownum=1),
4311: (select eei_information1 from pay_element_type_extra_info petei
4312: where petei.information_type='NO_ELEMENT_CODES'
4313: and element_type_id = p_ele_type_id
4314: and eei_information2 is null
4315: and rownum=1)) from dual;