DBA Data[Home] [Help]

APPS.PAY_CA_EMP_FEDTAX_INF_API dependencies on HR_LOCATIONS

Line 1033: select hrl.country from hr_locations hrl

1029: where paf.assignment_id = p_assignment_id
1030: and p_effective_date between paf.effective_start_date and
1031: paf.effective_end_date ;
1032: cursor csr_get_location(p_location_id number) is
1033: select hrl.country from hr_locations hrl
1034: where hrl.location_id = p_location_id;
1035:
1036: begin
1037: /* Check whether the assignment is present as of that date or not and