APPS.HR_NO_VALIDATE_PKG dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 1574: FROM pay_element_type_extra_info petei

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

Line 1588: FROM pay_element_type_extra_info etei

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

Line 1597: l_overlap_code pay_element_type_extra_info.eei_information3%TYPE;

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

Line 1772: FROM pay_element_type_extra_info petei

1768: ) is
1769:
1770: CURSOR csr_get_element_type_id ( p_element_type_extra_info_id NUMBER )IS
1771: SELECT element_type_id
1772: FROM pay_element_type_extra_info petei
1773: WHERE petei.information_type='NO_ELEMENT_CODES'
1774: AND petei.element_type_extra_info_id = p_element_type_extra_info_id;
1775:
1776: CURSOR csr_get_ele_code_le_glob( p_ele_type_id NUMBER

Line 1779: FROM pay_element_type_extra_info petei

1775:
1776: CURSOR csr_get_ele_code_le_glob( p_ele_type_id NUMBER
1777: ,p_ele_code VARCHAR2) IS
1778: SELECT eei_information1 , eei_information2
1779: FROM pay_element_type_extra_info petei
1780: WHERE petei.information_type='NO_ELEMENT_CODES'
1781: AND petei.element_type_id = p_ele_type_id
1782: AND petei.eei_information1 = p_ele_code;
1783:

Line 1794: FROM pay_element_type_extra_info etei

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

Line 1800: FROM pay_element_type_extra_info etei

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

Line 1811: l_overlap_code pay_element_type_extra_info.eei_information3%TYPE;

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