DBA Data[Home] [Help]

APPS.FARX_RP dependencies on FA_LOOKUPS

Line 37: FROM fa_lookups lu_prev,

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

Line 38: fa_lookups lu_curr

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