APPS.FARX_MCP dependencies on FA_LOOKUPS

Line 41: FROM fa_lookups lu_prev,

37: -- cursor to fetch the current and preview status
38: CURSOR get_status IS
39: SELECT lu_prev.meaning,
40: lu_curr.meaning
41: FROM fa_lookups lu_prev,
42: fa_lookups lu_curr
43: WHERE lu_prev.lookup_type = 'MASS_TRX_STATUS' AND
44: lu_prev.lookup_code = 'PREVIEW'
45: AND lu_curr.lookup_type = 'MASS_TRX_STATUS' AND

Line 42: fa_lookups lu_curr

38: CURSOR get_status IS
39: SELECT lu_prev.meaning,
40: lu_curr.meaning
41: FROM fa_lookups lu_prev,
42: fa_lookups lu_curr
43: WHERE lu_prev.lookup_type = 'MASS_TRX_STATUS' AND
44: lu_prev.lookup_code = 'PREVIEW'
45: AND lu_curr.lookup_type = 'MASS_TRX_STATUS' AND
46: lu_curr.lookup_code = mc_rec.status;