DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_API dependencies on PER_ADDRESSES

Line 2575: PER_ADDRESSES addr

2571: addr.region_2) primary_asg_state
2572: FROM HR_LOCATIONS loc,
2573: PER_ASSIGNMENTS_F asg,
2574: PER_BUSINESS_GROUPS bg,
2575: PER_ADDRESSES addr
2576: -- Bug fix 1398865. Ensures one row is returned
2577: WHERE asg.assignment_number = p_assignment_number
2578: and asg.business_group_id = bg.business_group_id
2579: and bg.name ||'' = p_business_group_name

Line 2934: FROM per_addresses ADDR

2930: INTO l_per_state_abbrev,
2931: l_per_county,
2932: l_per_city,
2933: l_per_zip_code
2934: FROM per_addresses ADDR
2935: ,per_all_assignments_f ASSIGN
2936: ,pay_us_states PUS
2937: where p_adjustment_date BETWEEN ASSIGN.effective_start_date
2938: AND ASSIGN.effective_end_date