APPS.HR_NO_VALIDATE_PKG dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 1570: FROM pay_element_type_extra_info petei

1566: ) is
1567:
1568: CURSOR csr_get_ele_code( p_ele_type_id NUMBER ) IS
1569: SELECT eei_information1, eei_information2
1570: FROM pay_element_type_extra_info petei
1571: WHERE petei.information_type='NO_ELEMENT_CODES'
1572: AND petei.element_type_id = p_ele_type_id ;
1573:
1574: CURSOR csr_get_le_details(p_le_id NUMBER) IS

Line 1584: FROM pay_element_type_extra_info etei

1580: AND hou.organization_id = p_le_id;
1581:
1582: CURSOR csr_chk_element_eit_year IS
1583: SELECT 'Y', etei.eei_information3
1584: FROM pay_element_type_extra_info etei
1585: WHERE etei.element_type_id = p_element_type_id
1586: AND etei.eei_information_category = 'NO_EOY_REPORTING_CODE_MAPPING'
1587: AND ((to_number(etei.eei_information1)
1588: between to_number(p_eei_information1) and to_number(nvl(p_eei_information2,'4712')))

Line 1593: l_overlap_code pay_element_type_extra_info.eei_information3%TYPE;

1589: OR (to_number(p_eei_information1)
1590: between to_number(etei.eei_information1) and to_number(nvl(etei.eei_information2,'4712')))) ;
1591: --
1592: l_year_status varchar2(1);
1593: l_overlap_code pay_element_type_extra_info.eei_information3%TYPE;
1594: rec_get_ele_code csr_get_ele_code%ROWTYPE;
1595: rec_get_le_details csr_get_le_details%ROWTYPE;
1596: --
1597: BEGIN

Line 1768: FROM pay_element_type_extra_info petei

1764: ) is
1765:
1766: CURSOR csr_get_element_type_id ( p_element_type_extra_info_id NUMBER )IS
1767: SELECT element_type_id
1768: FROM pay_element_type_extra_info petei
1769: WHERE petei.information_type='NO_ELEMENT_CODES'
1770: AND petei.element_type_extra_info_id = p_element_type_extra_info_id;
1771:
1772: CURSOR csr_get_ele_code_le_glob( p_ele_type_id NUMBER

Line 1775: FROM pay_element_type_extra_info petei

1771:
1772: CURSOR csr_get_ele_code_le_glob( p_ele_type_id NUMBER
1773: ,p_ele_code VARCHAR2) IS
1774: SELECT eei_information1 , eei_information2
1775: FROM pay_element_type_extra_info petei
1776: WHERE petei.information_type='NO_ELEMENT_CODES'
1777: AND petei.element_type_id = p_ele_type_id
1778: AND petei.eei_information1 = p_ele_code;
1779:

Line 1790: FROM pay_element_type_extra_info etei

1786: AND hou.organization_id = p_le_id;
1787:
1788: CURSOR csr_get_element_type IS
1789: SELECT element_type_id
1790: FROM pay_element_type_extra_info etei
1791: WHERE etei.information_type ='NO_EOY_REPORTING_CODE_MAPPING'
1792: AND etei.element_type_extra_info_id = p_element_type_extra_info_id;
1793:
1794: CURSOR csr_chk_element_eit_year(l_element_type_id NUMBER) IS

Line 1796: FROM pay_element_type_extra_info etei

1792: AND etei.element_type_extra_info_id = p_element_type_extra_info_id;
1793:
1794: CURSOR csr_chk_element_eit_year(l_element_type_id NUMBER) IS
1795: SELECT 'Y', etei.eei_information3
1796: FROM pay_element_type_extra_info etei
1797: WHERE etei.element_type_id = l_element_type_id
1798: AND etei.eei_information_category = 'NO_EOY_REPORTING_CODE_MAPPING'
1799: AND etei.element_type_extra_info_id <> p_element_type_extra_info_id
1800: AND ((to_number(etei.eei_information1)

Line 1807: l_overlap_code pay_element_type_extra_info.eei_information3%TYPE;

1803: between to_number(etei.eei_information1) and to_number(nvl(etei.eei_information2,'4712')))) ;
1804:
1805: --
1806: l_year_status varchar2(1);
1807: l_overlap_code pay_element_type_extra_info.eei_information3%TYPE;
1808: rec_get_element_type csr_get_element_type%ROWTYPE;
1809: rec_get_ele_code_le_glob csr_get_ele_code_le_glob%ROWTYPE;
1810: rec_get_element_type_id csr_get_element_type_id%ROWTYPE;
1811: rec_get_le_details csr_get_le_details%ROWTYPE;