APPS.FARX_MCR dependencies on FA_LOOKUPS

Line 39: FROM fa_lookups lu_rev,

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

Line 40: fa_lookups lu_curr

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