12: l_effective_date date
13: )
14: is
15: Select Business_Group_Id
16: From Per_Assignments_F
17: Where Assignment_Id = l_assignment_id
18: and l_effective_date between effective_start_date
19: and effective_end_date;
20:
115: ) is
116: --
117: -- Declare cursors and local variables
118: --
119: l_business_group_id per_assignments_f.business_group_id%TYPE;
120: l_defaulting_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
121: l_emp_county_tax_rule_id pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;
122: l_effective_start_date pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
123: l_effective_end_date pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;