eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CN_EXT dependencies on HR_ORGANIZATION_INFORMATION

Line 483: FROM hr_organization_information

479: CURSOR csr_start_month
480: IS
481: --
482: SELECT org_information11 -- Switch Period Month
483: FROM hr_organization_information
484: WHERE organization_id = p_business_group_id
485: AND org_information_context = 'PER_CONT_AREA_CONT_BASE_CN'
486: AND org_information1 = p_contribution_area
487: AND org_information2 = p_phf_si_type

Line 1822: -- to hr_organization_information --

1818: -- 1.1 06-Jul-2004 sshankar Modified code as required to support --
1819: -- Enterprise Annuity. (Bug 3593118) --
1820: -- 1.2 15-Sep-2004 snekkala Modified code to fetch hukuo type --
1821: -- 1.3 05-Oct-2004 snekkala Modified the datatype from VARCHAR2(30) --
1822: -- to hr_organization_information --
1823: -- org_information5%TYPE
1824: -- 1.4 14-Mar-2008 dduvvuri Modified call to get_phf_si_rates (6828199) --
1825: ----------------------------------------------------------------------------
1826: FUNCTION get_employer_info(p_assignment_id IN NUMBER

Line 1846: -- Bug 3904374 Changes start. Modified the datatype from VARCHAR2(30) to hr_organization_information.org_information5%TYPE

1842: /* Changes for bug 6828199 end */
1843: l_ee_rounding_method VARCHAR2(30);
1844: l_er_rounding_method VARCHAR2(30);
1845: --
1846: -- Bug 3904374 Changes start. Modified the datatype from VARCHAR2(30) to hr_organization_information.org_information5%TYPE
1847: --
1848: l_phf_reg_num hr_organization_information.org_information5%TYPE;
1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;

Line 1848: l_phf_reg_num hr_organization_information.org_information5%TYPE;

1844: l_er_rounding_method VARCHAR2(30);
1845: --
1846: -- Bug 3904374 Changes start. Modified the datatype from VARCHAR2(30) to hr_organization_information.org_information5%TYPE
1847: --
1848: l_phf_reg_num hr_organization_information.org_information5%TYPE;
1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;

Line 1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;

1845: --
1846: -- Bug 3904374 Changes start. Modified the datatype from VARCHAR2(30) to hr_organization_information.org_information5%TYPE
1847: --
1848: l_phf_reg_num hr_organization_information.org_information5%TYPE;
1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;
1853: l_medical_reg_num hr_organization_information.org_information5%TYPE;

Line 1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;

1846: -- Bug 3904374 Changes start. Modified the datatype from VARCHAR2(30) to hr_organization_information.org_information5%TYPE
1847: --
1848: l_phf_reg_num hr_organization_information.org_information5%TYPE;
1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;
1853: l_medical_reg_num hr_organization_information.org_information5%TYPE;
1854: l_ea_reg_num hr_organization_information.org_information5%TYPE; -- Bug 3593118. Enterprise Annuity Employer Reg Num

Line 1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;

1847: --
1848: l_phf_reg_num hr_organization_information.org_information5%TYPE;
1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;
1853: l_medical_reg_num hr_organization_information.org_information5%TYPE;
1854: l_ea_reg_num hr_organization_information.org_information5%TYPE; -- Bug 3593118. Enterprise Annuity Employer Reg Num
1855: --

Line 1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;

1848: l_phf_reg_num hr_organization_information.org_information5%TYPE;
1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;
1853: l_medical_reg_num hr_organization_information.org_information5%TYPE;
1854: l_ea_reg_num hr_organization_information.org_information5%TYPE; -- Bug 3593118. Enterprise Annuity Employer Reg Num
1855: --
1856: -- Bug 3904374 Changes end

Line 1853: l_medical_reg_num hr_organization_information.org_information5%TYPE;

1849: l_pension_reg_num hr_organization_information.org_information5%TYPE;
1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;
1853: l_medical_reg_num hr_organization_information.org_information5%TYPE;
1854: l_ea_reg_num hr_organization_information.org_information5%TYPE; -- Bug 3593118. Enterprise Annuity Employer Reg Num
1855: --
1856: -- Bug 3904374 Changes end
1857: --

Line 1854: l_ea_reg_num hr_organization_information.org_information5%TYPE; -- Bug 3593118. Enterprise Annuity Employer Reg Num

1850: l_injury_reg_num hr_organization_information.org_information5%TYPE;
1851: l_maternity_reg_num hr_organization_information.org_information5%TYPE;
1852: l_unemp_reg_num hr_organization_information.org_information5%TYPE;
1853: l_medical_reg_num hr_organization_information.org_information5%TYPE;
1854: l_ea_reg_num hr_organization_information.org_information5%TYPE; -- Bug 3593118. Enterprise Annuity Employer Reg Num
1855: --
1856: -- Bug 3904374 Changes end
1857: --
1858:

Line 1886: FROM hr_organization_information hoi

1882: --
1883: CURSOR csr_org_currency(p_business_group_id IN NUMBER)
1884: IS
1885: SELECT hoi.org_information10
1886: FROM hr_organization_information hoi
1887: WHERE hoi.organization_id = p_business_group_id
1888: AND REPLACE(ltrim(rtrim(hoi.org_information_context)),' ','_') = 'Business_Group_Information';
1889: --
1890:

Line 1896: FROM hr_organization_information hoi

1892: --
1893: CURSOR csr_ent_org_category(p_legal_employer_id IN NUMBER)
1894: IS
1895: SELECT hr_general.decode_lookup('CN_ENTRP_CATEGORY',hoi.org_information8)
1896: FROM hr_organization_information hoi
1897: WHERE hoi.organization_id = p_legal_employer_id
1898: AND REPLACE(ltrim(rtrim(hoi.org_information_context)),' ','_') = 'PER_CORPORATE_INFO_CN';
1899: --
1900:

Line 1906: FROM hr_organization_information hoi

1902: --
1903: CURSOR csr_ent_org_code(p_legal_employer_id IN NUMBER)
1904: IS
1905: SELECT hoi.org_information7
1906: FROM hr_organization_information hoi
1907: WHERE hoi.organization_id = p_legal_employer_id
1908: AND REPLACE(ltrim(rtrim(hoi.org_information_context)),' ','_') = 'PER_CORPORATE_INFO_CN';
1909: --
1910:

Line 1922: FROM hr_organization_information hoi

1918: ,hoi.org_information17 -- Maternity
1919: ,hoi.org_information19 -- Unemployment
1920: ,hoi.org_information7 -- Medical
1921: ,hoi.org_information3 -- Enterprise Annuity. (Bug 3593118)
1922: FROM hr_organization_information hoi
1923: WHERE hoi.organization_id = p_legal_employer_id
1924: AND REPLACE(ltrim(rtrim(hoi.org_information_context)),' ','_') = 'PER_EMPLOYER_INFO_CN';
1925: --
1926: