eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_CONT_CALC SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19


   purpose : This is procedure that records any changes for updates
             on Federal Tax Information.
*/
procedure PAY_CA_EMP_FED_TAX_INFO_F_aru(
p_business_group_id in number,
p_legislation_code in varchar2,
p_effective_date in date ,
p_old_ADDITIONAL_TAX in NUMBER,
p_new_ADDITIONAL_TAX in NUMBER ,
p_old_ANNUAL_DEDN in NUMBER,
p_new_ANNUAL_DEDN in NUMBER ,
p_old_ASSIGNMENT_ID in NUMBER,
p_new_ASSIGNMENT_ID in NUMBER ,
p_old_BASIC_EXEMPTION_FLAG in VARCHAR2,
p_new_BASIC_EXEMPTION_FLAG in VARCHAR2 ,
p_old_BUSINESS_GROUP_ID in NUMBER,
p_new_BUSINESS_GROUP_ID in NUMBER ,
p_old_CA_TAX_INFORMATION1 in VARCHAR2,
p_new_CA_TAX_INFORMATION1 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION10 in VARCHAR2,
p_new_CA_TAX_INFORMATION10 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION11 in VARCHAR2,
p_new_CA_TAX_INFORMATION11 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION12 in VARCHAR2,
p_new_CA_TAX_INFORMATION12 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION13 in VARCHAR2,
p_new_CA_TAX_INFORMATION13 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION14 in VARCHAR2,
p_new_CA_TAX_INFORMATION14 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION15 in VARCHAR2,
p_new_CA_TAX_INFORMATION15 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION16 in VARCHAR2,
p_new_CA_TAX_INFORMATION16 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION17 in VARCHAR2,
p_new_CA_TAX_INFORMATION17 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION18 in VARCHAR2,
p_new_CA_TAX_INFORMATION18 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION19 in VARCHAR2,
p_new_CA_TAX_INFORMATION19 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION2 in VARCHAR2,
p_new_CA_TAX_INFORMATION2 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION20 in VARCHAR2,
p_new_CA_TAX_INFORMATION20 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION21 in VARCHAR2,
p_new_CA_TAX_INFORMATION21 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION22 in VARCHAR2,
p_new_CA_TAX_INFORMATION22 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION23 in VARCHAR2,
p_new_CA_TAX_INFORMATION23 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION24 in VARCHAR2,
p_new_CA_TAX_INFORMATION24 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION25 in VARCHAR2,
p_new_CA_TAX_INFORMATION25 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION26 in VARCHAR2,
p_new_CA_TAX_INFORMATION26 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION27 in VARCHAR2,
p_new_CA_TAX_INFORMATION27 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION28 in VARCHAR2,
p_new_CA_TAX_INFORMATION28 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION29 in VARCHAR2,
p_new_CA_TAX_INFORMATION29 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION3 in VARCHAR2,
p_new_CA_TAX_INFORMATION3 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION30 in VARCHAR2,
p_new_CA_TAX_INFORMATION30 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION4 in VARCHAR2,
p_new_CA_TAX_INFORMATION4 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION5 in VARCHAR2,
p_new_CA_TAX_INFORMATION5 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION6 in VARCHAR2,
p_new_CA_TAX_INFORMATION6 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION7 in VARCHAR2,
p_new_CA_TAX_INFORMATION7 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION8 in VARCHAR2,
p_new_CA_TAX_INFORMATION8 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION9 in VARCHAR2,
p_new_CA_TAX_INFORMATION9 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION_CATEG in VARCHAR2,
p_new_CA_TAX_INFORMATION_CATEG in VARCHAR2 ,
p_old_CLAIM_CODE in VARCHAR2,
p_new_CLAIM_CODE in VARCHAR2 ,
p_old_CPP_QPP_EXEMPT_FLAG in VARCHAR2,
p_new_CPP_QPP_EXEMPT_FLAG in VARCHAR2 ,
p_old_EI_EXEMPT_FLAG in VARCHAR2,
p_new_EI_EXEMPT_FLAG in VARCHAR2 ,
p_old_EMPLOYMENT_PROVINCE in VARCHAR2,
p_new_EMPLOYMENT_PROVINCE in VARCHAR2 ,
p_old_EMP_FED_TAX_INF_ID in NUMBER,
p_new_EMP_FED_TAX_INF_ID in NUMBER ,
p_old_FED_EXEMPT_FLAG in VARCHAR2,
p_new_FED_EXEMPT_FLAG in VARCHAR2 ,
p_old_FED_OVERRIDE_AMOUNT in NUMBER,
p_new_FED_OVERRIDE_AMOUNT in NUMBER ,
p_old_FED_OVERRIDE_RATE in NUMBER,
p_new_FED_OVERRIDE_RATE in NUMBER ,
p_old_LEGISLATION_CODE in VARCHAR2,
p_new_LEGISLATION_CODE in VARCHAR2 ,
p_old_OTHER_FEDTAX_CREDITS in NUMBER,
p_new_OTHER_FEDTAX_CREDITS in NUMBER ,
p_old_PRESCRIBED_ZONE_DEDN_AMT in NUMBER,
p_new_PRESCRIBED_ZONE_DEDN_AMT in NUMBER ,
p_old_TAX_CALC_METHOD in VARCHAR2,
p_new_TAX_CALC_METHOD in VARCHAR2 ,
p_old_TAX_CREDIT_AMOUNT in NUMBER,
p_new_TAX_CREDIT_AMOUNT in NUMBER ,
p_old_TOTAL_EXPENSE_BY_COMMISS in NUMBER,
p_new_TOTAL_EXPENSE_BY_COMMISS in NUMBER ,
p_old_TOTAL_REMNRTN_BY_COMMISS in NUMBER,
p_new_TOTAL_REMNRTN_BY_COMMISS in NUMBER ,
p_old_EFFECTIVE_END_DATE in DATE,
p_new_EFFECTIVE_END_DATE in DATE ,
p_old_EFFECTIVE_START_DATE in DATE,
p_new_EFFECTIVE_START_DATE in DATE
)
is
--
begin
  /* If the continuous calc is overriden then do nothing */
  if (pay_continuous_calc.g_override_cc = TRUE) then
    return;

