DBA Data[Home] [Help]

APPS.HR_CLE_BUS dependencies on HR_LOOKUPS

Line 1813: from hr_lookups

1809: --
1810: CURSOR c1_month(p_month IN hr_de_soc_ins_contr_lvls_f.month1%type) IS
1811: Select 1 From(
1812: select lookup_code code
1813: from hr_lookups
1814: where lookup_type LIKE 'MONTH_CODE')
1815: WHERE p_month IN (code);
1816: --
1817: l_proc VARCHAR2(72) := g_package || 'chk_month1';

Line 1900: from hr_lookups

1896: --
1897: CURSOR c1_month(p_month IN hr_de_soc_ins_contr_lvls_f.month2%type) IS
1898: Select 1 From(
1899: select lookup_code code
1900: from hr_lookups
1901: where lookup_type LIKE 'MONTH_CODE')
1902: WHERE p_month IN (code);
1903: --
1904: l_proc VARCHAR2(72) := g_package || 'chk_month2';