APPS.FA_METHODS_PKG dependencies on FA_DEPRN_BASIS_RULES

Line 149: FROM fa_deprn_basis_rules

145: -- For Depreciable Basis Formula logic
146: UPDATE fa_methods
147: SET deprn_basis_rule_id =
148: (SELECT deprn_basis_rule_id
149: FROM fa_deprn_basis_rules
150: WHERE RULE_NAME='TRANSACTION')
151: WHERE rate_source_rule='FLAT'
152: AND deprn_basis_rule='NBV'
153: AND deprn_basis_formula IS NULL

Line 160: FROM fa_deprn_basis_rules

156:
157: UPDATE fa_methods
158: SET deprn_basis_rule_id =
159: (SELECT deprn_basis_rule_id
160: FROM fa_deprn_basis_rules
161: WHERE RULE_NAME='FYBEGIN')
162: WHERE rate_source_rule='FLAT'
163: AND deprn_basis_rule='NBV'
164: AND deprn_basis_formula ='STRICT_FLAT'

Line 449: FROM fa_deprn_basis_rules

445: -- For Depreciable Basis Formula logic
446: UPDATE fa_methods
447: SET deprn_basis_rule_id =
448: (SELECT deprn_basis_rule_id
449: FROM fa_deprn_basis_rules
450: WHERE RULE_NAME='TRANSACTION')
451: WHERE rate_source_rule='FLAT'
452: AND deprn_basis_rule='NBV'
453: AND deprn_basis_formula IS NULL

Line 461: FROM fa_deprn_basis_rules

457:
458: UPDATE fa_methods
459: SET deprn_basis_rule_id =
460: (SELECT deprn_basis_rule_id
461: FROM fa_deprn_basis_rules
462: WHERE RULE_NAME='FYBEGIN')
463: WHERE rate_source_rule='FLAT'
464: AND deprn_basis_rule='NBV'
465: AND deprn_basis_formula ='STRICT_FLAT'

Line 523: FROM fa_deprn_basis_rules

519: -- For Depreciable Basis Formula logic
520: UPDATE fa_methods
521: SET deprn_basis_rule_id =
522: (SELECT deprn_basis_rule_id
523: FROM fa_deprn_basis_rules
524: WHERE RULE_NAME='TRANSACTION')
525: WHERE rate_source_rule='FLAT'
526: AND deprn_basis_rule='NBV'
527: AND deprn_basis_formula IS NULL

Line 535: FROM fa_deprn_basis_rules

531:
532: UPDATE fa_methods
533: SET deprn_basis_rule_id =
534: (SELECT deprn_basis_rule_id
535: FROM fa_deprn_basis_rules
536: WHERE RULE_NAME='FYBEGIN')
537: WHERE rate_source_rule='FLAT'
538: AND deprn_basis_rule='NBV'
539: AND deprn_basis_formula ='STRICT_FLAT'