APPS.BEN_EXT_WRITE dependencies on BEN_EXT_RSLT_DTL

Line 13: This process reads records from the ben_ext_rslt_dtl table and writes them

9: +==============================================================================+
10: Name:
11: Extract Write Process.
12: Purpose:
13: This process reads records from the ben_ext_rslt_dtl table and writes them
14: to a flat output file.
15: History:
16: Date Who Version What?
17: ---- --- ------- -----

Line 4492: from ben_ext_rslt_dtl xrd,

4488: xrd.val_298,
4489: xrd.val_299,
4490: xrd.val_300,
4491: xrf.seq_num
4492: from ben_ext_rslt_dtl xrd,
4493: ben_ext_rslt xrs,
4494: ben_ext_dfn xdf,
4495: ben_ext_rcd_in_file xrf
4496: where xrd.ext_rslt_id = p_ext_rslt_id

Line 4513: from ben_ext_rslt_dtl xrd

4509: xrf.seq_num ; -- this is addedd ther are many time header may not sorted in order
4510: --
4511: cursor c_xrd1 is --this cursor is for validation only.
4512: select 'x'
4513: from ben_ext_rslt_dtl xrd
4514: where xrd.ext_rslt_id = p_ext_rslt_id;
4515: --
4516: -- BUG - 3954449 ADDED UNION CLAUSE
4517: --