Line: 145


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'ADDITIONAL_TAX',
                                     p_old_ADDITIONAL_TAX,
                                     p_new_ADDITIONAL_TAX,
                                     p_effective_date
                                  );

Line: 154


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'ANNUAL_DEDN',
                                     p_old_ANNUAL_DEDN,
                                     p_new_ANNUAL_DEDN,
                                     p_effective_date
                                  );

Line: 163


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'ASSIGNMENT_ID',
                                     p_old_ASSIGNMENT_ID,
                                     p_new_ASSIGNMENT_ID,
                                     p_effective_date
                                  );

Line: 172


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'BASIC_EXEMPTION_FLAG',
                                     p_old_BASIC_EXEMPTION_FLAG,
                                     p_new_BASIC_EXEMPTION_FLAG,
                                     p_effective_date
                                  );

Line: 181


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'BUSINESS_GROUP_ID',
                                     p_old_BUSINESS_GROUP_ID,
                                     p_new_BUSINESS_GROUP_ID,
                                     p_effective_date
                                  );

Line: 190


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION1',
                                     p_old_CA_TAX_INFORMATION1,
                                     p_new_CA_TAX_INFORMATION1,
                                     p_effective_date
                                  );

Line: 199


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION10',
                                     p_old_CA_TAX_INFORMATION10,
                                     p_new_CA_TAX_INFORMATION10,
                                     p_effective_date
                                  );

Line: 208


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION11',
                                     p_old_CA_TAX_INFORMATION11,
                                     p_new_CA_TAX_INFORMATION11,
                                     p_effective_date
                                  );

Line: 217


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION12',
                                     p_old_CA_TAX_INFORMATION12,
                                     p_new_CA_TAX_INFORMATION12,
                                     p_effective_date
                                  );

Line: 226


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION13',
                                     p_old_CA_TAX_INFORMATION13,
                                     p_new_CA_TAX_INFORMATION13,
                                     p_effective_date
                                  );

Line: 235


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION14',
                                     p_old_CA_TAX_INFORMATION14,
                                     p_new_CA_TAX_INFORMATION14,
                                     p_effective_date
                                  );

Line: 244


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION15',
                                     p_old_CA_TAX_INFORMATION15,
                                     p_new_CA_TAX_INFORMATION15,
                                     p_effective_date
                                  );

Line: 253


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION16',
                                     p_old_CA_TAX_INFORMATION16,
                                     p_new_CA_TAX_INFORMATION16,
                                     p_effective_date
                                  );

Line: 262


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION17',
                                     p_old_CA_TAX_INFORMATION17,
                                     p_new_CA_TAX_INFORMATION17,
                                     p_effective_date
                                  );

Line: 271


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION18',
                                     p_old_CA_TAX_INFORMATION18,
                                     p_new_CA_TAX_INFORMATION18,
                                     p_effective_date
                                  );

Line: 280


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION19',
                                     p_old_CA_TAX_INFORMATION19,
                                     p_new_CA_TAX_INFORMATION19,
                                     p_effective_date
                                  );

