The following lines contain the word 'select', 'insert', 'update' or 'delete':
pay_continuous_calc.event_update(p_business_group_id
,p_legislation_code
,'PQP_ASSIGNMENT_ATTRIBUTES_F'
,'AAT_ATTRIBUTE1'
,p_old_AAT_ATTRIBUTE1
,p_new_AAT_ATTRIBUTE1
,p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE10',
p_old_AAT_ATTRIBUTE10,
p_new_AAT_ATTRIBUTE10,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE11',
p_old_AAT_ATTRIBUTE11,
p_new_AAT_ATTRIBUTE11,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE12',
p_old_AAT_ATTRIBUTE12,
p_new_AAT_ATTRIBUTE12,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE13',
p_old_AAT_ATTRIBUTE13,
p_new_AAT_ATTRIBUTE13,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE14',
p_old_AAT_ATTRIBUTE14,
p_new_AAT_ATTRIBUTE14,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE15',
p_old_AAT_ATTRIBUTE15,
p_new_AAT_ATTRIBUTE15,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE16',
p_old_AAT_ATTRIBUTE16,
p_new_AAT_ATTRIBUTE16,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE17',
p_old_AAT_ATTRIBUTE17,
p_new_AAT_ATTRIBUTE17,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE18',
p_old_AAT_ATTRIBUTE18,
p_new_AAT_ATTRIBUTE18,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE19',
p_old_AAT_ATTRIBUTE19,
p_new_AAT_ATTRIBUTE19,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE2',
p_old_AAT_ATTRIBUTE2,
p_new_AAT_ATTRIBUTE2,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE20',
p_old_AAT_ATTRIBUTE20,
p_new_AAT_ATTRIBUTE20,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE3',
p_old_AAT_ATTRIBUTE3,
p_new_AAT_ATTRIBUTE3,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE4',
p_old_AAT_ATTRIBUTE4,
p_new_AAT_ATTRIBUTE4,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE5',
p_old_AAT_ATTRIBUTE5,
p_new_AAT_ATTRIBUTE5,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE6',
p_old_AAT_ATTRIBUTE6,
p_new_AAT_ATTRIBUTE6,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE7',
p_old_AAT_ATTRIBUTE7,
p_new_AAT_ATTRIBUTE7,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE8',
p_old_AAT_ATTRIBUTE8,
p_new_AAT_ATTRIBUTE8,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE9',
p_old_AAT_ATTRIBUTE9,
p_new_AAT_ATTRIBUTE9,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_ATTRIBUTE_CATEGORY',
p_old_AAT_ATTRIBUTE_CATEGORY,
p_new_AAT_ATTRIBUTE_CATEGORY,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION1',
p_old_AAT_INFORMATION1,
p_new_AAT_INFORMATION1,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION10',
p_old_AAT_INFORMATION10,
p_new_AAT_INFORMATION10,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION11',
p_old_AAT_INFORMATION11,
p_new_AAT_INFORMATION11,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION12',
p_old_AAT_INFORMATION12,
p_new_AAT_INFORMATION12,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION13',
p_old_AAT_INFORMATION13,
p_new_AAT_INFORMATION13,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION14',
p_old_AAT_INFORMATION14,
p_new_AAT_INFORMATION14,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION15',
p_old_AAT_INFORMATION15,
p_new_AAT_INFORMATION15,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION16',
p_old_AAT_INFORMATION16,
p_new_AAT_INFORMATION16,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION17',
p_old_AAT_INFORMATION17,
p_new_AAT_INFORMATION17,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION18',
p_old_AAT_INFORMATION18,
p_new_AAT_INFORMATION18,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION19',
p_old_AAT_INFORMATION19,
p_new_AAT_INFORMATION19,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION2',
p_old_AAT_INFORMATION2,
p_new_AAT_INFORMATION2,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION20',
p_old_AAT_INFORMATION20,
p_new_AAT_INFORMATION20,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION3',
p_old_AAT_INFORMATION3,
p_new_AAT_INFORMATION3,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION4',
p_old_AAT_INFORMATION4,
p_new_AAT_INFORMATION4,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION5',
p_old_AAT_INFORMATION5,
p_new_AAT_INFORMATION5,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION6',
p_old_AAT_INFORMATION6,
p_new_AAT_INFORMATION6,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION7',
p_old_AAT_INFORMATION7,
p_new_AAT_INFORMATION7,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION8',
p_old_AAT_INFORMATION8,
p_new_AAT_INFORMATION8,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION9',
p_old_AAT_INFORMATION9,
p_new_AAT_INFORMATION9,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'AAT_INFORMATION_CATEGORY',
p_old_AAT_INFORMATION_CATEGORY,
p_new_AAT_INFORMATION_CATEGORY,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'ASSIGNMENT_ATTRIBUTE_ID',
p_old_ASSIGNMENT_ATTRIBUTE_ID,
p_new_ASSIGNMENT_ATTRIBUTE_ID,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'ASSIGNMENT_ID',
p_old_ASSIGNMENT_ID,
p_new_ASSIGNMENT_ID,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'BUSINESS_GROUP_ID',
p_old_BUSINESS_GROUP_ID,
p_new_BUSINESS_GROUP_ID,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'COMPANY_CAR_CALC_METHOD',
p_old_COMPANY_CAR_CALC_METHOD,
p_new_COMPANY_CAR_CALC_METHOD,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'COMPANY_CAR_RATES_TABLE_ID',
p_old_COMPANY_CAR_RATES_TABLE_,
p_new_COMPANY_CAR_RATES_TABLE_,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'COMPANY_CAR_SECONDARY_TABLE_ID',
p_old_COMPANY_CAR_SECONDARY_TA,
p_new_COMPANY_CAR_SECONDARY_TA,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'CONTRACT_TYPE',
p_old_CONTRACT_TYPE,
p_new_CONTRACT_TYPE,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'PRIMARY_CAPITAL_CONTRIBUTION',
p_old_PRIMARY_CAPITAL_CONTRIBU,
p_new_PRIMARY_CAPITAL_CONTRIBU,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'PRIMARY_CAR_FUEL_BENEFIT',
p_old_PRIMARY_CAR_FUEL_BENEFIT,
p_new_PRIMARY_CAR_FUEL_BENEFIT,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'PRIMARY_CLASS_1A',
p_old_PRIMARY_CLASS_1A,
p_new_PRIMARY_CLASS_1A,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'PRIMARY_COMPANY_CAR',
p_old_PRIMARY_COMPANY_CAR,
p_new_PRIMARY_COMPANY_CAR,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'PRIMARY_PRIVATE_CONTRIBUTION',
p_old_PRIMARY_PRIVATE_CONTRIBU,
p_new_PRIMARY_PRIVATE_CONTRIBU,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'PRIVATE_CAR',
p_old_PRIVATE_CAR,
p_new_PRIVATE_CAR,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'PRIVATE_CAR_CALC_METHOD',
p_old_PRIVATE_CAR_CALC_METHOD,
p_new_PRIVATE_CAR_CALC_METHOD,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'PRIVATE_CAR_ESSENTIAL_TABLE_ID',
p_old_PRIVATE_CAR_ESSENTIAL_TA,
p_new_PRIVATE_CAR_ESSENTIAL_TA,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'PRIVATE_CAR_RATES_TABLE_ID',
p_old_PRIVATE_CAR_RATES_TABLE_,
p_new_PRIVATE_CAR_RATES_TABLE_,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'SECONDARY_CAPITAL_CONTRIBUTION',
p_old_SECONDARY_CAPITAL_CONTRI,
p_new_SECONDARY_CAPITAL_CONTRI,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'SECONDARY_CAR_FUEL_BENEFIT',
p_old_SECONDARY_CAR_FUEL_BENEF,
p_new_SECONDARY_CAR_FUEL_BENEF,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'SECONDARY_CLASS_1A',
p_old_SECONDARY_CLASS_1A,
p_new_SECONDARY_CLASS_1A,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'SECONDARY_COMPANY_CAR',
p_old_SECONDARY_COMPANY_CAR,
p_new_SECONDARY_COMPANY_CAR,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'SECONDARY_PRIVATE_CONTRIBUTION',
p_old_SECONDARY_PRIVATE_CONTRI,
p_new_SECONDARY_PRIVATE_CONTRI,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'START_DAY',
p_old_START_DAY,
p_new_START_DAY,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'TP_ELECTED_PENSION',
p_old_TP_ELECTED_PENSION,
p_new_TP_ELECTED_PENSION,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'TP_FAST_TRACK',
p_old_TP_FAST_TRACK,
p_new_TP_FAST_TRACK,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'TP_IS_TEACHER',
p_old_TP_IS_TEACHER,
p_new_TP_IS_TEACHER,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'TP_SAFEGUARDED_GRADE',
p_old_TP_SAFEGUARDED_GRADE,
p_new_TP_SAFEGUARDED_GRADE,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'TP_SAFEGUARDED_RATE_ID',
p_old_TP_SAFEGUARDED_RATE_ID,
p_new_TP_SAFEGUARDED_RATE_ID,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'TP_SAFEGUARDED_RATE_TYPE',
p_old_TP_SAFEGUARDED_RATE_TYPE,
p_new_TP_SAFEGUARDED_RATE_TYPE,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'TP_SAFEGUARDED_SPINAL_POINT_ID',
p_old_TP_SAFEGUARDED_SPINAL_PO,
p_new_TP_SAFEGUARDED_SPINAL_PO,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'WORK_PATTERN',
p_old_WORK_PATTERN,
p_new_WORK_PATTERN,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'WORK_PATTERN',
p_old_WORK_PATTERN,
p_new_WORK_PATTERN,
p_effective_date
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'EFFECTIVE_END_DATE',
p_old_EFFECTIVE_END_DATE,
p_new_EFFECTIVE_END_DATE,
p_new_effective_end_date,
least(p_old_effective_end_date,
p_new_effective_end_date)
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
'EFFECTIVE_START_DATE',
p_old_EFFECTIVE_START_DATE,
p_new_EFFECTIVE_START_DATE,
p_new_effective_start_date,
least(p_old_effective_start_date,
p_new_effective_start_date)
);
p_event_update_id => pay_continuous_calc.g_event_list.event_update_id(cnt),
p_business_group_id => p_business_group_id,
p_calculation_date => pay_continuous_calc.g_event_list.calc_date(cnt),
p_surrogate_key => p_new_assignment_attribute_id
);
pay_continuous_calc.event_update
(p_business_group_id
,p_legislation_code
,'PQP_ASSIGNMENT_ATTRIBUTES_F'
,NULL
,NULL
,NULL
,p_new_effective_start_date
,p_new_effective_start_date
,'I'
);
,p_event_update_id =>
pay_continuous_calc.g_event_list.event_update_id(cnt)
,p_surrogate_key => p_new_assignment_attribute_id
,p_calculation_date =>
pay_continuous_calc.g_event_list.calc_date(cnt)
,p_business_group_id => p_business_group_id
);
pay_continuous_calc.event_update(p_business_group_id,
p_legislation_code,
'PQP_ASSIGNMENT_ATTRIBUTES_F',
null,
null,
null,
p_old_effective_start_date,
p_old_effective_start_date,
'D' --l_mode
);
p_event_update_id => pay_continuous_calc.g_event_list.event_update_id(cnt),
p_surrogate_key => p_old_assignment_attribute_id,
p_calculation_date => pay_continuous_calc.g_event_list.calc_date(cnt),
p_business_group_id => p_business_group_id
);