APPS.PAY_NO_PACCR_PKG dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 130: FROM pay_element_type_extra_info etei

126: ,l_effective_date IN DATE) RETURN VARCHAR2
127: IS
128: CURSOR get_code IS
129: SELECT etei.eei_information3
130: FROM pay_element_type_extra_info etei
131: WHERE etei.element_type_id = l_element_type_id
132: AND etei.eei_information_category = 'NO_EOY_REPORTING_CODE_MAPPING'
133: AND to_number(to_char(l_effective_date,'YYYY'))
134: between to_number(etei.eei_information1) and to_number(nvl(etei.eei_information2,'4712'));

Line 136: l_ele_code pay_element_type_extra_info.eei_information3%TYPE;

132: AND etei.eei_information_category = 'NO_EOY_REPORTING_CODE_MAPPING'
133: AND to_number(to_char(l_effective_date,'YYYY'))
134: between to_number(etei.eei_information1) and to_number(nvl(etei.eei_information2,'4712'));
135: --
136: l_ele_code pay_element_type_extra_info.eei_information3%TYPE;
137: --
138: BEGIN
139: --
140: OPEN get_code;

Line 475: FROM pay_element_type_extra_info petei

471: -- Modified for bug fix 5239796
472: CURSOR csr_ele_code(p_ele_type_id NUMBER
473: ,p_leg_emp_id NUMBER) IS
474: /*SELECT eei_information1 ele_code
475: FROM pay_element_type_extra_info petei
476: WHERE information_type='NO_ELEMENT_CODES'
477: AND nvl(element_type_id,0) = p_ele_type_id
478: AND nvl(eei_information2,0) = nvl(p_leg_emp_id, 0)
479: AND rownum <=1; */

Line 480: SELECT nvl((select eei_information1 from pay_element_type_extra_info petei

476: WHERE information_type='NO_ELEMENT_CODES'
477: AND nvl(element_type_id,0) = p_ele_type_id
478: AND nvl(eei_information2,0) = nvl(p_leg_emp_id, 0)
479: AND rownum <=1; */
480: SELECT nvl((select eei_information1 from pay_element_type_extra_info petei
481: where petei.information_type='NO_ELEMENT_CODES'
482: and element_type_id = p_ele_type_id
483: and petei.eei_information2 = p_leg_emp_id
484: and rownum=1),

Line 485: (select eei_information1 from pay_element_type_extra_info petei

481: where petei.information_type='NO_ELEMENT_CODES'
482: and element_type_id = p_ele_type_id
483: and petei.eei_information2 = p_leg_emp_id
484: and rownum=1),
485: (select eei_information1 from pay_element_type_extra_info petei
486: where petei.information_type='NO_ELEMENT_CODES'
487: and element_type_id = p_ele_type_id
488: and eei_information2 is null
489: and rownum=1)) ele_code from dual;

Line 842: FROM pay_element_type_extra_info petei

838: -- Modified for bug fix 5239796
839: CURSOR csr_ele_code(p_ele_type_id NUMBER
840: ,p_leg_emp_id NUMBER) IS
841: /*SELECT eei_information1 ele_code
842: FROM pay_element_type_extra_info petei
843: WHERE information_type='NO_ELEMENT_CODES'
844: AND nvl(element_type_id,0) = p_ele_type_id
845: AND nvl(eei_information2,0) = nvl(p_leg_emp_id, 0)
846: AND rownum <=1; */

Line 847: SELECT nvl((select eei_information1 from pay_element_type_extra_info petei

843: WHERE information_type='NO_ELEMENT_CODES'
844: AND nvl(element_type_id,0) = p_ele_type_id
845: AND nvl(eei_information2,0) = nvl(p_leg_emp_id, 0)
846: AND rownum <=1; */
847: SELECT nvl((select eei_information1 from pay_element_type_extra_info petei
848: where petei.information_type='NO_ELEMENT_CODES'
849: and element_type_id = p_ele_type_id
850: and petei.eei_information2 = p_leg_emp_id
851: and rownum=1),

Line 852: (select eei_information1 from pay_element_type_extra_info petei

848: where petei.information_type='NO_ELEMENT_CODES'
849: and element_type_id = p_ele_type_id
850: and petei.eei_information2 = p_leg_emp_id
851: and rownum=1),
852: (select eei_information1 from pay_element_type_extra_info petei
853: where petei.information_type='NO_ELEMENT_CODES'
854: and element_type_id = p_ele_type_id
855: and eei_information2 is null
856: and rownum=1)) ele_code from dual;