DBA Data[Home] [Help]

APPS.GL_OPEN_BAL_REVAL_RPT_PKG dependencies on GL_JE_HEADERS

Line 99: gl_je_headers gjh

95: -- Find the header ID of the latest revalued entry
96: SELECT MAX(gjh.je_header_id)
97: INTO ln_reval_header_id
98: FROM
99: gl_je_headers gjh
100: ,gl_je_lines gjl
101: WHERE
102: gjh.status = 'P'
103: AND gjh.actual_flag = 'A'

Line 128: FROM gl_je_headers

124: ELSE
125: -- Get the revaluation rate for the header ID and cache it
126: SELECT currency_conversion_rate
127: INTO ln_reval_conversion_rate
128: FROM gl_je_headers
129: WHERE je_header_id=ln_reval_header_id;
130: gn_rvl_convrate_cache_tbl(lc_reval_rate_cache_pk):=ln_reval_conversion_rate;
131: RETURN(ln_reval_conversion_rate);
132: END IF;