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_CONTROL_ITEMS_UTILS dependencies on PA_LOOKUPS

Line 872: FROM pa_lookups

868: WHERE ci_id = p_ci_id;
869:
870: CURSOR get_status_name(l_code varchar2)
871: IS SELECT meaning
872: FROM pa_lookups
873: WHERE lookup_type = 'CONTROL_ITEM_SYSTEM_STATUS'
874: AND lookup_code = l_code;
875:
876: CURSOR get_control_item_type

Line 879: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit

875:
876: CURSOR get_control_item_type
877: IS
878: SELECT pl.meaning,pl.lookup_code
879: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit
880: WHERE
881: pl.lookup_type = 'PA_CI_TYPE_CLASSES'
882: and pci.ci_type_id = pcit.ci_type_id
883: and pl.lookup_code = pcit.ci_type_class_code

Line 2212: FROM pa_lookups

2208:
2209:
2210: CURSOR get_status_name(l_code varchar2)
2211: IS SELECT meaning
2212: FROM pa_lookups
2213: WHERE lookup_type = 'CONTROL_ITEM_SYSTEM_STATUS'
2214: AND lookup_code = l_code;
2215:
2216: CURSOR get_control_item_type

Line 2219: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit

2215:
2216: CURSOR get_control_item_type
2217: IS
2218: SELECT pl.meaning,pl.lookup_code
2219: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit
2220: WHERE
2221: pl.lookup_type = 'PA_CI_TYPE_CLASSES'
2222: and pci.ci_type_id = pcit.ci_type_id
2223: and pl.lookup_code = pcit.ci_type_class_code