APPS.SSP_SMP_PKG dependencies on HR_LOOKUPS

Line 723: l_leaving_reason hr_lookups.meaning%type;

719: between ser.date_start and nvl(ser.actual_termination_date, hr_general.end_of_time);
720: --
721: l_proc varchar2(72) := g_package||'check_employment_qw';
722: l_termination_date per_periods_of_service.actual_termination_date%type;
723: l_leaving_reason hr_lookups.meaning%type;
724: --
725: -- Local Function
726: function get_leaving_reason(p_leaving_reason in varchar2)
727: return varchar2 is

Line 730: from hr_lookups

726: function get_leaving_reason(p_leaving_reason in varchar2)
727: return varchar2 is
728: cursor csr_leaving_reason is
729: select upper(meaning)
730: from hr_lookups
731: where lookup_type = 'LEAV_REAS'
732: and lookup_code = p_leaving_reason
733: and enabled_flag = 'Y' ;
734: --

Line 735: l_leaving_reason hr_lookups.meaning%type;

731: where lookup_type = 'LEAV_REAS'
732: and lookup_code = p_leaving_reason
733: and enabled_flag = 'Y' ;
734: --
735: l_leaving_reason hr_lookups.meaning%type;
736: begin
737: open csr_leaving_reason;
738: fetch csr_leaving_reason into l_leaving_reason;
739: close csr_leaving_reason;

Line 1992: from hr_lookups

1988: --
1989: cursor csr_rate_meaning (p_rate_band varchar2) is
1990: --
1991: select meaning
1992: from hr_lookups
1993: where lookup_type = 'SMP_RATES'
1994: and lookup_code = p_rate_band;
1995: --
1996: begin