81: percent_salvage_value number
82: );
83:
84: TYPE fazcdbr_rec_type is RECORD (
85: deprn_basis_rule_id FA_DEPRN_BASIS_RULES.DEPRN_BASIS_RULE_ID%TYPE,
86: rule_name FA_DEPRN_BASIS_RULES.RULE_NAME%TYPE,
87: user_rule_name FA_DEPRN_BASIS_RULES.USER_RULE_NAME%TYPE,
88: last_update_date FA_DEPRN_BASIS_RULES.LAST_UPDATE_DATE%TYPE,
89: last_updated_by FA_DEPRN_BASIS_RULES.LAST_UPDATED_BY%TYPE,
82: );
83:
84: TYPE fazcdbr_rec_type is RECORD (
85: deprn_basis_rule_id FA_DEPRN_BASIS_RULES.DEPRN_BASIS_RULE_ID%TYPE,
86: rule_name FA_DEPRN_BASIS_RULES.RULE_NAME%TYPE,
87: user_rule_name FA_DEPRN_BASIS_RULES.USER_RULE_NAME%TYPE,
88: last_update_date FA_DEPRN_BASIS_RULES.LAST_UPDATE_DATE%TYPE,
89: last_updated_by FA_DEPRN_BASIS_RULES.LAST_UPDATED_BY%TYPE,
90: created_by FA_DEPRN_BASIS_RULES.CREATED_BY%TYPE,
83:
84: TYPE fazcdbr_rec_type is RECORD (
85: deprn_basis_rule_id FA_DEPRN_BASIS_RULES.DEPRN_BASIS_RULE_ID%TYPE,
86: rule_name FA_DEPRN_BASIS_RULES.RULE_NAME%TYPE,
87: user_rule_name FA_DEPRN_BASIS_RULES.USER_RULE_NAME%TYPE,
88: last_update_date FA_DEPRN_BASIS_RULES.LAST_UPDATE_DATE%TYPE,
89: last_updated_by FA_DEPRN_BASIS_RULES.LAST_UPDATED_BY%TYPE,
90: created_by FA_DEPRN_BASIS_RULES.CREATED_BY%TYPE,
91: creation_date FA_DEPRN_BASIS_RULES.CREATION_DATE%TYPE,
84: TYPE fazcdbr_rec_type is RECORD (
85: deprn_basis_rule_id FA_DEPRN_BASIS_RULES.DEPRN_BASIS_RULE_ID%TYPE,
86: rule_name FA_DEPRN_BASIS_RULES.RULE_NAME%TYPE,
87: user_rule_name FA_DEPRN_BASIS_RULES.USER_RULE_NAME%TYPE,
88: last_update_date FA_DEPRN_BASIS_RULES.LAST_UPDATE_DATE%TYPE,
89: last_updated_by FA_DEPRN_BASIS_RULES.LAST_UPDATED_BY%TYPE,
90: created_by FA_DEPRN_BASIS_RULES.CREATED_BY%TYPE,
91: creation_date FA_DEPRN_BASIS_RULES.CREATION_DATE%TYPE,
92: last_update_login FA_DEPRN_BASIS_RULES.LAST_UPDATE_LOGIN%TYPE,
85: deprn_basis_rule_id FA_DEPRN_BASIS_RULES.DEPRN_BASIS_RULE_ID%TYPE,
86: rule_name FA_DEPRN_BASIS_RULES.RULE_NAME%TYPE,
87: user_rule_name FA_DEPRN_BASIS_RULES.USER_RULE_NAME%TYPE,
88: last_update_date FA_DEPRN_BASIS_RULES.LAST_UPDATE_DATE%TYPE,
89: last_updated_by FA_DEPRN_BASIS_RULES.LAST_UPDATED_BY%TYPE,
90: created_by FA_DEPRN_BASIS_RULES.CREATED_BY%TYPE,
91: creation_date FA_DEPRN_BASIS_RULES.CREATION_DATE%TYPE,
92: last_update_login FA_DEPRN_BASIS_RULES.LAST_UPDATE_LOGIN%TYPE,
93: rate_source FA_DEPRN_BASIS_RULES.RATE_SOURCE%TYPE,
86: rule_name FA_DEPRN_BASIS_RULES.RULE_NAME%TYPE,
87: user_rule_name FA_DEPRN_BASIS_RULES.USER_RULE_NAME%TYPE,
88: last_update_date FA_DEPRN_BASIS_RULES.LAST_UPDATE_DATE%TYPE,
89: last_updated_by FA_DEPRN_BASIS_RULES.LAST_UPDATED_BY%TYPE,
90: created_by FA_DEPRN_BASIS_RULES.CREATED_BY%TYPE,
91: creation_date FA_DEPRN_BASIS_RULES.CREATION_DATE%TYPE,
92: last_update_login FA_DEPRN_BASIS_RULES.LAST_UPDATE_LOGIN%TYPE,
93: rate_source FA_DEPRN_BASIS_RULES.RATE_SOURCE%TYPE,
94: deprn_basis FA_DEPRN_BASIS_RULES.DEPRN_BASIS%TYPE,
87: user_rule_name FA_DEPRN_BASIS_RULES.USER_RULE_NAME%TYPE,
88: last_update_date FA_DEPRN_BASIS_RULES.LAST_UPDATE_DATE%TYPE,
89: last_updated_by FA_DEPRN_BASIS_RULES.LAST_UPDATED_BY%TYPE,
90: created_by FA_DEPRN_BASIS_RULES.CREATED_BY%TYPE,
91: creation_date FA_DEPRN_BASIS_RULES.CREATION_DATE%TYPE,
92: last_update_login FA_DEPRN_BASIS_RULES.LAST_UPDATE_LOGIN%TYPE,
93: rate_source FA_DEPRN_BASIS_RULES.RATE_SOURCE%TYPE,
94: deprn_basis FA_DEPRN_BASIS_RULES.DEPRN_BASIS%TYPE,
95: enabled_flag FA_DEPRN_BASIS_RULES.ENABLED_FLAG%TYPE,
88: last_update_date FA_DEPRN_BASIS_RULES.LAST_UPDATE_DATE%TYPE,
89: last_updated_by FA_DEPRN_BASIS_RULES.LAST_UPDATED_BY%TYPE,
90: created_by FA_DEPRN_BASIS_RULES.CREATED_BY%TYPE,
91: creation_date FA_DEPRN_BASIS_RULES.CREATION_DATE%TYPE,
92: last_update_login FA_DEPRN_BASIS_RULES.LAST_UPDATE_LOGIN%TYPE,
93: rate_source FA_DEPRN_BASIS_RULES.RATE_SOURCE%TYPE,
94: deprn_basis FA_DEPRN_BASIS_RULES.DEPRN_BASIS%TYPE,
95: enabled_flag FA_DEPRN_BASIS_RULES.ENABLED_FLAG%TYPE,
96: program_name FA_DEPRN_BASIS_RULES.PROGRAM_NAME%TYPE,
89: last_updated_by FA_DEPRN_BASIS_RULES.LAST_UPDATED_BY%TYPE,
90: created_by FA_DEPRN_BASIS_RULES.CREATED_BY%TYPE,
91: creation_date FA_DEPRN_BASIS_RULES.CREATION_DATE%TYPE,
92: last_update_login FA_DEPRN_BASIS_RULES.LAST_UPDATE_LOGIN%TYPE,
93: rate_source FA_DEPRN_BASIS_RULES.RATE_SOURCE%TYPE,
94: deprn_basis FA_DEPRN_BASIS_RULES.DEPRN_BASIS%TYPE,
95: enabled_flag FA_DEPRN_BASIS_RULES.ENABLED_FLAG%TYPE,
96: program_name FA_DEPRN_BASIS_RULES.PROGRAM_NAME%TYPE,
97: description FA_DEPRN_BASIS_RULES.DESCRIPTION%TYPE,
90: created_by FA_DEPRN_BASIS_RULES.CREATED_BY%TYPE,
91: creation_date FA_DEPRN_BASIS_RULES.CREATION_DATE%TYPE,
92: last_update_login FA_DEPRN_BASIS_RULES.LAST_UPDATE_LOGIN%TYPE,
93: rate_source FA_DEPRN_BASIS_RULES.RATE_SOURCE%TYPE,
94: deprn_basis FA_DEPRN_BASIS_RULES.DEPRN_BASIS%TYPE,
95: enabled_flag FA_DEPRN_BASIS_RULES.ENABLED_FLAG%TYPE,
96: program_name FA_DEPRN_BASIS_RULES.PROGRAM_NAME%TYPE,
97: description FA_DEPRN_BASIS_RULES.DESCRIPTION%TYPE,
98: polish_rule NUMBER
91: creation_date FA_DEPRN_BASIS_RULES.CREATION_DATE%TYPE,
92: last_update_login FA_DEPRN_BASIS_RULES.LAST_UPDATE_LOGIN%TYPE,
93: rate_source FA_DEPRN_BASIS_RULES.RATE_SOURCE%TYPE,
94: deprn_basis FA_DEPRN_BASIS_RULES.DEPRN_BASIS%TYPE,
95: enabled_flag FA_DEPRN_BASIS_RULES.ENABLED_FLAG%TYPE,
96: program_name FA_DEPRN_BASIS_RULES.PROGRAM_NAME%TYPE,
97: description FA_DEPRN_BASIS_RULES.DESCRIPTION%TYPE,
98: polish_rule NUMBER
99: );
92: last_update_login FA_DEPRN_BASIS_RULES.LAST_UPDATE_LOGIN%TYPE,
93: rate_source FA_DEPRN_BASIS_RULES.RATE_SOURCE%TYPE,
94: deprn_basis FA_DEPRN_BASIS_RULES.DEPRN_BASIS%TYPE,
95: enabled_flag FA_DEPRN_BASIS_RULES.ENABLED_FLAG%TYPE,
96: program_name FA_DEPRN_BASIS_RULES.PROGRAM_NAME%TYPE,
97: description FA_DEPRN_BASIS_RULES.DESCRIPTION%TYPE,
98: polish_rule NUMBER
99: );
100:
93: rate_source FA_DEPRN_BASIS_RULES.RATE_SOURCE%TYPE,
94: deprn_basis FA_DEPRN_BASIS_RULES.DEPRN_BASIS%TYPE,
95: enabled_flag FA_DEPRN_BASIS_RULES.ENABLED_FLAG%TYPE,
96: program_name FA_DEPRN_BASIS_RULES.PROGRAM_NAME%TYPE,
97: description FA_DEPRN_BASIS_RULES.DESCRIPTION%TYPE,
98: polish_rule NUMBER
99: );
100:
101: -- BUG# 1913745 - implementing arrays to recuce db hits