Line: 289


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION2',
                                     p_old_CA_TAX_INFORMATION2,
                                     p_new_CA_TAX_INFORMATION2,
                                     p_effective_date
                                  );

Line: 298


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION20',
                                     p_old_CA_TAX_INFORMATION20,
                                     p_new_CA_TAX_INFORMATION20,
                                     p_effective_date
                                  );

Line: 307


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION21',
                                     p_old_CA_TAX_INFORMATION21,
                                     p_new_CA_TAX_INFORMATION21,
                                     p_effective_date
                                  );

Line: 316


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION22',
                                     p_old_CA_TAX_INFORMATION22,
                                     p_new_CA_TAX_INFORMATION22,
                                     p_effective_date
                                  );

Line: 325


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION23',
                                     p_old_CA_TAX_INFORMATION23,
                                     p_new_CA_TAX_INFORMATION23,
                                     p_effective_date
                                  );

Line: 334


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION24',
                                     p_old_CA_TAX_INFORMATION24,
                                     p_new_CA_TAX_INFORMATION24,
                                     p_effective_date
                                  );

Line: 343


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION25',
                                     p_old_CA_TAX_INFORMATION25,
                                     p_new_CA_TAX_INFORMATION25,
                                     p_effective_date
                                  );

Line: 352


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION26',
                                     p_old_CA_TAX_INFORMATION26,
                                     p_new_CA_TAX_INFORMATION26,
                                     p_effective_date
                                  );

Line: 361


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION27',
                                     p_old_CA_TAX_INFORMATION27,
                                     p_new_CA_TAX_INFORMATION27,
                                     p_effective_date
                                  );

Line: 370


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION28',
                                     p_old_CA_TAX_INFORMATION28,
                                     p_new_CA_TAX_INFORMATION28,
                                     p_effective_date
                                  );

Line: 379


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION29',
                                     p_old_CA_TAX_INFORMATION29,
                                     p_new_CA_TAX_INFORMATION29,
                                     p_effective_date
                                  );

Line: 388


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION3',
                                     p_old_CA_TAX_INFORMATION3,
                                     p_new_CA_TAX_INFORMATION3,
                                     p_effective_date
                                  );

Line: 397


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION30',
                                     p_old_CA_TAX_INFORMATION30,
                                     p_new_CA_TAX_INFORMATION30,
                                     p_effective_date
                                  );

Line: 406


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION4',
                                     p_old_CA_TAX_INFORMATION4,
                                     p_new_CA_TAX_INFORMATION4,
                                     p_effective_date
                                  );

Line: 415


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION5',
                                     p_old_CA_TAX_INFORMATION5,
                                     p_new_CA_TAX_INFORMATION5,
                                     p_effective_date
                                  );

Line: 424


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION6',
                                     p_old_CA_TAX_INFORMATION6,
                                     p_new_CA_TAX_INFORMATION6,
                                     p_effective_date
                                  );

Line: 433


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION7',
                                     p_old_CA_TAX_INFORMATION7,
                                     p_new_CA_TAX_INFORMATION7,
                                     p_effective_date
                                  );

Line: 442


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION8',
                                     p_old_CA_TAX_INFORMATION8,
                                     p_new_CA_TAX_INFORMATION8,
                                     p_effective_date
                                  );

Line: 451


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION9',
                                     p_old_CA_TAX_INFORMATION9,
                                     p_new_CA_TAX_INFORMATION9,
                                     p_effective_date
                                  );

Line: 460


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CA_TAX_INFORMATION_CATEGORY',
                                     p_old_CA_TAX_INFORMATION_CATEG,
                                     p_new_CA_TAX_INFORMATION_CATEG,
                                     p_effective_date
                                  );

Line: 469


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CLAIM_CODE',
                                     p_old_CLAIM_CODE,
                                     p_new_CLAIM_CODE,
                                     p_effective_date
                                  );

Line: 478


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'CPP_QPP_EXEMPT_FLAG',
                                     p_old_CPP_QPP_EXEMPT_FLAG,
                                     p_new_CPP_QPP_EXEMPT_FLAG,
                                     p_effective_date
                                  );

Line: 487


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'EI_EXEMPT_FLAG',
                                     p_old_EI_EXEMPT_FLAG,
                                     p_new_EI_EXEMPT_FLAG,
                                     p_effective_date
                                  );

Line: 496


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'EMPLOYMENT_PROVINCE',
                                     p_old_EMPLOYMENT_PROVINCE,
                                     p_new_EMPLOYMENT_PROVINCE,
                                     p_effective_date
                                  );

