APPS.FA_METHODS_PKG dependencies on FA_DEPRN_BASIS_RULES

Line 152: FROM fa_deprn_basis_rules

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

Line 163: FROM fa_deprn_basis_rules

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

Line 455: FROM fa_deprn_basis_rules

451: -- For Depreciable Basis Formula logic
452: UPDATE fa_methods
453: SET deprn_basis_rule_id =
454: (SELECT deprn_basis_rule_id
455: FROM fa_deprn_basis_rules
456: WHERE RULE_NAME='TRANSACTION')
457: WHERE rate_source_rule='FLAT'
458: AND deprn_basis_rule='NBV'
459: AND deprn_basis_formula IS NULL

Line 467: FROM fa_deprn_basis_rules

463:
464: UPDATE fa_methods
465: SET deprn_basis_rule_id =
466: (SELECT deprn_basis_rule_id
467: FROM fa_deprn_basis_rules
468: WHERE RULE_NAME='FYBEGIN')
469: WHERE rate_source_rule='FLAT'
470: AND deprn_basis_rule='NBV'
471: AND deprn_basis_formula ='STRICT_FLAT'

Line 530: FROM fa_deprn_basis_rules

526: -- For Depreciable Basis Formula logic
527: UPDATE fa_methods
528: SET deprn_basis_rule_id =
529: (SELECT deprn_basis_rule_id
530: FROM fa_deprn_basis_rules
531: WHERE RULE_NAME='TRANSACTION')
532: WHERE rate_source_rule='FLAT'
533: AND deprn_basis_rule='NBV'
534: AND deprn_basis_formula IS NULL

Line 542: FROM fa_deprn_basis_rules

538:
539: UPDATE fa_methods
540: SET deprn_basis_rule_id =
541: (SELECT deprn_basis_rule_id
542: FROM fa_deprn_basis_rules
543: WHERE RULE_NAME='FYBEGIN')
544: WHERE rate_source_rule='FLAT'
545: AND deprn_basis_rule='NBV'
546: AND deprn_basis_formula ='STRICT_FLAT'