DBA Data[Home] [Help]

APPS.PAY_CA_EMP_FEDTAX_INF_API dependencies on HR_LOCATIONS

Line 1049: select hrl.country from hr_locations hrl

1045: where paf.assignment_id = p_assignment_id
1046: and p_effective_date between paf.effective_start_date and
1047: paf.effective_end_date ;
1048: cursor csr_get_location(p_location_id number) is
1049: select hrl.country from hr_locations hrl
1050: where hrl.location_id = p_location_id;
1051:
1052: begin
1053: /* Check whether the assignment is present as of that date or not and