APPS.FA_SUPER_GROUP_CHANGE_PKG dependencies on FA_SUPER_GROUP_RULES

Line 36: FROM fa_super_group_rules

32: SELECT super_group_id
33: , book_type_code
34: , start_period_counter
35: , end_period_counter
36: FROM fa_super_group_rules
37: WHERE adjustment_required_flag = 'Y'
38: AND date_ineffective is null
39: ORDER BY book_type_code, start_period_counter;
40:

Line 139: 2. Modify G1 cursor to make not to join fa_super_group_rules.

135:
136:
137: Processing super group change.
138: 1. Create super_group_id in dpr struct in pro*c and pl/sql
139: 2. Modify G1 cursor to make not to join fa_super_group_rules.
140: 3. populate super_group_id in G1.
141: 4. Create cache program for super group rules.
142: 5. in faxcde, in the early stage, get super group rules info if super_group_id is populated
143: 6. replace with super group info (deprn rate) etc...

Line 369: update fa_super_group_rules

365: END LOOP; -- group asset for loop
366:
367: CLOSE c_check_sg_used;
368:
369: update fa_super_group_rules
370: set adjustment_required_flag = 'N'
371: where super_group_id = t_super_group_id(i)
372: and book_type_code = t_book_type_code(i)
373: and adjustment_required_flag = 'Y';