DBA Data[Home] [Help]

APPS.FARX_RP dependencies on FA_LOOKUPS

Line 39: FROM fa_lookups lu_prev,

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

Line 40: fa_lookups lu_curr

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