APPS.BEN_EXT_XML_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 XML Write Process.
12: Purpose:
13: This process reads records from the ben_ext_rslt_dtl table and writes them
14: to a xml output file.
15: History:
16: Date Who Version What?
17: ---- --- ------- -----

Line 61: g_prev_grop_val ben_ext_rslt_dtl.group_val_01%type ;

57: g_rcd_tag_tbl BEN_EXT_XML_WRITE.g_table ;
58: g_elmt_tag_tbl BEN_EXT_XML_WRITE.g_table ;
59: g_low_lvl_tbl BEN_EXT_XML_WRITE.g_table ;
60: g_iana_char_set varchar2(500) ;
61: g_prev_grop_val ben_ext_rslt_dtl.group_val_01%type ;
62: --
63: -----------------------------------------------------------------------------
64:
65:

Line 1496: from ben_ext_rslt_dtl xrd,

1492: xrd.val_299,
1493: xrd.val_300,
1494: xrf.seq_num,
1495: xrd.group_val_01
1496: from ben_ext_rslt_dtl xrd,
1497: ben_ext_rslt xrs,
1498: ben_ext_dfn xdf,
1499: ben_ext_rcd_in_file xrf
1500: where xrd.ext_rslt_id = p_ext_rslt_id

Line 1581: l_elm_val ben_ext_rslt_dtl.val_01%type ;

1577: l_elm_typ_cd ben_ext_data_elmt.data_elmt_typ_cd%type ;
1578: l_elm_max_length ben_ext_data_elmt.max_length_num%type ;
1579: l_elm_frmt_mask ben_ext_data_elmt.frmt_mask_cd%type ;
1580: l_elm_just_cd ben_ext_data_elmt.just_cd%type ;
1581: l_elm_val ben_ext_rslt_dtl.val_01%type ;
1582: l_rec_num number := 0 ;
1583: l_output_name ben_ext_rslt.output_name%type ;
1584: l_file_name ben_ext_rslt.output_name%type ;
1585: l_var varchar2(4000) ;