APPS.ITA_RECORD_CURR_STATUS_PKG dependencies on ITA_SETUP_INSTANCES_B

Line 432: SELECT INSTANCE_CODE INTO l_inst_code FROM ITA_SETUP_INSTANCES_B WHERE CURRENT_FLAG='Y';

428: IF l_audit_start_date IS NULL
429: THEN
430: l_del_sql := 'delete from ITA_SETUP_CHANGE_HISTORY where INSTANCE_CODE = ''CURRENT'' and SETUP_GROUP_CODE =''' || l_setup_gp_code || '''';
431: EXECUTE IMMEDIATE l_del_sql;
432: SELECT INSTANCE_CODE INTO l_inst_code FROM ITA_SETUP_INSTANCES_B WHERE CURRENT_FLAG='Y';
433: -- l_shadow_table_name := get_shadow_table_prefix(p_table_name);
434: FOR l_param_rec IN c_get_parameters(l_setup_gp_code)
435: LOOP
436: EXIT WHEN c_get_parameters%NOTFOUND;

Line 710: SELECT INSTANCE_CODE INTO l_inst_code FROM ITA_SETUP_INSTANCES_B WHERE CURRENT_FLAG='Y';

706: IF l_audit_start_date IS NULL
707: THEN
708: l_del_sql := 'delete from ITA_SETUP_CHANGE_HISTORY where INSTANCE_CODE = ''CURRENT'' and SETUP_GROUP_CODE =''' || l_setup_gp_code || '''';
709: EXECUTE IMMEDIATE l_del_sql;
710: SELECT INSTANCE_CODE INTO l_inst_code FROM ITA_SETUP_INSTANCES_B WHERE CURRENT_FLAG='Y';
711: /* pk1 - level id
712: pk2 - level value
713: pk6 - level value name
714: pk10 - level value application id */