APPS.SSP_SMP_PKG dependencies on HR_LOOKUPS

Line 716: l_leaving_reason hr_lookups.meaning%type;

712: between ser.date_start and nvl(ser.actual_termination_date, hr_general.end_of_time);
713: --
714: l_proc varchar2(72) := g_package||'check_employment_qw';
715: l_termination_date per_periods_of_service.actual_termination_date%type;
716: l_leaving_reason hr_lookups.meaning%type;
717: --
718: -- Local Function
719: function get_leaving_reason(p_leaving_reason in varchar2)
720: return varchar2 is

Line 723: from hr_lookups

719: function get_leaving_reason(p_leaving_reason in varchar2)
720: return varchar2 is
721: cursor csr_leaving_reason is
722: select upper(meaning)
723: from hr_lookups
724: where lookup_type = 'LEAV_REAS'
725: and lookup_code = p_leaving_reason
726: and enabled_flag = 'Y' ;
727: --

Line 728: l_leaving_reason hr_lookups.meaning%type;

724: where lookup_type = 'LEAV_REAS'
725: and lookup_code = p_leaving_reason
726: and enabled_flag = 'Y' ;
727: --
728: l_leaving_reason hr_lookups.meaning%type;
729: begin
730: open csr_leaving_reason;
731: fetch csr_leaving_reason into l_leaving_reason;
732: close csr_leaving_reason;

Line 1913: from hr_lookups

1909: --
1910: cursor csr_rate_meaning (p_rate_band varchar2) is
1911: --
1912: select meaning
1913: from hr_lookups
1914: where lookup_type = 'SMP_RATES'
1915: and lookup_code = p_rate_band;
1916: --
1917: begin