APPS.PAY_FR_DB_PAY_SETUP dependencies on HR_LOOKUPS

Line 113: from hr_lookups hl

109: --
110: -- Get the post termination rule
111: select hl.lookup_code
112: into v_post_term_rule
113: from hr_lookups hl
114: where hl.lookup_type = 'TERMINATION_RULE'
115: and (upper(hl.meaning) = upper(p_post_termination_rule)
116: or
117: hl.lookup_code =

Line 500: from hr_lookups

496: end if;
497: --
498: select lookup_code
499: into v_warning_or_error
500: from hr_lookups
501: where lookup_type = 'WARNING_ERROR'
502: and upper(meaning) = upper(p_warning_or_error);
503: --
504: elsif p_warn_or_error_code is not null then

Line 507: from hr_lookups

503: --
504: elsif p_warn_or_error_code is not null then
505: select lookup_code
506: into v_warning_or_error
507: from hr_lookups
508: where lookup_type = 'WARNING_ERROR'
509: and lookup_code = p_warn_or_error_code;
510: end if;
511: --

Line 525: from hr_lookups

521: hr_utility.set_location('pay_db_pay_setup.create_input_value',8);
522: end if;
523: select lookup_code
524: into v_uom
525: from hr_lookups
526: where lookup_type = 'UNITS'
527: and upper(meaning) = upper(p_uom);
528: else
529: begin

Line 532: from hr_lookups

528: else
529: begin
530: select lookup_code
531: into v_uom
532: from hr_lookups
533: where lookup_code = p_uom_code
534: and lookup_type = 'UNITS';
535: exception
536: when no_data_found then

Line 1637: from hr_lookups

1633: -- Get the uom code
1634: if p_uom_code is null then
1635: select lookup_code,decode(lookup_code,'M',v_currency_code,NULL)
1636: into v_uom,v_money
1637: from hr_lookups
1638: where lookup_type = 'UNITS'
1639: and upper(meaning) = upper(p_uom);
1640: else
1641: v_uom := p_uom_code;

Line 1966: from hr_lookups

1962: --
1963: -- Convert Add or Subtract to a number
1964: select fnd_number.canonical_to_number(lookup_code)
1965: into v_scale
1966: from hr_lookups
1967: where lookup_type = 'ADD_SUBTRACT'
1968: and upper(meaning) = upper(p_scale);
1969: --
1970: if g_debug then