Line: 505


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'EMP_FED_TAX_INF_ID',
                                     p_old_EMP_FED_TAX_INF_ID,
                                     p_new_EMP_FED_TAX_INF_ID,
                                     p_effective_date
                                  );

Line: 514


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'FED_EXEMPT_FLAG',
                                     p_old_FED_EXEMPT_FLAG,
                                     p_new_FED_EXEMPT_FLAG,
                                     p_effective_date
                                  );

Line: 523


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'FED_OVERRIDE_AMOUNT',
                                     p_old_FED_OVERRIDE_AMOUNT,
                                     p_new_FED_OVERRIDE_AMOUNT,
                                     p_effective_date
                                  );

Line: 532


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'FED_OVERRIDE_RATE',
                                     p_old_FED_OVERRIDE_RATE,
                                     p_new_FED_OVERRIDE_RATE,
                                     p_effective_date
                                  );

Line: 541


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'LEGISLATION_CODE',
                                     p_old_LEGISLATION_CODE,
                                     p_new_LEGISLATION_CODE,
                                     p_effective_date
                                  );

Line: 550


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'OTHER_FEDTAX_CREDITS',
                                     p_old_OTHER_FEDTAX_CREDITS,
                                     p_new_OTHER_FEDTAX_CREDITS,
                                     p_effective_date
                                  );

Line: 559


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'PRESCRIBED_ZONE_DEDN_AMT',
                                     p_old_PRESCRIBED_ZONE_DEDN_AMT,
                                     p_new_PRESCRIBED_ZONE_DEDN_AMT,
                                     p_effective_date
                                  );

Line: 568


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'TAX_CALC_METHOD',
                                     p_old_TAX_CALC_METHOD,
                                     p_new_TAX_CALC_METHOD,
                                     p_effective_date
                                  );

Line: 577


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'TAX_CREDIT_AMOUNT',
                                     p_old_TAX_CREDIT_AMOUNT,
                                     p_new_TAX_CREDIT_AMOUNT,
                                     p_effective_date
                                  );

Line: 586


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'TOTAL_EXPENSE_BY_COMMISSION',
                                     p_old_TOTAL_EXPENSE_BY_COMMISS,
                                     p_new_TOTAL_EXPENSE_BY_COMMISS,
                                     p_effective_date
                                  );

Line: 595


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'TOTAL_REMNRTN_BY_COMMISSION',
                                     p_old_TOTAL_REMNRTN_BY_COMMISS,
                                     p_new_TOTAL_REMNRTN_BY_COMMISS,
                                     p_effective_date
                                  );

Line: 604


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_F',
                                     'TOTAL_REMNRTN_BY_COMMISSION',
                                     p_old_TOTAL_REMNRTN_BY_COMMISS,
                                     p_new_TOTAL_REMNRTN_BY_COMMISS,
                                     p_effective_date
                                  );

Line: 615


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_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)
                                  );

Line: 626


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_FED_TAX_INFO_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)
                                  );

Line: 655


                                            p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
                                            p_business_group_id     => p_business_group_id,
                                            p_surrogate_key         => p_old_EMP_FED_TAX_INF_ID
                                           );

Line: 667


   purpose : This is procedure that records any changes for updates
             on Povincial Tax Information.
