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_RCD

Line 512: FROM ben_ext_rcd rcd, ben_ext_rslt_dtl rdtl

508: WHERE rslt.ext_rslt_id = p_ext_rslt_id;
509: --
510: cursor c_ext_rcd is
511: SELECT distinct rdtl.ext_rcd_id ext_rcd_id
512: FROM ben_ext_rcd rcd, ben_ext_rslt_dtl rdtl
513: WHERE rdtl.ext_rslt_id = p_ext_rslt_id
514: and rdtl.ext_rcd_id = rcd.ext_rcd_id
515: and rcd.rcd_type_cd in ('H','T');
516: --

Line 728: ben_ext_rcd_in_file erf

724: cursor get_dtl_cnt(p_group_val_01 varchar2 ,
725: p_group_val_02 varchar2) is
726: select count(*)
727: from ben_ext_rslt_dtl xrd ,
728: ben_ext_rcd_in_file erf
729: where xrd.ext_rslt_id = p_ext_rslt_id
730: and xrd.ext_rcd_id = erf.ext_rcd_id
731: and xrd.ext_rcd_in_file_id = erf.ext_rcd_in_file_id
732: and erf.ext_file_id = p_ext_file_id

Line 744: ben_ext_rcd_in_file erf

740: cursor get_ttl_cnt(p_group_val_01 varchar2 ,
741: p_group_val_02 varchar2) is
742: select count(*)
743: from ben_ext_rslt_dtl xrd ,
744: ben_ext_rcd_in_file erf
745: where xrd.ext_rslt_id = p_ext_rslt_id
746: and xrd.ext_rcd_id = erf.ext_rcd_id
747: and xrd.ext_rcd_in_file_id = erf.ext_rcd_in_file_id
748: and erf.ext_file_id = p_ext_file_id

Line 756: from ben_ext_rcd_in_file fil, ben_ext_rcd rcd

752: ;
753:
754: cursor get_subtrl_cnt is
755: select count(*)
756: from ben_ext_rcd_in_file fil, ben_ext_rcd rcd
757: where fil.ext_rcd_id = rcd.ext_rcd_id
758: and fil.ext_file_id = p_ext_file_id
759: and rcd.rcd_type_cd = 'L';
760:

Line 1200: from ben_ext_rcd a,

1196: b.ext_rcd_in_file_id,
1197: b.seq_num,
1198: b.sprs_cd,
1199: b.rqd_flag
1200: from ben_ext_rcd a,
1201: ben_ext_rcd_in_file b
1202: where a.ext_rcd_id = b.ext_rcd_id
1203: and b.ext_file_id = p_ext_file_id
1204: and a.rcd_type_cd = p_rcd_typ_cd

Line 1201: ben_ext_rcd_in_file b

1197: b.seq_num,
1198: b.sprs_cd,
1199: b.rqd_flag
1200: from ben_ext_rcd a,
1201: ben_ext_rcd_in_file b
1202: where a.ext_rcd_id = b.ext_rcd_id
1203: and b.ext_file_id = p_ext_file_id
1204: and a.rcd_type_cd = p_rcd_typ_cd
1205: order by b.seq_num;

Line 1251: ben_ext_rcd rcd,

1247:
1248: cursor get_subtrl_cnt is
1249: select count(*)
1250: from ben_Ext_rslt_dtl xrd,
1251: ben_ext_rcd rcd,
1252: ben_ext_rcd_in_file erf
1253: where xrd.ext_rslt_id = p_ext_rslt_id
1254: and xrd.ext_rcd_id = erf.ext_rcd_id
1255: and xrd.ext_rcd_in_file_id = erf.ext_rcd_in_file_id

Line 1252: ben_ext_rcd_in_file erf

1248: cursor get_subtrl_cnt is
1249: select count(*)
1250: from ben_Ext_rslt_dtl xrd,
1251: ben_ext_rcd rcd,
1252: ben_ext_rcd_in_file erf
1253: where xrd.ext_rslt_id = p_ext_rslt_id
1254: and xrd.ext_rcd_id = erf.ext_rcd_id
1255: and xrd.ext_rcd_in_file_id = erf.ext_rcd_in_file_id
1256: and erf.ext_file_id = p_ext_file_id

Line 1919: ben_ext_rcd rcd,

