APPS.BEN_EXT_WRITE dependencies on BEN_EXT_RSLT

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 4150: l_output_name ben_ext_rslt.output_name%type ;

4146: ) is
4147: --
4148: --
4149: file_handle utl_file.file_type;
4150: l_output_name ben_ext_rslt.output_name%type ;
4151: l_drctry_name ben_ext_rslt.drctry_name%type ;
4152: l_ext_stat_cd ben_ext_rslt.ext_stat_cd%type ;
4153: -- hnarayan - bug fix 2066883 - changed size of l_val from 2000 to 32000
4154: -- l_val varchar2(2000);

Line 4151: l_drctry_name ben_ext_rslt.drctry_name%type ;

4147: --
4148: --
4149: file_handle utl_file.file_type;
4150: l_output_name ben_ext_rslt.output_name%type ;
4151: l_drctry_name ben_ext_rslt.drctry_name%type ;
4152: l_ext_stat_cd ben_ext_rslt.ext_stat_cd%type ;
4153: -- hnarayan - bug fix 2066883 - changed size of l_val from 2000 to 32000
4154: -- l_val varchar2(2000);
4155: l_val varchar2(32700);

Line 4152: l_ext_stat_cd ben_ext_rslt.ext_stat_cd%type ;

4148: --
4149: file_handle utl_file.file_type;
4150: l_output_name ben_ext_rslt.output_name%type ;
4151: l_drctry_name ben_ext_rslt.drctry_name%type ;
4152: l_ext_stat_cd ben_ext_rslt.ext_stat_cd%type ;
4153: -- hnarayan - bug fix 2066883 - changed size of l_val from 2000 to 32000
4154: -- l_val varchar2(2000);
4155: l_val varchar2(32700);
4156: -- RCHASE wwbug 1412809 fix - added l_val_all

Line 4183: from ben_ext_rslt xrs,

4179: xdf.spcl_hndl_flag,
4180: nvl(xrs.output_type, xdf.output_type ) output_type ,
4181: xdf.cm_display_flag ,
4182: nvl(xrs.xdo_template_id, xdf.xdo_template_id) xdo_template_id
4183: from ben_ext_rslt xrs,
4184: ben_ext_dfn xdf
4185: where xrs.ext_rslt_id = p_ext_rslt_id
4186: and xdf.ext_dfn_id = xrs.ext_dfn_id;
4187: --

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 4493: ben_ext_rslt xrs,

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
4497: and xrd.ext_rslt_id = xrs.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: --