39: --AND hr_general.chk_product_installed('801') = 'TRUE'
40: AND hr_general2.is_legislation_install('PAY','US')
41: ) THEN
42: close csr_emp_assign;
43: hr_utility.set_message (800, 'Address_Cannot_be_Primary');
44: hr_utility.raise_error;
45: END IF;
46: close csr_emp_assign;
47: END CREATE_US_ADDRESS;
40: AND hr_general2.is_legislation_install('PAY','US')
41: ) THEN
42: close csr_emp_assign;
43: hr_utility.set_message (800, 'Address_Cannot_be_Primary');
44: hr_utility.raise_error;
45: END IF;
46: close csr_emp_assign;
47: END CREATE_US_ADDRESS;
48:
80: --AND hr_general.chk_product_installed('801') = 'TRUE'
81: AND hr_general2.is_legislation_install('PAY','US')
82: ) THEN
83: close csr_emp_assign;
84: hr_utility.set_message (800, 'Address_Cannot_be_Primary');
85: hr_utility.raise_error;
86: END IF;
87: close csr_emp_assign;
88:
81: AND hr_general2.is_legislation_install('PAY','US')
82: ) THEN
83: close csr_emp_assign;
84: hr_utility.set_message (800, 'Address_Cannot_be_Primary');
85: hr_utility.raise_error;
86: END IF;
87: close csr_emp_assign;
88:
89: null;