eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_THREAD dependencies on BEN_EXT_DFN

Line 363: FROM ben_ext_dfn

359: , ext_global_flag
360: , output_type
361: , xdo_template_id
362: , cm_display_flag
363: FROM ben_ext_dfn
364: WHERE ext_dfn_id = p_ext_dfn_id;
365: --
366:
367: -- subhead

Line 2205: l_use_eff_dt_for_chgs_flag ben_ext_dfn.use_eff_dt_for_chgs_flag%TYPE; -- UTF8 varchar2(30);

2201: l_chunk_size number;
2202: l_effective_date date;
2203: l_ext_strt_dt date;
2204: l_ext_end_dt date;
2205: l_use_eff_dt_for_chgs_flag ben_ext_dfn.use_eff_dt_for_chgs_flag%TYPE; -- UTF8 varchar2(30);
2206: l_failure_in_other_thread boolean := false;
2207: --
2208: -- Cursors declaration
2209: --

Line 3423: from ben_ext_dfn bed

3419: --For Penserver 115.70
3420: -- Cursor to check for PQP Earnings Extract
3421: cursor c_pen_ern is
3422: select bed.ext_dfn_id
3423: from ben_ext_dfn bed
3424: where bed.name = 'PQP GB PenServer Standard Interface - Earnings History';
3425: --
3426: l_pen_ext_dfn_id number;
3427:

Line 5494: l_apnd_rqst_id_flag ben_ext_dfn.apnd_rqst_id_flag%TYPE; -- UTF8 varchar2(40);

5490: l_prmy_sort_cd hr_lookups.lookup_code%TYPE ; -- UTF8 varchar2(30);
5491: l_scnd_sort_cd hr_lookups.lookup_code%TYPE ; -- UTF8 varchar2(30);
5492: l_output_name ben_ext_rslt.output_name%type ;
5493: l_drctry_name ben_ext_rslt.drctry_name%type ;
5494: l_apnd_rqst_id_flag ben_ext_dfn.apnd_rqst_id_flag%TYPE; -- UTF8 varchar2(40);
5495: l_kickoff_wrt_prc_flag ben_ext_dfn.kickoff_wrt_prc_flag%TYPE; -- UTF8 varchar2(40);
5496: l_use_eff_dt_for_chgs_flag ben_ext_dfn.use_eff_dt_for_chgs_flag%TYPE ; -- UTF8 varchar2(40);
5497: l_ext_post_prcs_rl number;
5498: l_xrs_object_version_number number;

Line 5495: l_kickoff_wrt_prc_flag ben_ext_dfn.kickoff_wrt_prc_flag%TYPE; -- UTF8 varchar2(40);

5491: l_scnd_sort_cd hr_lookups.lookup_code%TYPE ; -- UTF8 varchar2(30);
5492: l_output_name ben_ext_rslt.output_name%type ;
5493: l_drctry_name ben_ext_rslt.drctry_name%type ;
5494: l_apnd_rqst_id_flag ben_ext_dfn.apnd_rqst_id_flag%TYPE; -- UTF8 varchar2(40);
5495: l_kickoff_wrt_prc_flag ben_ext_dfn.kickoff_wrt_prc_flag%TYPE; -- UTF8 varchar2(40);
5496: l_use_eff_dt_for_chgs_flag ben_ext_dfn.use_eff_dt_for_chgs_flag%TYPE ; -- UTF8 varchar2(40);
5497: l_ext_post_prcs_rl number;
5498: l_xrs_object_version_number number;
5499: l_error_cd hr_lookups.lookup_code%TYPE ; -- UTF8 varchar2(80);

Line 5496: l_use_eff_dt_for_chgs_flag ben_ext_dfn.use_eff_dt_for_chgs_flag%TYPE ; -- UTF8 varchar2(40);

5492: l_output_name ben_ext_rslt.output_name%type ;
5493: l_drctry_name ben_ext_rslt.drctry_name%type ;
5494: l_apnd_rqst_id_flag ben_ext_dfn.apnd_rqst_id_flag%TYPE; -- UTF8 varchar2(40);
5495: l_kickoff_wrt_prc_flag ben_ext_dfn.kickoff_wrt_prc_flag%TYPE; -- UTF8 varchar2(40);
5496: l_use_eff_dt_for_chgs_flag ben_ext_dfn.use_eff_dt_for_chgs_flag%TYPE ; -- UTF8 varchar2(40);
5497: l_ext_post_prcs_rl number;
5498: l_xrs_object_version_number number;
5499: l_error_cd hr_lookups.lookup_code%TYPE ; -- UTF8 varchar2(80);
5500: l_line number := 0;

Line 6799: FROM ben_ext_dfn ed,

6795: -- Cursor to check if the extract is PQP extract.
6796: CURSOR check_pqp_extract (c_ext_dfn_id IN NUMBER,
6797: c_business_group_id IN NUMBER) IS
6798: SELECT ea.ext_dfn_type
6799: FROM ben_ext_dfn ed,
6800: per_business_groups bg,
6801: pqp_extract_attributes ea
6802: WHERE ((bg.business_group_id = ed.business_group_id)OR
6803: (bg.legislation_code = ed.legislation_code) OR