DBA Data[Home] [Help]

APPS.PAY_US_TAX_BALS_ADJ_PKG dependencies on HR_LOCATIONS

Line 1575: FROM HR_LOCATIONS loc,

1571: l_grp_key pay_payroll_actions.legislative_parameters%TYPE;
1572:
1573: CURSOR csr_sdi_check IS
1574: SELECT region_2 primary_asg_state
1575: FROM HR_LOCATIONS loc,
1576: PER_ASSIGNMENTS_F asg,
1577: PER_BUSINESS_GROUPS bg -- Bug fix 1398865. Ensures one row is returned
1578: WHERE asg.assignment_number = p_assignment_number
1579: and asg.business_group_id = bg.business_group_id