APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_LOOKUPS

Line 2582: FROM csi_lookups

2578:
2579: BEGIN
2580: SELECT meaning
2581: INTO p_instance_header_tbl(tab_row).accounting_class
2582: FROM csi_lookups
2583: WHERE lookup_code = p_instance_header_tbl(tab_row).accounting_class_code
2584: AND lookup_type = l_acct_lookup_type;
2585: EXCEPTION
2586: WHEN OTHERS THEN

Line 2593: FROM csi_lookups

2589:
2590: BEGIN
2591: SELECT meaning
2592: INTO p_instance_header_tbl(tab_row).instance_type_name
2593: FROM csi_lookups
2594: WHERE lookup_code = p_instance_header_tbl(tab_row).instance_type_code
2595: AND lookup_type = l_inst_lookup_type;
2596: EXCEPTION
2597: WHEN OTHERS THEN

Line 2604: FROM csi_lookups

2600:
2601: BEGIN
2602: SELECT meaning
2603: INTO p_instance_header_tbl(tab_row).instance_usage_name
2604: FROM csi_lookups
2605: WHERE lookup_code = p_instance_header_tbl(tab_row).instance_usage_code
2606: AND lookup_type = l_usage_lookup_type;
2607: EXCEPTION
2608: WHEN OTHERS THEN

Line 2616: FROM csi_lookups

2612:
2613: BEGIN
2614: SELECT meaning
2615: INTO p_instance_header_tbl(tab_row).operational_status_name
2616: FROM csi_lookups
2617: WHERE lookup_code = p_instance_header_tbl(tab_row).operational_status_code
2618: AND lookup_type = l_op_status_lookup_type;
2619: EXCEPTION
2620: WHEN OTHERS THEN

Line 2628: FROM csi_lookups

2624: IF p_instance_header_tbl(tab_row).version_label IS NOT NULL THEN
2625: BEGIN
2626: SELECT meaning
2627: INTO p_instance_header_tbl(tab_row).version_label_meaning
2628: FROM csi_lookups
2629: WHERE lookup_code = p_instance_header_tbl(tab_row).version_label
2630: AND lookup_type = l_ver_label_lookup_type;
2631: EXCEPTION
2632: WHEN OTHERS THEN

Line 2890: FROM csi_lookups

2886: THEN
2887: BEGIN
2888: SELECT meaning
2889: INTO p_instance_header_tbl(tab_row).maintainable
2890: FROM csi_lookups
2891: WHERE lookup_code = DECODE(p_instance_header_tbl(tab_row).maintainable_flag,'Y','YES','N','NO')
2892: AND lookup_type = l_yesno_lookup_type;
2893: EXCEPTION WHEN OTHERS THEN
2894: NULL;