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 514: FROM ben_ext_rcd rcd, ben_ext_rslt_dtl rdtl

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

Line 730: ben_ext_rcd_in_file erf

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

Line 746: ben_ext_rcd_in_file erf

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

Line 758: from ben_ext_rcd_in_file fil, ben_ext_rcd rcd

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

Line 1202: from ben_ext_rcd a,

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

Line 1203: ben_ext_rcd_in_file b

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

Line 1253: ben_ext_rcd rcd,

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

Line 1254: ben_ext_rcd_in_file erf

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

Line 1921: ben_ext_rcd rcd,

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

Line 1922: ben_ext_rcd_in_file erf

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

Line 2025: from ben_ext_rcd_in_file fil, ben_ext_rcd rcd

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

Line 2032: from ben_ext_rcd_in_file fil, ben_ext_rcd rcd

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

Line 2041: ben_ext_rcd rcd,

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

Line 2042: ben_ext_rcd_in_file erf

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

Line 2055: from ben_ext_rslt_dtl xrd , ben_ext_rcd_in_file erf

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

Line 5522: from ben_ext_rcd a,

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

Line 5523: ben_ext_rcd_in_file b

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