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.PA_CONTROL_ITEMS_UTILS dependencies on PA_LOOKUPS

Line 828: FROM pa_lookups

824: WHERE ci_id = p_ci_id;
825:
826: CURSOR get_status_name(l_code varchar2)
827: IS SELECT meaning
828: FROM pa_lookups
829: WHERE lookup_type = 'CONTROL_ITEM_SYSTEM_STATUS'
830: AND lookup_code = l_code;
831:
832: CURSOR get_control_item_type

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

831:
832: CURSOR get_control_item_type
833: IS
834: SELECT pl.meaning,pl.lookup_code
835: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit
836: WHERE
837: pl.lookup_type = 'PA_CI_TYPE_CLASSES'
838: and pci.ci_type_id = pcit.ci_type_id
839: and pl.lookup_code = pcit.ci_type_class_code

Line 2116: FROM pa_lookups

2112:
2113:
2114: CURSOR get_status_name(l_code varchar2)
2115: IS SELECT meaning
2116: FROM pa_lookups
2117: WHERE lookup_type = 'CONTROL_ITEM_SYSTEM_STATUS'
2118: AND lookup_code = l_code;
2119:
2120: CURSOR get_control_item_type

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

2119:
2120: CURSOR get_control_item_type
2121: IS
2122: SELECT pl.meaning,pl.lookup_code
2123: FROM pa_lookups pl, pa_control_items pci, pa_ci_types_b pcit
2124: WHERE
2125: pl.lookup_type = 'PA_CI_TYPE_CLASSES'
2126: and pci.ci_type_id = pcit.ci_type_id
2127: and pl.lookup_code = pcit.ci_type_class_code