APPS.HRI_OPL_SPRTN_RSNS dependencies on STANDARD

Line 57: FROM hr_standard_lookups hrl,

53: --
54: CURSOR leaving_reasons_csr IS
55: SELECT hrl.lookup_code lookup_code,
56: DECODE(spr.reason, null, 'N', 'Y') exists_flag
57: FROM hr_standard_lookups hrl,
58: hri_inv_sprtn_rsns spr
59: WHERE hrl.lookup_code = spr.reason (+)
60: AND hrl.lookup_type = 'LEAV_REAS'
61: UNION ALL

Line 205: FROM hr_standard_lookups

201: , l_user
202: , l_user
203: , l_user
204: , l_sysdate
205: FROM hr_standard_lookups
206: WHERE lookup_type = 'LEAV_REAS'
207: UNION ALL
208: SELECT
209: 'NA_EDW' lookup_code