APPS.FARX_RR dependencies on FA_LOOKUPS

Line 38: FROM fa_lookups lu_rev,

34: -- cursor to fetch the current and review status
35: CURSOR get_status IS
36: SELECT lu_rev.meaning,
37: lu_curr.meaning
38: FROM fa_lookups lu_rev,
39: fa_lookups lu_curr
40: WHERE lu_rev.lookup_type = 'MASS_TRX_STATUS' AND
41: lu_rev.lookup_code = 'COMPLETED'
42: AND lu_curr.lookup_type = 'MASS_TRX_STATUS' AND

Line 39: fa_lookups lu_curr

35: CURSOR get_status IS
36: SELECT lu_rev.meaning,
37: lu_curr.meaning
38: FROM fa_lookups lu_rev,
39: fa_lookups lu_curr
40: WHERE lu_rev.lookup_type = 'MASS_TRX_STATUS' AND
41: lu_rev.lookup_code = 'COMPLETED'
42: AND lu_curr.lookup_type = 'MASS_TRX_STATUS' AND
43: lu_curr.lookup_code = mr_rec.status;