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 1830: Bug 3780751 Fix - Changed the FND_COMMON_LOOKUP reference to hr_lookups

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

Line 1838: from hr_lookups

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

Line 1904: from hr_lookups hrl

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

Line 4922: from hr_lookups

4918: --
4919: cursor c_winstar_oracle_pay_period(p_lookup_code in varchar2) is
4920: select lookup_code,
4921: meaning
4922: from hr_lookups
4923: where lookup_type = 'PQP_US_WIND_ORA_PERIODS'
4924: and lookup_code = p_lookup_code ;
4925: --
4926: -- The following cursor selects OVN and PK from