138: CLOSE C;
139:
140:
141: SELECT decode(p_revenue_class_id,
142: fnd_api.g_miss_num, oldrow.revenue_class_id,
143: p_revenue_class_id),
144: decode(p_name,
145: fnd_api.g_miss_char, oldrow.name,
146: p_name),
141: SELECT decode(p_revenue_class_id,
142: fnd_api.g_miss_num, oldrow.revenue_class_id,
143: p_revenue_class_id),
144: decode(p_name,
145: fnd_api.g_miss_char, oldrow.name,
146: p_name),
147: decode(p_description,
148: fnd_api.g_miss_char, oldrow.description,
149: p_description),
144: decode(p_name,
145: fnd_api.g_miss_char, oldrow.name,
146: p_name),
147: decode(p_description,
148: fnd_api.g_miss_char, oldrow.description,
149: p_description),
150: decode(p_liability_account_id,
151: fnd_api.g_miss_num, oldrow.liability_account_id,
152: p_liability_account_id),
147: decode(p_description,
148: fnd_api.g_miss_char, oldrow.description,
149: p_description),
150: decode(p_liability_account_id,
151: fnd_api.g_miss_num, oldrow.liability_account_id,
152: p_liability_account_id),
153: decode(p_expense_account_id,
154: fnd_api.g_miss_num, oldrow.expense_account_id,
155: p_expense_account_id)
150: decode(p_liability_account_id,
151: fnd_api.g_miss_num, oldrow.liability_account_id,
152: p_liability_account_id),
153: decode(p_expense_account_id,
154: fnd_api.g_miss_num, oldrow.expense_account_id,
155: p_expense_account_id)
156: INTO
157: l_revenue_class_id,
158: l_name ,