*/
--
procedure PAY_CA_EMP_PROV_TAX_INFO_F_aru(
p_business_group_id in number,
p_legislation_code in varchar2,
p_effective_date in date ,
p_old_ADDITIONAL_TAX in NUMBER,
p_new_ADDITIONAL_TAX in NUMBER ,
p_old_ANNUAL_DEDN in NUMBER,
p_new_ANNUAL_DEDN in NUMBER ,
p_old_ASSIGNMENT_ID in NUMBER,
p_new_ASSIGNMENT_ID in NUMBER ,
p_old_BASIC_EXEMPTION_FLAG in VARCHAR2,
p_new_BASIC_EXEMPTION_FLAG in VARCHAR2 ,
p_old_BUSINESS_GROUP_ID in NUMBER,
p_new_BUSINESS_GROUP_ID in NUMBER ,
p_old_CA_TAX_INFORMATION1 in VARCHAR2,
p_new_CA_TAX_INFORMATION1 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION10 in VARCHAR2,
p_new_CA_TAX_INFORMATION10 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION11 in VARCHAR2,
p_new_CA_TAX_INFORMATION11 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION12 in VARCHAR2,
p_new_CA_TAX_INFORMATION12 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION13 in VARCHAR2,
p_new_CA_TAX_INFORMATION13 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION14 in VARCHAR2,
p_new_CA_TAX_INFORMATION14 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION15 in VARCHAR2,
p_new_CA_TAX_INFORMATION15 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION16 in VARCHAR2,
p_new_CA_TAX_INFORMATION16 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION17 in VARCHAR2,
p_new_CA_TAX_INFORMATION17 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION18 in VARCHAR2,
p_new_CA_TAX_INFORMATION18 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION19 in VARCHAR2,
p_new_CA_TAX_INFORMATION19 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION2 in VARCHAR2,
p_new_CA_TAX_INFORMATION2 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION20 in VARCHAR2,
p_new_CA_TAX_INFORMATION20 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION21 in VARCHAR2,
p_new_CA_TAX_INFORMATION21 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION22 in VARCHAR2,
p_new_CA_TAX_INFORMATION22 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION23 in VARCHAR2,
p_new_CA_TAX_INFORMATION23 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION24 in VARCHAR2,
p_new_CA_TAX_INFORMATION24 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION25 in VARCHAR2,
p_new_CA_TAX_INFORMATION25 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION26 in VARCHAR2,
p_new_CA_TAX_INFORMATION26 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION27 in VARCHAR2,
p_new_CA_TAX_INFORMATION27 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION28 in VARCHAR2,
p_new_CA_TAX_INFORMATION28 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION29 in VARCHAR2,
p_new_CA_TAX_INFORMATION29 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION3 in VARCHAR2,
p_new_CA_TAX_INFORMATION3 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION30 in VARCHAR2,
p_new_CA_TAX_INFORMATION30 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION4 in VARCHAR2,
p_new_CA_TAX_INFORMATION4 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION5 in VARCHAR2,
p_new_CA_TAX_INFORMATION5 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION6 in VARCHAR2,
p_new_CA_TAX_INFORMATION6 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION7 in VARCHAR2,
p_new_CA_TAX_INFORMATION7 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION8 in VARCHAR2,
p_new_CA_TAX_INFORMATION8 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION9 in VARCHAR2,
p_new_CA_TAX_INFORMATION9 in VARCHAR2 ,
p_old_CA_TAX_INFORMATION_CATEG in VARCHAR2,
p_new_CA_TAX_INFORMATION_CATEG in VARCHAR2 ,
p_old_DEDUCTION_CODE in VARCHAR2,
p_new_DEDUCTION_CODE in VARCHAR2 ,
p_old_DISABILITY_STATUS in VARCHAR2,
p_new_DISABILITY_STATUS in VARCHAR2 ,
p_old_EMP_PROVINCE_TAX_INF_ID in NUMBER,
p_new_EMP_PROVINCE_TAX_INF_ID in NUMBER ,
p_old_EXTRA_INFO_NOT_PROVIDED in VARCHAR2,
p_new_EXTRA_INFO_NOT_PROVIDED in VARCHAR2 ,
p_old_JURISDICTION_CODE in VARCHAR2,
p_new_JURISDICTION_CODE in VARCHAR2 ,
p_old_LEGISLATION_CODE in VARCHAR2,
p_new_LEGISLATION_CODE in VARCHAR2 ,
p_old_MARRIAGE_STATUS in VARCHAR2,
p_new_MARRIAGE_STATUS in VARCHAR2 ,
p_old_NON_RESIDENT_STATUS in VARCHAR2,
p_new_NON_RESIDENT_STATUS in VARCHAR2 ,
p_old_NO_OF_DEPENDANTS in NUMBER,
p_new_NO_OF_DEPENDANTS in NUMBER ,
p_old_NO_OF_INFIRM_DEPENDANTS in NUMBER,
p_new_NO_OF_INFIRM_DEPENDANTS in NUMBER ,
p_old_OTHER_TAX_CREDIT in NUMBER,
p_new_OTHER_TAX_CREDIT in NUMBER ,
p_old_PMED_EXEMPT_FLAG in VARCHAR2,
p_new_PMED_EXEMPT_FLAG in VARCHAR2 ,
p_old_PRESCRIBED_ZONE_DEDN_AMT in NUMBER,
p_new_PRESCRIBED_ZONE_DEDN_AMT in NUMBER ,
p_old_PROVINCE_CODE in VARCHAR2,
p_new_PROVINCE_CODE in VARCHAR2 ,
p_old_PROV_EXEMPT_FLAG in VARCHAR2,
p_new_PROV_EXEMPT_FLAG in VARCHAR2 ,
p_old_PROV_OVERRIDE_AMOUNT in NUMBER,
p_new_PROV_OVERRIDE_AMOUNT in NUMBER ,
p_old_PROV_OVERRIDE_RATE in NUMBER,
p_new_PROV_OVERRIDE_RATE in NUMBER ,
p_old_QPP_EXEMPT_FLAG in VARCHAR2,
p_new_QPP_EXEMPT_FLAG in VARCHAR2 ,
p_old_TAX_CALC_METHOD in VARCHAR2,
p_new_TAX_CALC_METHOD in VARCHAR2 ,
p_old_TAX_CREDIT_AMOUNT in NUMBER,
p_new_TAX_CREDIT_AMOUNT in NUMBER ,
p_old_TOTAL_EXPENSE_BY_COMMISS in NUMBER,
p_new_TOTAL_EXPENSE_BY_COMMISS in NUMBER ,
p_old_TOTAL_REMNRTN_BY_COMMISS in NUMBER,
p_new_TOTAL_REMNRTN_BY_COMMISS in NUMBER ,
p_old_WC_EXEMPT_FLAG in VARCHAR2,
p_new_WC_EXEMPT_FLAG in VARCHAR2 ,
p_old_EFFECTIVE_END_DATE in DATE,
p_new_EFFECTIVE_END_DATE in DATE ,
p_old_EFFECTIVE_START_DATE in DATE,
p_new_EFFECTIVE_START_DATE in DATE
)
is
--
begin
  /* If the continuous calc is overriden then do nothing */
  if (pay_continuous_calc.g_override_cc = TRUE) then
    return;

