2886: l_bg_id,
2887: l_payroll_id
2888: FROM per_business_groups bg,
2889: per_assignments_f a,
2890: hr_soft_coding_keyflex hsk
2891: WHERE a.assignment_number = p_assignment_number
2892: and a.business_group_id = bg.business_group_id
2893: and bg.name ||'' = p_business_group_name
2894: and p_adjustment_date BETWEEN
2959: l_loc_county,
2960: l_loc_city,
2961: l_loc_zip_code
2962: FROM hr_locations HRLOC
2963: , hr_soft_coding_keyflex HRSCKF
2964: , per_all_assignments_f ASSIGN
2965: , pay_us_states PUS
2966: where p_adjustment_date BETWEEN ASSIGN.effective_start_date
2967: AND ASSIGN.effective_end_date