DBA Data[Home] [Help]

APPS.HR_H2PI_ERROR dependencies on HR_H2PI_STATE_TAX_RULES

Line 485: elsif upper(csr_rec.table_name) = 'HR_H2PI_STATE_TAX_RULES' then

481: null;
482: WHEN OTHERS THEN
483: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
484: END;
485: elsif upper(csr_rec.table_name) = 'HR_H2PI_STATE_TAX_RULES' then
486: BEGIN
487: SELECT asg.assignment_number
488: INTO l_assignment_number
489: FROM hr_h2pi_state_tax_rules str,

Line 489: FROM hr_h2pi_state_tax_rules str,

485: elsif upper(csr_rec.table_name) = 'HR_H2PI_STATE_TAX_RULES' then
486: BEGIN
487: SELECT asg.assignment_number
488: INTO l_assignment_number
489: FROM hr_h2pi_state_tax_rules str,
490: hr_h2pi_assignments_v asg,
491: hr_h2pi_id_mapping map
492: WHERE str.emp_state_tax_rule_id = csr_rec.from_id
493: --AND str.business_group_id = l_from_business_group_id