DBA Data[Home] [Help]

APPS.ECX_DIAGNOSTICS_TEST dependencies on ECX_TRAN_STAGE_DATA

Line 134: from ecx_tran_stage_data etsd

130: from ecx_proc_mappings epm
131: where epm.map_id =v_rec_package_details.map_id
132: and epm.transtage_id =
133: (select transtage_id
134: from ecx_tran_stage_data etsd
135: where etsd.map_id = v_rec_package_details.map_id
136: and upper(etsd.custom_procedure_name)= v_rec_package_details.full_name
137: and rownum =1
138: )

Line 372: from ecx_tran_stage_data etsd,

368: for x in
369: (select distinct etsd.map_id,
370: em.map_code,
371: upper(etsd.custom_procedure_name) full_name
372: from ecx_tran_stage_data etsd,
373: ecx_mappings em
374: where etsd.map_id = em.map_id
375: and custom_procedure_name is not null
376: order by full_name