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.

[Home] [Help]

APPS.PA_CI_IMPACT_TYPE_USAGE_PVT dependencies on PA_LOOKUPS

Line 211: SELECT MEANING FROM pa_lookups

207: WHERE ci_impact_type_usage_id = p_ci_impact_type_usage_id
208: );
209: --start:| 16-FEB-2009 cklee R12.1.2 setup ehancement
210: CURSOR c_impact_type is
211: SELECT MEANING FROM pa_lookups
212: WHERE LOOKUP_TYPE = 'PA_CI_IMPACT_TYPES'
213: AND LOOKUP_CODE = p_impact_type_code;
214:
215: l_impact_type_meaning pa_lookups.MEANING%type;

Line 215: l_impact_type_meaning pa_lookups.MEANING%type;

211: SELECT MEANING FROM pa_lookups
212: WHERE LOOKUP_TYPE = 'PA_CI_IMPACT_TYPES'
213: AND LOOKUP_CODE = p_impact_type_code;
214:
215: l_impact_type_meaning pa_lookups.MEANING%type;
216: --end:| 16-FEB-2009 cklee R12.1.2 setup ehancement
217:
218:
219: l_dummy VARCHAR2(1);

Line 342: pa_lookups luk

338: select pc.impact_type_code,
339: luk.meaning impact_type_name
340: from pa_control_items pci,
341: pa_ci_impacts pc,
342: pa_lookups luk
343: where pci.ci_type_id = p_ci_type_id
344: and pci.ci_id = pc.ci_id
345: and pc.impact_type_code = luk.lookup_code
346: and luk.lookup_type = 'PA_CI_IMPACT_TYPES'