2178: , ATC.awt_period_type
2179: , ATC.awt_period_limit
2180: , ATC.inactive_date
2181: , ATC.tax_code_combination_id
2182: FROM ap_awt_group_taxes AAGT
2183: , ap_tax_codes ATC
2184: , ap_other_periods AOP
2185: WHERE (AAGT.group_id = GrpId)
2186: AND (AAGT.tax_name = ATC.name)
2217: DECLARE
2218: CURSOR c_init_rank
2219: IS
2220: SELECT MIN(rank)
2221: FROM ap_awt_group_taxes
2222: WHERE group_id = tab_group_id(g);
2223: BEGIN
2224:
2225: debug_info := 'Open CURSOR to get starting rank ';