APPS.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on HR_LOOKUPS

Line 59: from hr_lookups hrl

55: --
56: cursor c_tax_country_code_cursor(p_country_code in varchar2,
57: p_effective_date in date) is
58: select count(*)
59: from hr_lookups hrl
60: where hrl.lookup_type = 'PER_US_COUNTRY_CODE'
61: and hrl.enabled_flag = 'Y'
62: and nvl(start_date_active, p_effective_date) <= to_date(('12/31/' ||
63: to_char(p_effective_date, 'YYYY')), 'MM/DD/YYYY')

Line 586: if hr_api.not_exists_in_hr_lookups

582: -- p_out_mesg := p_out_mesg || l_temp_prefix || 'Cycle Date is NULL';
583: -- END IF;
584: --END IF;
585:
586: if hr_api.not_exists_in_hr_lookups
587: (p_lookup_type => 'PER_US_INCOME_TYPES'
588: ,p_lookup_code => p_in_data_rec.income_code ||
589: p_in_data_rec.income_code_sub_type
590: ,p_effective_date => p_effective_date) then

Line 1834: Bug 3780751 Fix - Changed the FND_COMMON_LOOKUP reference to hr_lookups

1830: the respective country code, then the t_people_tab(i).dependents will
1831: be populated by value present in 'dependent children in country'.
1832:
1833:
1834: Bug 3780751 Fix - Changed the FND_COMMON_LOOKUP reference to hr_lookups
1835: by tmehra 23-dec-2004.
1836: ****/
1837:
1838: cursor c_lookup_values_cursor(p_effective_date in date ,

Line 1842: from hr_lookups

1838: cursor c_lookup_values_cursor(p_effective_date in date ,
1839: p_lookup_type in varchar2 ,
1840: p_country_code in varchar2 ) is
1841: select COUNT(*) count
1842: from hr_lookups
1843: where lookup_type = p_lookup_type
1844: and enabled_flag = 'Y'
1845: and NVL(end_date_active, p_effective_date) >= p_effective_date
1846: and lookup_code = p_country_code;

Line 1908: from hr_lookups hrl

1904:
1905: cursor c_country_code_xlat_cursor(p_country_code in varchar2 ,
1906: p_effective_date in date ) is
1907: select hrl.meaning
1908: from hr_lookups hrl
1909: where hrl.lookup_type = 'PQP_US_COUNTRY_TRANSLATE'
1910: and hrl.enabled_flag = 'Y'
1911: and NVL(start_date_active, p_effective_date) <= TO_DATE(('12/31/' ||
1912: TO_CHAR(p_effective_date, 'YYYY')), 'MM/DD/YYYY')

Line 4937: from hr_lookups

4933: --
4934: cursor c_winstar_oracle_pay_period(p_lookup_code in varchar2) is
4935: select lookup_code,
4936: meaning
4937: from hr_lookups
4938: where lookup_type = 'PQP_US_WIND_ORA_PERIODS'
4939: and lookup_code = p_lookup_code ;
4940: --
4941: -- The following cursor selects OVN and PK from