1915: xrd.group_val_01,
1916: xrd.group_val_02,
1917: nvl(xrd.ext_per_bg_id,-1) ext_per_bg_id
1918: from ben_Ext_rslt_dtl xrd,
1919: ben_ext_rcd rcd,
1920: ben_ext_rcd_in_file erf
1921: where xrd.ext_rslt_id = p_ext_rslt_id
1922: and xrd.ext_rcd_id = erf.ext_rcd_id
1923: and erf.ext_file_id = p_ext_file_id

Line 1920: ben_ext_rcd_in_file erf

1916: xrd.group_val_02,
1917: nvl(xrd.ext_per_bg_id,-1) ext_per_bg_id
1918: from ben_Ext_rslt_dtl xrd,
1919: ben_ext_rcd rcd,
1920: ben_ext_rcd_in_file erf
1921: where xrd.ext_rslt_id = p_ext_rslt_id
1922: and xrd.ext_rcd_id = erf.ext_rcd_id
1923: and erf.ext_file_id = p_ext_file_id
1924: and rcd.ext_rcd_id = erf.ext_rcd_id

Line 2023: from ben_ext_rcd_in_file fil, ben_ext_rcd rcd

2019: and fnd.request_id = p_request_id;
2020: --
2021: cursor get_hdr_cnt is
2022: select count(*)
2023: from ben_ext_rcd_in_file fil, ben_ext_rcd rcd
2024: where fil.ext_rcd_id = rcd.ext_rcd_id
2025: and fil.ext_file_id = p_ext_file_id
2026: and rcd.rcd_type_cd = 'H';
2027: --

Line 2030: from ben_ext_rcd_in_file fil, ben_ext_rcd rcd

2026: and rcd.rcd_type_cd = 'H';
2027: --
2028: cursor get_trl_cnt is
2029: select count(*)
2030: from ben_ext_rcd_in_file fil, ben_ext_rcd rcd
2031: where fil.ext_rcd_id = rcd.ext_rcd_id
2032: and fil.ext_file_id = p_ext_file_id
2033: and rcd.rcd_type_cd = 'T';
2034: --

Line 2039: ben_ext_rcd rcd,

2035:
2036: cursor get_subhdr_cnt is
2037: select count(*)
2038: from ben_Ext_rslt_dtl xrd,
2039: ben_ext_rcd rcd,
2040: ben_ext_rcd_in_file erf
2041: where xrd.ext_rslt_id = p_ext_rslt_id
2042: and xrd.ext_rcd_id = erf.ext_rcd_id
2043: and xrd.ext_rcd_in_file_id = erf.ext_rcd_in_file_id

Line 2040: ben_ext_rcd_in_file erf

2036: cursor get_subhdr_cnt is
2037: select count(*)
2038: from ben_Ext_rslt_dtl xrd,
2039: ben_ext_rcd rcd,
2040: ben_ext_rcd_in_file erf
2041: where xrd.ext_rslt_id = p_ext_rslt_id
2042: and xrd.ext_rcd_id = erf.ext_rcd_id
2043: and xrd.ext_rcd_in_file_id = erf.ext_rcd_in_file_id
2044: and erf.ext_file_id = p_ext_file_id

Line 2053: from ben_ext_rslt_dtl xrd , ben_ext_rcd_in_file erf

2049: --
2050:
2051: cursor get_dtl_cnt is
2052: select count(*)
2053: from ben_ext_rslt_dtl xrd , ben_ext_rcd_in_file erf
2054: where xrd.ext_rslt_id = p_ext_rslt_id
2055: and xrd.ext_rcd_id = erf.ext_rcd_id
2056: and xrd.ext_rcd_in_file_id = erf.ext_rcd_in_file_id
2057: and erf.ext_file_id = p_ext_file_id

Line 5519: from ben_ext_rcd a,

5515:
5516: -- check the defintion of detail levle
5517: cursor chk_D_lvl(p_ext_file_id number) is
5518: select 'Y'
5519: from ben_ext_rcd a,
5520: ben_ext_rcd_in_file b
5521: where a.ext_rcd_id = b.ext_rcd_id
5522: and b.ext_file_id = p_ext_file_id
5523: and a.rcd_type_cd = 'D'

Line 5520: ben_ext_rcd_in_file b

5516: -- check the defintion of detail levle
5517: cursor chk_D_lvl(p_ext_file_id number) is
5518: select 'Y'
5519: from ben_ext_rcd a,
5520: ben_ext_rcd_in_file b
5521: where a.ext_rcd_id = b.ext_rcd_id
5522: and b.ext_file_id = p_ext_file_id
5523: and a.rcd_type_cd = 'D'
5524: ;