DBA Data[Home] [Help]

APPS.PAY_COUNTY_TAX_RULE_API dependencies on PER_ASSIGNMENTS_F

Line 16: From Per_Assignments_F

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:

Line 119: l_business_group_id per_assignments_f.business_group_id%TYPE;

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;