Line: 810


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'ADDITIONAL_TAX',
                                     p_old_ADDITIONAL_TAX,
                                     p_new_ADDITIONAL_TAX,
                                     p_effective_date
                                  );

Line: 819


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'ANNUAL_DEDN',
                                     p_old_ANNUAL_DEDN,
                                     p_new_ANNUAL_DEDN,
                                     p_effective_date
                                  );

Line: 828


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'ASSIGNMENT_ID',
                                     p_old_ASSIGNMENT_ID,
                                     p_new_ASSIGNMENT_ID,
                                     p_effective_date
                                  );

Line: 837


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'BASIC_EXEMPTION_FLAG',
                                     p_old_BASIC_EXEMPTION_FLAG,
                                     p_new_BASIC_EXEMPTION_FLAG,
                                     p_effective_date
                                  );

Line: 846


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'BUSINESS_GROUP_ID',
                                     p_old_BUSINESS_GROUP_ID,
                                     p_new_BUSINESS_GROUP_ID,
                                     p_effective_date
                                  );

Line: 855


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION1',
                                     p_old_CA_TAX_INFORMATION1,
                                     p_new_CA_TAX_INFORMATION1,
                                     p_effective_date
                                  );

Line: 864


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION10',
                                     p_old_CA_TAX_INFORMATION10,
                                     p_new_CA_TAX_INFORMATION10,
                                     p_effective_date
                                  );

Line: 873


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION11',
                                     p_old_CA_TAX_INFORMATION11,
                                     p_new_CA_TAX_INFORMATION11,
                                     p_effective_date
                                  );

Line: 882


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION12',
                                     p_old_CA_TAX_INFORMATION12,
                                     p_new_CA_TAX_INFORMATION12,
                                     p_effective_date
                                  );

Line: 891


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION13',
                                     p_old_CA_TAX_INFORMATION13,
                                     p_new_CA_TAX_INFORMATION13,
                                     p_effective_date
                                  );

Line: 900


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION14',
                                     p_old_CA_TAX_INFORMATION14,
                                     p_new_CA_TAX_INFORMATION14,
                                     p_effective_date
                                  );

Line: 909


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION15',
                                     p_old_CA_TAX_INFORMATION15,
                                     p_new_CA_TAX_INFORMATION15,
                                     p_effective_date
                                  );

Line: 918


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION16',
                                     p_old_CA_TAX_INFORMATION16,
                                     p_new_CA_TAX_INFORMATION16,
                                     p_effective_date
                                  );

Line: 927


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION17',
                                     p_old_CA_TAX_INFORMATION17,
                                     p_new_CA_TAX_INFORMATION17,
                                     p_effective_date
                                  );

Line: 936


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION18',
                                     p_old_CA_TAX_INFORMATION18,
                                     p_new_CA_TAX_INFORMATION18,
                                     p_effective_date
                                  );

Line: 945


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION19',
                                     p_old_CA_TAX_INFORMATION19,
                                     p_new_CA_TAX_INFORMATION19,
                                     p_effective_date
                                  );

Line: 954


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION2',
                                     p_old_CA_TAX_INFORMATION2,
                                     p_new_CA_TAX_INFORMATION2,
                                     p_effective_date
                                  );

