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 504: from hr_lookups

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

Line 511: from hr_lookups

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

Line 529: from hr_lookups

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

Line 536: from hr_lookups

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

Line 1662: from hr_lookups

1658: -- Get the uom code
1659: if p_uom_code is null then
1660: select lookup_code,decode(lookup_code,'M',v_currency_code,NULL)
1661: into v_uom,v_money
1662: from hr_lookups
1663: where lookup_type = 'UNITS'
1664: and upper(meaning) = upper(p_uom);
1665: else
1666: v_uom := p_uom_code;

Line 1990: from hr_lookups

1986: --
1987: -- Convert Add or Subtract to a number
1988: select fnd_number.canonical_to_number(lookup_code)
1989: into v_scale
1990: from hr_lookups
1991: where lookup_type = 'ADD_SUBTRACT'
1992: and upper(meaning) = upper(p_scale);
1993: --
1994: if g_debug then