529: WHEN OTHERS THEN
530: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
531: END;
532: --
533: elsif upper(csr_rec.table_name) = 'HR_H2PI_CITY_TAX_RULES' then
534: BEGIN
535: SELECT asg.assignment_number
536: INTO l_assignment_number
537: FROM hr_h2pi_city_tax_rules ctr,
533: elsif upper(csr_rec.table_name) = 'HR_H2PI_CITY_TAX_RULES' then
534: BEGIN
535: SELECT asg.assignment_number
536: INTO l_assignment_number
537: FROM hr_h2pi_city_tax_rules ctr,
538: hr_h2pi_assignments_v asg,
539: hr_h2pi_id_mapping map
540: WHERE ctr.emp_city_tax_rule_id = csr_rec.from_id
541: --AND ctr.business_group_id = l_from_business_group_id