APPS.GHR_WF_WGI_PKG dependencies on HR_LOOKUPS

Line 68: l_office_symbol_name hr_lookups.meaning%TYPE;

64: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
65: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
66: l_groupbox_name ghr_groupboxes.name%TYPE;
67: l_groupbox_desc ghr_groupboxes.description%TYPE;
68: l_office_symbol_name hr_lookups.meaning%TYPE;
69: l_wgi_due_date date;
70: l_rating varchar2(30);
71: l_multi_error_flag boolean;
72: l_valid_user boolean;

Line 810: from hr_lookups fcl

806: --
807: cursor csr_lkp_code( l_type in varchar2,
808: l_code in varchar2) is
809: select fcl.meaning
810: from hr_lookups fcl
811: where fcl.lookup_type = l_type
812: and fcl.lookup_code = l_code
813: and fcl.enabled_flag = 'Y'
814: and nvl(p_effective_date,trunc(sysdate))

Line 2005: l_office_symbol_name hr_lookups.meaning%TYPE;

2001: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
2002: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
2003: l_groupbox_name ghr_groupboxes.name%TYPE;
2004: l_groupbox_desc ghr_groupboxes.description%TYPE;
2005: l_office_symbol_name hr_lookups.meaning%TYPE;
2006: l_wgi_due_date date;
2007: l_rating varchar2(30);
2008: l_multi_error_flag boolean;
2009: l_valid_user boolean;