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.GHR_US_NFC_EXTRACTS dependencies on BEN_EXT_DATA_ELMT

Line 2239: from ben_ext_data_elmt elm,

2235: -- Cursor to get the seq num of the
2236: cursor csr_seq (c_ext_rcd_id in number) is
2237: select eir.seq_num
2238: ,elm.string_val
2239: from ben_ext_data_elmt elm,
2240: ben_ext_data_elmt_in_rcd eir
2241: where elm.ext_data_elmt_id = eir.ext_data_elmt_id
2242: and elm.data_elmt_typ_cd = 'R'
2243: and elm.string_val in ('RPA_REQ_ID', 'RPA_AWARD_ID',

Line 2240: ben_ext_data_elmt_in_rcd eir

2236: cursor csr_seq (c_ext_rcd_id in number) is
2237: select eir.seq_num
2238: ,elm.string_val
2239: from ben_ext_data_elmt elm,
2240: ben_ext_data_elmt_in_rcd eir
2241: where elm.ext_data_elmt_id = eir.ext_data_elmt_id
2242: and elm.data_elmt_typ_cd = 'R'
2243: and elm.string_val in ('RPA_REQ_ID', 'RPA_AWARD_ID',
2244: 'RPA_REMARK_ID','RPA_ADD_ID')

Line 3775: ,p_ext_data_element_name in ben_ext_data_elmt.name%type

3771: -- ~ Update_Record_Values :
3772: -- =============================================================================
3773: procedure Update_Record_Values
3774: (p_ext_rcd_id in ben_ext_rcd.ext_rcd_id%type
3775: ,p_ext_data_element_name in ben_ext_data_elmt.name%type
3776: ,p_data_element_value in ben_ext_rslt_dtl.val_01%type
3777: ,p_data_ele_seqnum in number
3778: ,p_ext_dtl_rec in out nocopy ben_ext_rslt_dtl%rowtype
3779: ) is

Line 3781: ,c_ext_data_element_name in ben_ext_data_elmt.name%type

3777: ,p_data_ele_seqnum in number
3778: ,p_ext_dtl_rec in out nocopy ben_ext_rslt_dtl%rowtype
3779: ) is
3780: cursor csr_seqnum (c_ext_rcd_id in ben_ext_rcd.ext_rcd_id%type
3781: ,c_ext_data_element_name in ben_ext_data_elmt.name%type
3782: ) is
3783: select der.ext_data_elmt_id,
3784: der.seq_num,
3785: ede.name

Line 3786: from ben_ext_data_elmt_in_rcd der

3782: ) is
3783: select der.ext_data_elmt_id,
3784: der.seq_num,
3785: ede.name
3786: from ben_ext_data_elmt_in_rcd der
3787: ,ben_ext_data_elmt ede
3788: where der.ext_rcd_id = c_ext_rcd_id
3789: and ede.ext_data_elmt_id = der.ext_data_elmt_id
3790: and ede.name like '%'|| c_ext_data_element_name

Line 3787: ,ben_ext_data_elmt ede

3783: select der.ext_data_elmt_id,
3784: der.seq_num,
3785: ede.name
3786: from ben_ext_data_elmt_in_rcd der
3787: ,ben_ext_data_elmt ede
3788: where der.ext_rcd_id = c_ext_rcd_id
3789: and ede.ext_data_elmt_id = der.ext_data_elmt_id
3790: and ede.name like '%'|| c_ext_data_element_name
3791: order by seq_num;

Line 4329: from ben_ext_data_elmt_in_rcd xer,

4325: select xer.seq_num,
4326: xer.sprs_cd,
4327: xer.ext_data_elmt_in_rcd_id,
4328: xdm.name
4329: from ben_ext_data_elmt_in_rcd xer,
4330: ben_ext_data_elmt xdm
4331: where ext_rcd_id = p_ext_rcd_id
4332: and xer.sprs_cd is not null
4333: and xer.ext_data_elmt_id = xdm.ext_data_elmt_id ;

Line 4330: ben_ext_data_elmt xdm

4326: xer.sprs_cd,
4327: xer.ext_data_elmt_in_rcd_id,
4328: xdm.name
4329: from ben_ext_data_elmt_in_rcd xer,
4330: ben_ext_data_elmt xdm
4331: where ext_rcd_id = p_ext_rcd_id
4332: and xer.sprs_cd is not null
4333: and xer.ext_data_elmt_id = xdm.ext_data_elmt_id ;
4334: --

Line 4341: ben_ext_data_elmt_in_rcd xer

4337: xwc.val,
4338: xwc.and_or_cd,
4339: xer.seq_num
4340: from ben_ext_where_clause xwc,
4341: ben_ext_data_elmt_in_rcd xer
4342: where xwc.ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id
4343: and xwc.cond_ext_data_elmt_in_rcd_id = xer.ext_data_elmt_in_rcd_id
4344: order by xwc.seq_num;
4345: --

Line 4487: ben_ext_data_elmt_in_rcd xer,

4483: xel.data_elmt_rl,
4484: xel.ext_fld_id,
4485: fld.frmt_mask_typ_cd
4486: from ben_ext_where_clause xwc,
4487: ben_ext_data_elmt_in_rcd xer,
4488: ben_ext_rcd xrc,
4489: ben_ext_data_elmt xel,
4490: ben_ext_fld fld
4491: where xwc.ext_rcd_in_file_id = p_ext_rcd_in_file_id

Line 4489: ben_ext_data_elmt xel,

4485: fld.frmt_mask_typ_cd
4486: from ben_ext_where_clause xwc,
4487: ben_ext_data_elmt_in_rcd xer,
4488: ben_ext_rcd xrc,
4489: ben_ext_data_elmt xel,
4490: ben_ext_fld fld
4491: where xwc.ext_rcd_in_file_id = p_ext_rcd_in_file_id
4492: and xwc.cond_ext_data_elmt_in_rcd_id = xer.ext_data_elmt_in_rcd_id
4493: and xer.ext_rcd_id = xrc.ext_rcd_id

Line 5223: from ben_ext_data_elmt b,

5219: ,b.string_val
5220: ,b.dflt_val
5221: ,b.max_length_num
5222: ,b.just_cd
5223: from ben_ext_data_elmt b,
5224: ben_ext_data_elmt_in_rcd a
5225: where a.ext_data_elmt_id = b.ext_data_elmt_id
5226: and b.data_elmt_typ_cd = 'R'
5227: and a.ext_rcd_id = c_ext_rcd_id

Line 5224: ben_ext_data_elmt_in_rcd a

5220: ,b.dflt_val
5221: ,b.max_length_num
5222: ,b.just_cd
5223: from ben_ext_data_elmt b,
5224: ben_ext_data_elmt_in_rcd a
5225: where a.ext_data_elmt_id = b.ext_data_elmt_id
5226: and b.data_elmt_typ_cd = 'R'
5227: and a.ext_rcd_id = c_ext_rcd_id
5228: order by a.seq_num;