Line: 963


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION20',
                                     p_old_CA_TAX_INFORMATION20,
                                     p_new_CA_TAX_INFORMATION20,
                                     p_effective_date
                                  );

Line: 972


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION21',
                                     p_old_CA_TAX_INFORMATION21,
                                     p_new_CA_TAX_INFORMATION21,
                                     p_effective_date
                                  );

Line: 981


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION22',
                                     p_old_CA_TAX_INFORMATION22,
                                     p_new_CA_TAX_INFORMATION22,
                                     p_effective_date
                                  );

Line: 990


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION23',
                                     p_old_CA_TAX_INFORMATION23,
                                     p_new_CA_TAX_INFORMATION23,
                                     p_effective_date
                                  );

Line: 999


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION24',
                                     p_old_CA_TAX_INFORMATION24,
                                     p_new_CA_TAX_INFORMATION24,
                                     p_effective_date
                                  );

Line: 1008


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION25',
                                     p_old_CA_TAX_INFORMATION25,
                                     p_new_CA_TAX_INFORMATION25,
                                     p_effective_date
                                  );

Line: 1017


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION26',
                                     p_old_CA_TAX_INFORMATION26,
                                     p_new_CA_TAX_INFORMATION26,
                                     p_effective_date
                                  );

Line: 1026


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION27',
                                     p_old_CA_TAX_INFORMATION27,
                                     p_new_CA_TAX_INFORMATION27,
                                     p_effective_date
                                  );

Line: 1035


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION28',
                                     p_old_CA_TAX_INFORMATION28,
                                     p_new_CA_TAX_INFORMATION28,
                                     p_effective_date
                                  );

Line: 1044


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION29',
                                     p_old_CA_TAX_INFORMATION29,
                                     p_new_CA_TAX_INFORMATION29,
                                     p_effective_date
                                  );

Line: 1053


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION3',
                                     p_old_CA_TAX_INFORMATION3,
                                     p_new_CA_TAX_INFORMATION3,
                                     p_effective_date
                                  );

Line: 1062


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION30',
                                     p_old_CA_TAX_INFORMATION30,
                                     p_new_CA_TAX_INFORMATION30,
                                     p_effective_date
                                  );

Line: 1071


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION4',
                                     p_old_CA_TAX_INFORMATION4,
                                     p_new_CA_TAX_INFORMATION4,
                                     p_effective_date
                                  );

Line: 1080


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION5',
                                     p_old_CA_TAX_INFORMATION5,
                                     p_new_CA_TAX_INFORMATION5,
                                     p_effective_date
                                  );

Line: 1089


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION6',
                                     p_old_CA_TAX_INFORMATION6,
                                     p_new_CA_TAX_INFORMATION6,
                                     p_effective_date
                                  );

Line: 1098


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION7',
                                     p_old_CA_TAX_INFORMATION7,
                                     p_new_CA_TAX_INFORMATION7,
                                     p_effective_date
                                  );

Line: 1107


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION8',
                                     p_old_CA_TAX_INFORMATION8,
                                     p_new_CA_TAX_INFORMATION8,
                                     p_effective_date
                                  );

Line: 1116


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION9',
                                     p_old_CA_TAX_INFORMATION9,
                                     p_new_CA_TAX_INFORMATION9,
                                     p_effective_date
                                  );

Line: 1125


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'CA_TAX_INFORMATION_CATEGORY',
                                     p_old_CA_TAX_INFORMATION_CATEG,
                                     p_new_CA_TAX_INFORMATION_CATEG,
                                     p_effective_date
                                  );

Line: 1134


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'DEDUCTION_CODE',
                                     p_old_DEDUCTION_CODE,
                                     p_new_DEDUCTION_CODE,
                                     p_effective_date
                                  );

Line: 1143


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'DISABILITY_STATUS',
                                     p_old_DISABILITY_STATUS,
                                     p_new_DISABILITY_STATUS,
                                     p_effective_date
                                  );

Line: 1152


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'EMP_PROVINCE_TAX_INF_ID',
                                     p_old_EMP_PROVINCE_TAX_INF_ID,
                                     p_new_EMP_PROVINCE_TAX_INF_ID,
                                     p_effective_date
                                  );

Line: 1161


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'EXTRA_INFO_NOT_PROVIDED',
                                     p_old_EXTRA_INFO_NOT_PROVIDED,
                                     p_new_EXTRA_INFO_NOT_PROVIDED,
                                     p_effective_date
                                  );

Line: 1170


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'JURISDICTION_CODE',
                                     p_old_JURISDICTION_CODE,
                                     p_new_JURISDICTION_CODE,
                                     p_effective_date
                                  );

