[Home] [Help]
4290: /* Need to report non zero qpp pensionable earnings in Box G when there
4291: is non zero qpp contribution in Box B as per the new requirement for the case where
4292: maximum pensionable earnings are already reached in non quebec provinces */
4293:
4294: select fnd_number.canonical_to_number(information_value)
4295: into ln_max_cpp_earnings
4296: from pay_ca_legislation_info
4297: where information_type = 'MAX_CPP_EARNINGS'
4298: and l_year_end between start_date
4300:
4301: if lv_cpp_pensionable_earnings = ln_max_cpp_earnings
4302: and to_number(lv_archived_qpp_txble) = 0
4303: and to_number(lv_archived_qpp_whld) <> 0 then
4304: select fnd_number.canonical_to_number(information_value)
4305: into ln_qpp_rate
4306: from pay_ca_legislation_info
4307: where information_type = 'QPP_RATE'
4308: and l_year_end between start_date
4321: ln_no_nz_fi := ln_no_nz_fi +1;
4322: end if;
4323: hr_utility.trace('ln_no_nz_fi5 = '||ln_no_nz_fi);
4324: lv_max_pensionable_earnings := 0;
4325: select fnd_number.canonical_to_number(information_value)
4326: into lv_max_pensionable_earnings
4327: from pay_ca_legislation_info
4328: where information_type = 'MAX_CPP_EARNINGS'
4329: and l_year_end between start_date
4411:
4412: lv_max_pensionable_earnings := 0;
4413: lv_total_pensionable_earnings := 0;
4414:
4415: select fnd_number.canonical_to_number(information_value)
4416: into lv_max_pensionable_earnings
4417: from pay_ca_legislation_info
4418: where information_type = 'MAX_CPP_EARNINGS'
4419: and l_year_end between start_date