APPS.PAY_US_TAX_BALS_ADJ_PKG dependencies on PER_ASSIGNMENTS_F

Line 1576: PER_ASSIGNMENTS_F asg,

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
1580: and bg.name ||'' = p_business_group_name

Line 1591: PER_ASSIGNMENTS_F a,

1587: CURSOR csr_sui_geocode IS
1588: SELECT sui_jurisdiction_code,
1589: pus.state_abbrev
1590: FROM PAY_US_EMP_FED_TAX_RULES_F fed,
1591: PER_ASSIGNMENTS_F a,
1592: PER_BUSINESS_GROUPS bg,
1593: pay_us_states pus
1594: WHERE fed.assignment_id = a.assignment_id
1595: and a.assignment_number = p_assignment_number

Line 1658: PER_ASSIGNMENTS_F a

1654: a.business_group_id
1655: INTO l_assignment_id,
1656: l_bg_id
1657: FROM PER_BUSINESS_GROUPS bg,
1658: PER_ASSIGNMENTS_F a
1659: WHERE a.assignment_number = p_assignment_number
1660: and a.business_group_id = bg.business_group_id
1661: and bg.name ||'' = p_business_group_name
1662: and p_adjustment_date BETWEEN

Line 1833: PER_ASSIGNMENTS_F a

1829: a.business_group_id
1830: INTO l_assignment_id,
1831: l_bg_id
1832: FROM PER_BUSINESS_GROUPS bg,
1833: PER_ASSIGNMENTS_F a
1834: WHERE a.assignment_number = p_assignment_number
1835: and a.business_group_id = bg.business_group_id
1836: and bg.name ||'' = p_business_group_name
1837: and p_adjustment_date BETWEEN