Line: 1179


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'LEGISLATION_CODE',
                                     p_old_LEGISLATION_CODE,
                                     p_new_LEGISLATION_CODE,
                                     p_effective_date
                                  );

Line: 1188


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'MARRIAGE_STATUS',
                                     p_old_MARRIAGE_STATUS,
                                     p_new_MARRIAGE_STATUS,
                                     p_effective_date
                                  );

Line: 1197


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'NON_RESIDENT_STATUS',
                                     p_old_NON_RESIDENT_STATUS,
                                     p_new_NON_RESIDENT_STATUS,
                                     p_effective_date
                                  );

Line: 1206


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'NO_OF_DEPENDANTS',
                                     p_old_NO_OF_DEPENDANTS,
                                     p_new_NO_OF_DEPENDANTS,
                                     p_effective_date
                                  );

Line: 1215


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'NO_OF_INFIRM_DEPENDANTS',
                                     p_old_NO_OF_INFIRM_DEPENDANTS,
                                     p_new_NO_OF_INFIRM_DEPENDANTS,
                                     p_effective_date
                                  );

Line: 1224


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'OTHER_TAX_CREDIT',
                                     p_old_OTHER_TAX_CREDIT,
                                     p_new_OTHER_TAX_CREDIT,
                                     p_effective_date
                                  );

Line: 1233


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'PMED_EXEMPT_FLAG',
                                     p_old_PMED_EXEMPT_FLAG,
                                     p_new_PMED_EXEMPT_FLAG,
                                     p_effective_date
                                  );

Line: 1242


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'PRESCRIBED_ZONE_DEDN_AMT',
                                     p_old_PRESCRIBED_ZONE_DEDN_AMT,
                                     p_new_PRESCRIBED_ZONE_DEDN_AMT,
                                     p_effective_date
                                  );

Line: 1251


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'PROVINCE_CODE',
                                     p_old_PROVINCE_CODE,
                                     p_new_PROVINCE_CODE,
                                     p_effective_date
                                  );

Line: 1260


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'PROV_EXEMPT_FLAG',
                                     p_old_PROV_EXEMPT_FLAG,
                                     p_new_PROV_EXEMPT_FLAG,
                                     p_effective_date
                                  );

Line: 1269


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'PROV_OVERRIDE_AMOUNT',
                                     p_old_PROV_OVERRIDE_AMOUNT,
                                     p_new_PROV_OVERRIDE_AMOUNT,
                                     p_effective_date
                                  );

Line: 1278


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'PROV_OVERRIDE_RATE',
                                     p_old_PROV_OVERRIDE_RATE,
                                     p_new_PROV_OVERRIDE_RATE,
                                     p_effective_date
                                  );

Line: 1287


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'QPP_EXEMPT_FLAG',
                                     p_old_QPP_EXEMPT_FLAG,
                                     p_new_QPP_EXEMPT_FLAG,
                                     p_effective_date
                                  );

Line: 1296


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'TAX_CALC_METHOD',
                                     p_old_TAX_CALC_METHOD,
                                     p_new_TAX_CALC_METHOD,
                                     p_effective_date
                                  );

Line: 1305


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'TAX_CREDIT_AMOUNT',
                                     p_old_TAX_CREDIT_AMOUNT,
                                     p_new_TAX_CREDIT_AMOUNT,
                                     p_effective_date
                                  );

Line: 1314


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'TOTAL_EXPENSE_BY_COMMISSION',
                                     p_old_TOTAL_EXPENSE_BY_COMMISS,
                                     p_new_TOTAL_EXPENSE_BY_COMMISS,
                                     p_effective_date
                                  );

Line: 1323


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'TOTAL_REMNRTN_BY_COMMISSION',
                                     p_old_TOTAL_REMNRTN_BY_COMMISS,
                                     p_new_TOTAL_REMNRTN_BY_COMMISS,
                                     p_effective_date
                                  );

Line: 1332


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'WC_EXEMPT_FLAG',
                                     p_old_WC_EXEMPT_FLAG,
                                     p_new_WC_EXEMPT_FLAG,
                                     p_effective_date
                                  );

Line: 1341


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_F',
                                     'WC_EXEMPT_FLAG',
                                     p_old_WC_EXEMPT_FLAG,
                                     p_new_WC_EXEMPT_FLAG,
                                     p_effective_date
                                  );

Line: 1352


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_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)
                                  );

Line: 1363


    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PAY_CA_EMP_PROV_TAX_INFO_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)
                                  );

Line: 1392


                                            p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
                                            p_business_group_id     => p_business_group_id,
                                            p_surrogate_key         => p_old_EMP_PROVINCE_TAX_INF_ID
                                           );