DBA Data[Home] [Help]

APPS.PAY_CA_EMP_PRVTAX_INF_API dependencies on HR_LOCATIONS

Line 1135: select hrl.country from hr_locations hrl

1131: where paf.assignment_id = p_assignment_id
1132: and p_effective_date between paf.effective_start_date and
1133: paf.effective_end_date ;
1134: cursor csr_get_location(p_location_id number) is
1135: select hrl.country from hr_locations hrl
1136: where hrl.location_id = p_location_id;
1137:
1138: begin
1139: /* Check whether the assignment is present as of that date or not and the location id of it. Raise error message if assignment is not present or location_id is null */