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 2248: p_lookup_type IN hr_lookups.lookup_type%TYPE,

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

Line 2249: p_lookup_code IN hr_lookups.lookup_code%TYPE,

2245: --
2246: --
2247: FUNCTION get_fnd_lookup_meaning (
2248: p_lookup_type IN hr_lookups.lookup_type%TYPE,
2249: p_lookup_code IN hr_lookups.lookup_code%TYPE,
2250: p_effective_date IN DATE DEFAULT SYSDATE
2251: )
2252: RETURN hr_lookups.meaning%TYPE
2253: IS

Line 2252: RETURN hr_lookups.meaning%TYPE

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

Line 2259: l_lookup_type hr_lookups.lookup_type%TYPE;

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

Line 2260: l_lookup_code hr_lookups.lookup_code%TYPE;

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

Line 2261: l_meaning hr_lookups.meaning%TYPE;

2257: --
2258: l_effective_date ghr_pa_requests.effective_date%TYPE;
2259: l_lookup_type hr_lookups.lookup_type%TYPE;
2260: l_lookup_code hr_lookups.lookup_code%TYPE;
2261: l_meaning hr_lookups.meaning%TYPE;
2262:
2263: --
2264: --
2265: CURSOR csr_lkp_code

Line 2268: FROM hr_lookups fcl

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