APPS.PAY_US_MWR_REPORTING_PKG dependencies on PAY_US_STATES

Line 337: ,pay_us_states pus

333: pus.state_code || '-000-0000',
334: pus.state_abbrev
335: FROM ff_archive_items fai
336: ,ff_user_entities ue
337: ,pay_us_states pus
338: ,hr_locations hl
339: where hl.location_id = fai.value
340: and fai.user_entity_id = ue.user_entity_id
341: and ue.user_entity_name =

Line 624: pay_us_states pus

620: CURSOR asg_with_action_loc_id IS
621: SELECT paaf.location_id
622: FROM per_all_assignments_f paaf,
623: hr_locations_all hl,
624: pay_us_states pus
625: WHERE paaf.effective_start_date <= p_effective_date
626: AND paaf.effective_end_date >= trunc(p_effective_date,'Q')
627: AND paaf.assignment_id = p_assignment_id
628: AND paaf.business_group_id = p_business_group_id

Line 649: pay_us_states pus

645: CURSOR assignment_loc_id IS
646: SELECT paaf.location_id
647: FROM per_all_assignments_f paaf,
648: hr_locations_all hl,
649: pay_us_states pus
650: WHERE paaf.effective_start_date <= p_effective_date
651: AND paaf.effective_end_date >= trunc(p_effective_date,'Q')
652: AND paaf.assignment_id = p_assignment_id
653: AND paaf.business_group_id = p_business_group_id

Line 940: FROM pay_us_states

936:
937: -- Need to verify if there is a SUI State Change for this Assignment
938: --# 11936382 Start
939: SELECT state_code INTO l_month_count_code
940: FROM pay_us_states
941: WHERE state_abbrev = l_month_count_state_code;
942: l_state_count := check_sui_state_change ( l_ass_id
943: ,l_business_group_id
944: ,l_tax_unit_id