APPS.PAY_DB_PAY_SETUP dependencies on HR_LOOKUPS

Line 114: from hr_lookups hl

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

Line 502: from hr_lookups

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

Line 509: from hr_lookups

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

Line 527: from hr_lookups

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

Line 534: from hr_lookups

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

Line 1639: from hr_lookups

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

Line 1967: from hr_lookups

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