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 365: FROM ben_ext_dfn

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

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

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

Line 3425: from ben_ext_dfn bed

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

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

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

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

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

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

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

Line 6840: FROM ben_ext_dfn ed,

6836: -- Cursor to check if the extract is PQP extract.
6837: CURSOR check_pqp_extract (c_ext_dfn_id IN NUMBER,
6838: c_business_group_id IN NUMBER) IS
6839: SELECT ea.ext_dfn_type
6840: FROM ben_ext_dfn ed,
6841: per_business_groups bg,
6842: pqp_extract_attributes ea
6843: WHERE ((bg.business_group_id = ed.business_group_id)OR
6844: (bg.legislation_code = ed.legislation_code) OR