APPS.FA_SUPER_GROUP_CHANGE_PKG dependencies on FA_SUPER_GROUP_RULES

Line 34: FROM fa_super_group_rules

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

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

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

Line 397: update fa_super_group_rules

393: END LOOP; -- group asset for loop
394:
395: CLOSE c_check_sg_used;
396:
397: update fa_super_group_rules
398: set adjustment_required_flag = 'N'
399: where super_group_id = t_super_group_id(i)
400: and book_type_code = t_book_type_code(i)
401: and adjustment_required_flag = 'Y';