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.IGS_AD_ADM_REQ dependencies on IGS_RU_ITEM

Line 984: FROM IGS_RU_ITEM item

980:
981:
982: /* CURSOR c_rule_items(p_rul_seq_num NUMBER) IS
983: SELECT p_rul_seq_num, item.NAMED_RULE, 'Y'
984: FROM IGS_RU_ITEM item
985: WHERE item.RUL_SEQUENCE_NUMBER = p_rul_seq_num
986: AND item.NAMED_RULE in(30171, 30172, 30173, 30174, 30175,30176,30177,30178, 30174, -- Adreess
987: 30181,30182,30183,30184, -- Military Services
988: 30185, -- Person Disability

Line 1116: SELECT RULE_NUMBER FROM IGS_RU_ITEM item

1112: c_rule_items rul_items_cur_type;
1113: l_exists NUMBER := 0;
1114:
1115: CURSOR c_rule IS
1116: SELECT RULE_NUMBER FROM IGS_RU_ITEM item
1117: WHERE item.RUL_SEQUENCE_NUMBER = p_rul_seq_num
1118: AND rule_number is NOT NULL
1119: ORDER BY item desc;
1120: l_nest_rule_exists BOOLEAN;

Line 1124: ' SELECT 1 FROM IGS_RU_ITEM item ' ||

1120: l_nest_rule_exists BOOLEAN;
1121:
1122: BEGIN
1123: OPEN c_rule_items FOR
1124: ' SELECT 1 FROM IGS_RU_ITEM item ' ||
1125: ' WHERE item.RUL_SEQUENCE_NUMBER = :1 ' ||
1126: ' AND item.NAMED_RULE in (' || p_rul_item_seq_num_set || ') '
1127: USING p_rul_seq_num ;
1128: