APPS.BEN_EXTRACT dependencies on BEN_EXT_DATA_ELMT

Line 641: ben_ext_data_elmt_in_rcd c,

637: decode(sum(decode(e.csr_cd,'CWPR',1,0)),0,'N','Y') g_cwbawr_csr,
638: decode(sum(decode(e.csr_cd,'CBRADM',1,0)),0,'N','Y') g_cbradm_csr
639: from ben_ext_rcd_in_file a,
640: ben_ext_rcd b,
641: ben_ext_data_elmt_in_rcd c,
642: ben_ext_data_elmt d,
643: ben_ext_fld e
644: where a.ext_file_id = p_ext_file_id
645: and a.ext_rcd_id = b.ext_rcd_id

Line 642: ben_ext_data_elmt d,

638: decode(sum(decode(e.csr_cd,'CBRADM',1,0)),0,'N','Y') g_cbradm_csr
639: from ben_ext_rcd_in_file a,
640: ben_ext_rcd b,
641: ben_ext_data_elmt_in_rcd c,
642: ben_ext_data_elmt d,
643: ben_ext_fld e
644: where a.ext_file_id = p_ext_file_id
645: and a.ext_rcd_id = b.ext_rcd_id
646: and c.ext_rcd_id = b.ext_rcd_id

Line 662: ben_Ext_data_elmt_in_rcd edr,

658: cursor c_ext_elmt (p_data_elmt_in_rcd_id number
659: ) is
660: select exf.short_name
661: from ben_ext_fld exf,
662: ben_Ext_data_elmt_in_rcd edr,
663: ben_ext_data_elmt ede
664: where edr.ext_data_elmt_in_rcd_id = p_data_elmt_in_rcd_id
665: and edr.ext_data_elmt_id = ede.ext_Data_elmt_id
666: and ede.ext_fld_id = exf.ext_fld_id (+)

Line 663: ben_ext_data_elmt ede

659: ) is
660: select exf.short_name
661: from ben_ext_fld exf,
662: ben_Ext_data_elmt_in_rcd edr,
663: ben_ext_data_elmt ede
664: where edr.ext_data_elmt_in_rcd_id = p_data_elmt_in_rcd_id
665: and edr.ext_data_elmt_id = ede.ext_Data_elmt_id
666: and ede.ext_fld_id = exf.ext_fld_id (+)
667: ;