APPS.PAY_ISB_BUS dependencies on HR_LOOKUPS

Line 53: from hr_lookups

49: -- ----------------------------------------------------------------------------
50: procedure chk_calculation_option(p_calculation_option in pay_ie_social_benefits_f.calculation_option%type) is
51: cursor c_calculation_option is
52: select 1
53: from hr_lookups
54: where lookup_type = 'IE_CALC_OPTION'
55: and lookup_code = p_calculation_option
56: and enabled_flag = 'Y';
57: l_calculation_option_count number;

Line 80: from hr_lookups

76: -- ----------------------------------------------------------------------------
77: procedure chk_benefit_type(p_benefit_type in pay_ie_social_benefits_f.benefit_type%type) is
78: cursor c_benefit_type is
79: select 1
80: from hr_lookups
81: where lookup_type = 'IE_BENEFIT_TYPE'
82: and lookup_code = p_benefit_type
83: and enabled_flag = 'Y';
84: l_benefit_type_count number;