eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_WGI_PKG dependencies on HR_LOOKUPS

Line 2244: p_lookup_type IN hr_lookups.lookup_type%TYPE,

2240:
2241: --
2242: --
2243: FUNCTION get_fnd_lookup_meaning (
2244: p_lookup_type IN hr_lookups.lookup_type%TYPE,
2245: p_lookup_code IN hr_lookups.lookup_code%TYPE,
2246: p_effective_date IN DATE DEFAULT SYSDATE
2247: )
2248: RETURN hr_lookups.meaning%TYPE

Line 2245: p_lookup_code IN hr_lookups.lookup_code%TYPE,

2241: --
2242: --
2243: FUNCTION get_fnd_lookup_meaning (
2244: p_lookup_type IN hr_lookups.lookup_type%TYPE,
2245: p_lookup_code IN hr_lookups.lookup_code%TYPE,
2246: p_effective_date IN DATE DEFAULT SYSDATE
2247: )
2248: RETURN hr_lookups.meaning%TYPE
2249: IS

Line 2248: RETURN hr_lookups.meaning%TYPE

2244: p_lookup_type IN hr_lookups.lookup_type%TYPE,
2245: p_lookup_code IN hr_lookups.lookup_code%TYPE,
2246: p_effective_date IN DATE DEFAULT SYSDATE
2247: )
2248: RETURN hr_lookups.meaning%TYPE
2249: IS
2250: --
2251: -- Local variables
2252: -- This function returns description and not meaning as is used to fetch only type GHR_US_LEGAL_AUTHORITY

Line 2255: l_lookup_type hr_lookups.lookup_type%TYPE;

2251: -- Local variables
2252: -- This function returns description and not meaning as is used to fetch only type GHR_US_LEGAL_AUTHORITY
2253: --
2254: l_effective_date ghr_pa_requests.effective_date%TYPE;
2255: l_lookup_type hr_lookups.lookup_type%TYPE;
2256: l_lookup_code hr_lookups.lookup_code%TYPE;
2257: l_meaning hr_lookups.meaning%TYPE;
2258:
2259: --

Line 2256: l_lookup_code hr_lookups.lookup_code%TYPE;

2252: -- This function returns description and not meaning as is used to fetch only type GHR_US_LEGAL_AUTHORITY
2253: --
2254: l_effective_date ghr_pa_requests.effective_date%TYPE;
2255: l_lookup_type hr_lookups.lookup_type%TYPE;
2256: l_lookup_code hr_lookups.lookup_code%TYPE;
2257: l_meaning hr_lookups.meaning%TYPE;
2258:
2259: --
2260: --

Line 2257: l_meaning hr_lookups.meaning%TYPE;

2253: --
2254: l_effective_date ghr_pa_requests.effective_date%TYPE;
2255: l_lookup_type hr_lookups.lookup_type%TYPE;
2256: l_lookup_code hr_lookups.lookup_code%TYPE;
2257: l_meaning hr_lookups.meaning%TYPE;
2258:
2259: --
2260: --
2261: CURSOR csr_lkp_code

Line 2264: FROM hr_lookups fcl

2260: --
2261: CURSOR csr_lkp_code
2262: IS
2263: SELECT fcl.description
2264: FROM hr_lookups fcl
2265: WHERE fcl.lookup_type = l_lookup_type
2266: AND fcl.lookup_code = l_lookup_code
2267: AND fcl.enabled_flag = 'Y'
2268: AND NVL (l_effective_date, TRUNC (SYSDATE))